What's new in Investment Account Manager 3.3.4
Apr 3, 2024
- modified the default column order for changes made by Charles Schwab for csv transaction import function.
- modified the start up to skip some checks that were delaying the start of the program, if the program had previously changed fields for the upcoming IAMv4 release.
- modified and corrected portfolio performance report to trap out arithmetic errors due to invalid user entry resulting in 9091.91 as IRR result.
- correction to apply exercised call activity for multiple open buy lots.
- corrections for exercised and assigned option activity within custom date range on performance report.
- corrections to 'as of date' reporting for merger activity that includes 'boot rule' return of capital activity.
- corrections for additional program errors/error logs as reported by users.
New in Investment Account Manager 3.3.3 (Jan 3, 2024)
- Added new startup function to verify user database records are in correct sort order, verify record tags properly defined as required for future program conversion.
- Modified import functions to properly define fixed income (bond types) as interest if error within csv, ofx files as provided by broker.
- Modified ofx download to improve download of current balances, sort option activity for Fidelity downloads, map if broker sort order incorrect for income and reinvest activity.
- Modified csv import to improve import for options activity expired, open sale, buy to cover.
- Modified Schwab csv import function to identify as Schwab file based on new file format.
- Modified performance functions monthly, quarterly to reset upper limits to avoid user data errors, include proper ending value for open sale activity.
- Modified copyright date to 2024.
- Additional program errors/error logs as reported by users.
New in Investment Account Manager 3.3.1 (Sep 21, 2023)
- Changed the performance report and the summary report to allow for more than 10 indices to be listed on the reports.
- Changed Quotemedia data feed for new delivery method of S&P sector for common stocks.
- Changed csv import program to create add'l internal record when importing a 'transfer-in' record.
- Changed import of creating new portfolio using ofx/qfx files to allow user to add current cash/money market balance as part of portfolio setup.
- Improved Quicken .qif import for creating a new portfolio / importing of subsequent .qif file activity.
- Corrected Transfers Audit Report to include user transactions notes.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.3.0 (May 2, 2023)
- Changed mutual fund and exchange traded fund data updates to use new QuoteMedia data delivery service.
- Changed historic import when creating a new portfolio with CSV files to ignore cash offsets, allowing user to add cash balance at the end of import process.
- Corrected batch reporting to show adjusted values for benchmark prices on the performance reports.
- Corrected error to update automatically benchmark returns when month-end historic prices are added.
- Corrected error on IAM home page when returns are automatically updated when month-end historical prices are added.
- Corrected CSV import of assigned and exercised options.
- Corrected Appraisal Report to always show the second heading on the home page if the report is for an "as-of-date".
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.8 (Jul 6, 2022)
- Added to the import prices program so that it will allow the option code to be used as the symbol instead of the symbol created by IAM.
- Added option fields when creating historic prices in all programs that create historic prices.
- Added report option for 'current only' to Transactions Activity report.
- Added Schwab Institutional import based on the headers to the CSV import program.
- Modified Schwab Institutional import to not include "Auto Bank Sweep" transactions.
- Modified historic asset library export to use the full 21 character option symbol instead of the short symbol.
- Modified .csv import so if a user finds the correct preferred symbol, the program will change all of those symbols in the import.
- Modified .csv import program to recognize a MoneyLink transfer as an ACH withdrawal.
- Corrected IAM home page to properly graph last 12 quarters for Summary Tab | Performance Graph.
- Corrected transactions entry ledger for missing variable when selecting from the IAM home page.
- Corrected delete of a return of capital transaction to properly restore original lots without rounding errors.
- Corrected .csv import file for proper date order when handling both opening sale and closing buy on same day.
- Corrected .csv import file to handle assigned puts with multiple opening sales records.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.7 (Mar 2, 2022)
- Added to home page | portfolio summary tab the option to show a line graph depicting the portfolio performance for user defined date ranges: year to date, last year, last 12 months, last 12 quarters, last 12 years.
- Expanded available thresholds for defining Small Capitalization Parameter to 2000 ($2 billion).
- Corrected security ledger when filtered by individual security and inability to properly select another from drop-down list.
- Corrected price updating for index pricing due to recent change by data provider.
- Corrected import of a csv file to properly process 'foreign tax paid'.
- Corrected portfolio performance report for displayed values when a spinoff occurs within the report range.
- Updated copyright to reflect 2022.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.6 (Dec 17, 2021)
- Added reporting option for Level 1 Allocation by Stock Sector, included additional user option to print Stock / Fund Sector Analysis report (cost / gain_loss).
- added memory variable to recall last directory location when importing transactional csv files.
- added symbol to name dropdown in transactions ledger when selecting to filter by individual security.
- changed naming of Stock and Fund Allocation by Sector report to Stock / Fund Sector Analysis report, moved this report to group with portfolio allocation and fund objective reports.
- changed Transactions Activity Report | Transfers to show transfer value in place of original cost basis.
- corrected Appraisal Report 'Cost Yield' calculation for cash equivalents (C), cash money market fund types (M).
- corrected Home Page | Positions tab | % Gain/Loss calculation for options (O) when both long and short held.
- corrected portfolio performance returns table to properly re-derive prior month returns when deleted and re-adding.
- corrected T Rowe Price account download access for changes made by TRP.
- corrected error for historical price library and user defined choice for pricing source.
- corrected pricing issues for changes implemented by Yahoo! Finance.
- corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.5 (Dec 17, 2021)
- Added reporting option to Portfolio Summary Report to report by Symbol.
- Added reporting option to Home Page | Portfolio Summary Tab to filter/sort by Symbol.
- Added 'Day Value Change' reporting option to Home Page | Positions Tab.
- Added 'Manual Entry' option when creating historical price dates.
- Corrected error in creating historic price library dates.
- Corrected reporting function to show historic as-of-date Level 1 Allocation Rebalancing for fund investment objectives.
- Corrected reporting function to show historic as-of-date Fund Investment Objectives.
- Corrected reporting function to show historic as-of-date Stock and Fund Allocation by Sector.
- Corrected additional program errors/error logs as reported by users
New in Investment Account Manager 3.2.4 (Jul 2, 2021)
- added daily and historical QuoteMedia pricing for Bitcoin / Cryptocurrency.
- modified Schwab transactional OFX downloads so users can once again automatically download account data.
- modified Allocation Rebalancing Level 1 Report to allow, when multiple portfolios selected, the ability to show security details by asset class.
- corrected error in creating a new historic price library, when entering and then cancelling the historic date entry.
- corrected error in restore function and recreating user defined preferences table.
- corrected csv price file import.
- corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.3 (Feb 15, 2021)
- Modified Schwab transaction csv import file to properly handle margin interest with offsetting deduction.
- Modified Schwab transaction csv import file to properly handle fund gain distributions.
- Modified Vanguard download for additional changes made by Vanguard for permitted user access.
- Modified historic price download functions for recent file formatting change of received QuoteMedia data.
- Corrected batch reporting | holdings summary report error.
- Corrected portfolio performance report for [ ] include sub-totals for tender/exchange activity and resulting portfolio return.
- Corrected level 2 | sector allocation report for missing mutual funds and exchange traded funds.
- Corrected 'find next' function on IAM home page after a user transaction edit/save.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.2 (Feb 15, 2021)
- Added functionality to Benchmark Indices Return tab to allow for export of stored monthly data results.
- Added functionality to Portfolio Performance Return tab to allow for export of stored monthly data results.
- Added sort ability to Portfolio Holdings Report to allow sort by either 'Percent Portfolio' or by 'Security Name'.
- Added to Historic Prices | Edit Tab a 'lookup link' to QuoteMedia Historical prices website page.
- Added to Tools Menu | Calendar a new print function to show date alerts/notes for user defined date range.
- Added / Modified Common Stock Allocation Report by Sector to now include 'sector specific' mutual funds and exchange traded funds. Renamed report to Stock and Fund Allocation by Sector.
- Modified transaction csv import file to include new default format for Charles Schwab brokerage accounts.
- Modified broker download to correct for recent change by Vanguard.
- Corrected QuoteMedia import for recent change in XML name format when updating mutual funds and exchange traded funds.
- Corrected QuoteMedia import for recent change in XML investment objective format when updating mutual funds and exchange traded funds.
- Corrected QuoteMedia import for recent change in XML for Canadian mutual funds.
- Corrected broker OFX download for accessing duplicate portfolio name.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.1 (Feb 15, 2021)
- Modified OFX broker download from Vanguard for recent changes initiated on the Vanguard site so users can once again automatically download investment activity.
- Modified the program which imports OFX files as well as the one that imports transactions so the money market account deposits and withdrawals are not duplicated when the file is received from Vanguard.
- Modified bank transactions that show as OTHER in the Vanguard OFX file. Changed them so they are not automatically added to the records to post.
- Modified the number of fields in the "Import Transactions CSV" download screen to have more fields on the screen.
- Modified the benchmark indices form so the last date updated is also checked when updating benchmark values.
- Modified the update for the 7Twelve values to the historic asset library if the 7Twelve index is one of the benchmarks indices.
- Modified the bond preference screen to the Import Positions CSV program if a bond is being imported.
- Corrected the program that gets historic asset prices so that any securities that are flagged to not get online prices will just bring over the price from the current asset library instead writing over the price.
- Corrected the error that caused the program to give an error rather than open when the user entered their password and pressed the "Log In" button.
- Corrected the error that caused the post button to not always work on the import transactions form.
- Corrected transactions in any OFX file that has been downloaded or is being imported to make sure that options that are showing they are being assigned when they should really should be exercised to exercised.
- Corrected the performance report where subtotals were causing a numeric overflow.
- Corrected the problem when importing a transactions csv file and opening the home page after adding securities to the current asset library.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.2.0 (Feb 15, 2021)
- Added new user option to show the symbol on the Portfolio Performance Report.
- Added to the Portfolio Performance Report IRR by asset type sub totals.
- Added new user option to show fund category subtotals on the Fund Investment Objectives Report.
- Added code to prevent users from saving the Copy/Combine portfolios if no new portfolio name is entered.
- Modified historical pricing due to changes made by Yahoo! Finance and historical index pricing.
- Modified all of the URL's to start with HTTPS that are sent to Quote Media.
- Corrected "as of date" reports to not show transactions that were transferred into the portfolio after the "as of date".
- Corrected programs that create records in the historical asset library to also include securities that do not get prices online.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.9 (Feb 15, 2021)
- Modified icons to a larger size on the toolbar, added new icon for 'tutorials'.
- Corrected error that does FIFO sales in the background to handle opening sales and closing buys.
- Corrected error that allows transactions to be sold to be selected if the quantity is negative.
- Corrected error for expired options that had multiple opening sales to create the correct records.
- Corrected forms that download historic dates to make sure that they ignore securities that have the "no online" price flag set to true.
- Corrected "Update Prices" from the toolbar so it doesn't try to update mutual fund prices from Yahoo after updating from QuoteMedia.
- Corrected error in program to not open other forms if the portfolios form is open.
- Corrected the performance report when the income record is on the same date as the ending sale date and there are transfers in the portfolio.
- Corrected renewal program to not subtract a day from the year when renewing the program.
- Corrected activity ledger to not give the error "Record out or range" when changing from looking for money market funds in only the current portfolio to looking at all securities.
- Corrected broker download for assigned option activity.
- Correct broker audit report to allow memo/notes to show full content.
- Corrected additional program errors/error logs as reported by users.
- Updated copyright to reflect 2020.
New in Investment Account Manager 3.1.8 (Feb 15, 2021)
- Added Raymond James to the brokerages that can be used for downloading OFX data.
- Modified forms used to download all current positions.
- Modified user name and password to always be saved when the account number is saved when downloading all current positions.
- Modified all programs that use the QuoteMedia data feed for populating mutual fund and exchange traded fund composition details, no longer providing the fund sector/size level 2 allocations and no longer providing past 1,3,5 and 10 year fund comparison performance due to QuoteMedia-Morningstar pricing/lack of user demand for these details.
- Corrected all programs which get historic month-end pricing data when month end date is on a weekend.
- Corrected all programs which show those prices not downloaded so they do not show prices downloaded from QuoteMedia.
- Corrected the allocation tab for the home page to show the correct columns.
- Corrected problem with money market symbol being changed to another symbol in the Quicken import.
- Corrected the program which verifies original cost basis of transfers to not combine costs from multiple transfers made on the same day for proper 'as of date' periods.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.7 (Feb 15, 2021)
- Added historical prices from QuoteMedia to all screens which download history.
- Added function to retrieve matching transfer date historical price for securities when transferred into a new portfolio.
- Added a dropdown for "TranfersIn" to the import transactions screen so they can be changed to a different transaction type.
- Added function to populate as available tax basis lots when downloading current positions to a new portfolio.
- Added function to populate as available the year end history when downloading current positions to a new portfolio.
- Added a new form for importing transactions when downloading all transactions from financial institutions.
- Added function to the edit transaction screen so historical lots with proper cost basis can be more easily added for a security.
- Added new preference setting to include/exclude from the home page display the tabs for Level 2 Allocations and Fundamentals.
- Modified sort order of transactions that are transferred into the portfolio.
- Modified the refresh button on the positions tab of the home page to show all activity if the dropdown shows "Include All Dates".
- Modified the add benchmark index screen to get Canadian symbols from QuoteMedia.
- Modified the account information box for a new portfolio and the edit screen of a portfolio.
- Modified home page preferences to: never bypass price alerts on startup, always use available broker files for price updating as part of transactional downloads, and to omit the display of the current asset library after price updating.
- Modified home page | allocations tab | to default open view to 'breakdown'.
- Corrected forms that downloaded current prices to get prices for Canadian symbols.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.6 (Feb 15, 2021)
- Added export/import function for Yahoo! Finance Portfolio.
- Added use of 7Twelve Portfolio as a comparison benchmark index.
- Changed the programs that get updates from Quote Media to look for :CA instead of .TO at the end of the security symbol.
- Changed the performance report to handle dividends and expenses after all shares have been sold.
- Changed the ledger to not show "False" as a choice in the securities dropdown if all securities have been sold.
- Corrected the ledger to add the offsetting deposit if a withdrawal is made from another MMF.
- Corrected the ledger to add the underlying symbol to the name dropdown if an option is added.
- Corrected the option code created when a new option is added to the current asset library if the strike price is eight digits instead of seven digits.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.5 (Feb 15, 2021)
- Added for QuoteMedia subscribers a 'Daily Price Change' report to IAM3 Home Page | Portfolio Summary Tab | Snapshot.
- Added to IAM Home Page | Positions tab subtotals by asset type with % gain/loss.
- Added to IAM File Menu | Preferences | Home Page tab user preferences choice to show as default either the IAM Summary Tab or the IAM Positions Tab.
- Added to IAM File Menu | Preferences | Home Page tab user preferences for including recalculate/refresh of Allocations and All Portfolios Tabs when updating market pricing and new portfolio activity.
- Removed Google Finance from pricing sources due to errors/changes implemented by Google limiting quote requests.
- Corrected Level 2 Sector Allocation reports to list Communication Services in alphabetic order.
- Corrected pricing update features to exclude those symbols including invalid # character.
- Corrected OFX import to accept transactions without a valid name, allowing user to designate properly prior to import.
- Corrected portfolio performance and portfolio summary report for short options with closing activity within selected date range.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.4 (Feb 15, 2021)
- Added new import of transaction file in csv format when creating a new portfolio, or for appending newer activity to an existing portfolio.
- Modified sector allocation category/reports/graphs for S&P 500 naming change: Telecommunications Services to Communication Services.
- Modified OFX import files to treat a CREDIT as a withdrawal for cash equivalents that are maturing.
- Modified password entry field length for up to 30 characters for broker investment account login.
- Corrected transaction ledger to save the notes to the portfolio as part of the program that sells all of the transactions as part of a sale.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.3 (Feb 15, 2021)
- Resolved market pricing issues due to changes implemented by QuoteMedia on July 31st, 2018.
- Corrected error in fund investment objectives report and fund performance comparison report if only a single investment objective was selected.
- Corrected estimated income report/tab display to list estimated income for cash/money market funds.
- Corrected combined appraisal report for missing %gain/loss, page two, first security detail line.
- Corrected transactions activity ledger, security drop down list, to not show cash/money market funds that have no current balance, if preference is set to 'open only'.
- Corrected money market offset issues when using multiple 'closing' transactions for multiple open option positions.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.1.2 (May 23, 2018)
- Modified broker download for Wells Fargo Advisors and Ameriprise
- Financial Services to accept new required Client User Identification number.
- Corrected Portfolio Transfers Report to list all transfers within user defined date ranges.
- Corrected formatting issues with the Appraisal Report.
- Corrected error in historical price downloads for invalid dates.
- Corrected additional program errors/error logs as reported by users.
New in Investment Account Manager 3.0.6 (Jul 18, 2017)
- Improvements:
- Added to QuoteMedia Data Feed the ability to auto-populate mutual fund and exchange traded fund composition details for: asset type, sector and size; investment objective; year to date, 1 year, 3 year, 5 year, 10 year performance; turnover and expense ratio.
- Added a 'calc balances' check box to new transactions entry ledger.
- Added beta variable to the Appraisal Report when including diversification graphing option.
- Added 'strike-out' to broker download forms to identify duplicate activity.
- Added to Maturity Schedule red font color for negative values.
- Added to Fund Diversifications Report new sector category for Real Estate.
- Added to income/reinvestment transaction the ability to also deposit any cash-in-lieu for fractional shares not received.
- Added future settlement date activity to show on home page | transactions views.
- Added to 'download positions' form ability to hide/show user name and password.
- Added user preference to 'recall' use of security symbol when entering activity in the new transactions entry ledger.
- Added user preference to 'classic ledger' a check box variable to use trade date = settle date.
- Added user preference under the file menu | preferences | home page tab to [ ] show current asset library as part of price updating process.
- Changes:
- Changed QuoteMedia data feed for changes in delivery of data items.
- Changed broker access to T. Rowe Price for new required broker credentials.
- Changed broker access to Janney Montgomery Scott for new required broker credentials.
- Changed broker access for recent changes implemented by Wells Fargo Advisors.
- Changed broker access for recent changes implemented by First Clearing.
- Corrections:
- Corrected historical pricing issues due to changes made by Yahoo! Finance.
- Corrected Income Received Report for report title issue.
- Corrected broker import for duplicate money market offsets popup note message.
- Corrected benchmark performance table for manual entry/deriving monthly returns.
- Corrected additional program errors/error logs as reported by users.
- Corrected ^dji index and option pricing due to changes made by Yahoo! Finance.
- Corrected Security Basis Report to print user preference | report title.
- Corrected additional program errors/error logs as reported by users.
- Corrected backup feature for change drive location selection.
- Corrected delete function for Benchmark Indices Returns Tab.
- Corrected activity ledger for showing the cancel/save buttons prior to entering new activity.
- Corrected functionality for posting return of capital activity as part of broker downloads.
- Corrected numeric overflow error in Benchmarks / Portfolio returns feature.
- Corrected error in Portfolio Allocation Level 1 as of date report for money market funds.
- Corrected error in Portfolio Summary as of date allocation graph for money market funds.
- Corrected error on Portfolio Performance Report for partially closed option contracts prior to the exercise/assign of any remaining balance.
- Corrected error when importing Quicken qif files.
- Corrected error for open sale option activity to show proper MMF deposit offset in new transactions entry ledger.
- Corrected All Portfolios tab for grouping issue.
- Corrected All Portfolios tab for auto-refresh after broker downloads.
- Corrected Appraisal Report for estimated yield percentage and cost on yield percentage.
- Corrected Allocation Summary Level 1 tab report to display properly for target allocations.
- Corrected running balance totals in activity ledger for open sale/closing buy transactions.
New in Investment Account Manager 3.0.1 (Dec 21, 2016)
- added to QuoteMedia Data Feed the ability to auto-populate mutual fund and exchange traded fund composition details for:
- asset type, sector and size;
- investment objective;
- year to date, 1 year, 3 year, 5 year, 10 year performance;
- turnover and expense ratio.
- added a 'calc balances' check box to new transactions entry ledger.
- added beta variable to the Appraisal Report when including diversification graphing option.
- added 'strike-out' to broker download forms to identify duplicate activity.
- added to Maturity Schedule red font color for negative values.
- added to Fund Diversifications Report new sector category for Real Estate.
- added to income/reinvestment transaction the ability to also deposit any cash-in-lieu for fractional shares not received.
- added future settlement date activity to show on home page | transactions views.
- corrected broker downloads for recent changes implemented by Wells Fargo Advisors.
- corrected broker downloads for recent changes implemented by First Clearing.
- corrected error when importing Quicken qif files.
- corrected error for open sale option activity to show proper MMF deposit offset in new transactions entry ledger.
- corrected All Portfolios tab for grouping issue.
- corrected All Portfolios tab for auto-refresh after broker downloads.
- corrected Appraisal Report for estimated yield percentage and cost on yield percentage.
- corrected Allocation Summary Level 1 tab report to display properly for target allocations.
- corrected running balance totals in activity ledger for open sale/closing buy transactions.
- corrected additional program errors/error logs as reported by users.