Recent Posts

Pages: 1 ... 6 7 [8] 9 10
Support / Using IAM's Utility Program to Repair the Program
« Last post by Peter Willms on August 16, 2018, 11:30:42 AM »
Investment Account Manager's Utility Program is designed to fix problems that might occur when an error is caused by abnormal shut-down, conflict with another program such as a firewall or anti-virus, etc. The utilities repairs these types of issues, as well as providing solutions to other issues.

To access the Utility Program:

Close IAM if it is open.
Select Windows Start Menu | then all apps (programs).
Find the Investment Account Manager 3 program group and open it.
Within the program group, click on IAM3 Utilities.

The following repair utilities are available:

Backup Data: This utility allows you to backup your data from outside IAM. Useful if you cannot open IAM, and do not have a recent backup.

Delete Backup Directories: This will delete the backup directories that you choose. Useful if you wish to cleanup your backup folder. Backups are sorted by date.

Fix Portfolio Memo Fields: If you are getting an error that shows that the memo file is missing or invalid, run this utility. This is error 41.

Pak and Re-index Database: Packing files removes deleted records and compacts notes and data. This will reduce the size of the files and speed up the program.

Portfolio Diagnostic: This diagnostic tool will scan all portfolios in Investment Account Manager, identifying discrepancies between the quantity shown on reports and the quantity calculated on the Portfolio Activity Ledger.

Register Crystal Controls: If you can't get reports to display, you may need to re-register the Crystal Reports controls. This program should find the correct directory to register these controls. You must have administrator privileges to register these controls. When starting the utility program, right-click and choose "Run as Admin".

Register OLE Controls (run as administrator): Re-register all of the OLE (object linking and embedding system to link databases and programs) controls. You must have administrator privileges to register OLE controls. When starting the utility program, right-click and choose "Run as Admin". If the IAM's calculator tool and/or calculator aren't working.

Remove Your Password: This will remove the password from the Investment Account Manager program.

Repair Corrupted Files: If you can't open the program because the program says that it is already running, this should correct the problem. It will also fix other database problems that might prevent you from opening IAM3.

Repair Database: If your program will not open and you get a message that says "File ... rk.dbc does not exist", this might fix the database. It will also fix other database problems that might prevent you from opening IAM3. NOTE: It will not work if you have never packed your database.

Update Program: If you downloaded a newer version of the program, but the program will not update because it is installed under \Program Files, use this program to install the update.

NOTE: You must change the "Unzip to Folder" to the directory where your Investment Account Manager program was installed.

View Error Log: If a program error occurs while using Investment Account Manager, an entry of the error is automatically created in the error log. Any error can be printed or saved to your clipboard to send to technical support.

Reporting / Batch Reporting with Investment Account Manager
« Last post by Peter Willms on August 16, 2018, 11:05:02 AM »
Batch Reporting
The Batch Reporting feature allows users to produce a series of reports for a selected list of portfolios.  Users can define which portfolios to include, and what reports, for specific time periods.

Select Portfolios: select the portfolio(s) to be used for the batch reporting process.  Use the Mark All or Clear All button to select/clear portfolios.

Select Reports: select reports to be used for the batch reporting process.  Use the Mark All or Clear All button to select/clear reports.

Report Period: depending on the selected report, users can select the reporting period for the batch reporting process.  This includes All Dates, Predefined Date Ranges, Custom Date Ranges, or As of Date. 

Start Date: starting date range for selected report period.

End Date: ending date range for selected reporting period.

Report Choice: depending on the selected report, check the additional reporting option as available.  These include: By Monthly Totals, By Holding Period, and Exclude Options. 

Margins: set report margins.

Include Printer Setup: use this option to be prompted with the printer setup dialogue form prior to printing reports. You'll be able to select a specific printer, quality preferences, and other printer options.

Preview Reports: use this option to view a preview of the report prior to printing.

Export to PDF:
use this option to create PDF output of the selected batch report(s).


The following fundamental ratios will be derived using the data in the Current Asset Library.  These ratios are displayed on the Asset Library Menu | Current Asset library | Valuation Ratios tab.  Additionally, the Fundamentals tab found on IAM's Home Page which also displays this information for the open portfolio.

Current Yield %: if you are an investor seeking income as well as growth, current yield will indicate if the company is paying a dividend, and if the rate of payment is sufficient to meet your requirements. Current yield is calculated by the current dividend per share divided by current market price. Dividend yield is a useful measurement that can be compared to the yield on alternative investments i.e., T-Bills, Money Market Funds, Stocks, etc.) in order to select investments based on their ability to generate investment income. The dividend yield can provide an indication of the safety of the dividend. For example, a higher dividend yield may indicate that the market anticipates lower earnings and a subsequent dividend cut, and this expectation has resulted in a lower market price.

Cash Flow/Current Dividend: the cash flow/current dividend relationship is important because at times, for any number of reasons, a company may not be "earning" their yearly dividend. Investors worried about the sustainability of the dividend should be concerned if the cash flow per share covers the dividend. This is because dividends (and the earning power of a company) are really dependent on the cash flow generated by a firm. The larger the value produced by the ratio, the more secure the dividend.

Dividend Payout Ratio %: this ratio shows what percentage a company is paying out its earnings (current dividends per share divided by current earnings per share. In general, the lower the number, the more secure the dividend. When the current payout ratio is below historical norms, a company will often times gradually increase the rate of dividend growth (resulting in a faster rising current dividend rate) in an effort to get back on track with their history. Likewise, if the current payout ratio is higher than historical norms, a company will gradually decrease the rate of dividend growth (resulting in a slower rising current dividend rate) in an effort to reduce the payout ratio to historical levels.

Dividend Payout Ratio % 2: this ratio shows an estimate of the forward-looking company payout (current dividends per share divided by projected earnings per share). Comparing the current payout ratio to the projected payout ratio can provide insight into the security of the dividend rate, the expected growth of the dividend rate, as well as the direction of earnings per share.

Price/Earnings (P/E): perhaps the most frequently used ratio to judge the degree of valuation for a security, P/E is simply current market price divided current earnings per share. Some general guidelines in the use of the P/E ratio include:

  • The future level of the P/E ratio can be viewed as a function of the current P/E ratio or an average P/E ratio over some period of time.

  • The P/E ratio is a function of future expected earnings. The higher the growth rate of earnings expected, the higher the current P/E ratio. An investor will be willing to pay a higher price for a dollar of current earnings if earnings are expected to grow at a much higher rate in the future.

  • P/E ratios can change radically and suddenly because of a change in the expected growth rate of earnings. Therefore, the greater the expected stability in the growth rate of earnings per share, the higher the P/E.

  • P/E ratios tend to be inversely correlated with inflation.

  • High interest rates tend to reduce P/E ratios.

  • The higher the P/E ratio relative to the market, the higher the risk.

  • P/E ratios vary by industry.

Projected P/E: Projected P/E is simply current market price divided by projected earnings per share. Look for the projected P/E ratio to be less than the current P/E ratio. If the projected P/E is lower, it must be due to higher projected earnings for the stock, a desired condition. If the projected P/E is higher, it must be due to lower projected earnings for the stock, a negative condition. Be sure to compare the projected P/E with the average P/E of past years for an indication of future performance.

PEG Ratio: one of the "Famous Numbers" from Peter Lynch's book One Up On Wall Street4, this relationship compares earnings growth with the price/earnings ratio, the principle being that the market values a stock so that it sells at a price that reflects its earnings potential. The PEG ratio is derived by the Current P/E Ratio Projected Earnings Growth %. The higher the expected growth rate of earnings, the higher the current P/E ratio ought to be. In general, the P/E ratio of a company that is fairly priced will equal its growth rate. If the P/E ratio is less than the growth rate, the PEG value will be less than 1.0, suggesting a possible bargain; if the P/E ratio is greater than the growth rate, the PEG value will be greater than 1.0, suggesting a premium is being paid for the security. If the PEG ratio is above 1.5, the security may be vulnerable to a sharp drop in price if earnings per share growth departs from investor's expectations.

Market Price/Cash Flow per Share & Return on Cash Flow %: Market price/cash flow per share gives an indication of what ratio a stock is trading at in relation to the cash flow being generated from operations after all cash expenses have been subtracted. To better understand this ratio, the inverse of the ratio can be used to derive the return on cash flow.6 For example, a $10 stock with $1 per share in annual cash flow has a 10-to-1 ratio. The inverse of this 10-to-1 ratio, 10 percent, closely matches the ten percent that an investor expects to receive for owning stocks long term. A $20 stock with a $4 per share cash flow gives a 20 percent return on cash. Look for companies that, given a high sustainable cash flow per share (preferably free cash flow per share), result in an attractive return on cash flow percent.

Market Price/Book Value per Share: the market price/book value ratio gives an idea of how a security is trading in relation to its book value. A low relative market price to book value ratio usually suggests that the company is undervalued. This is because a company's book value represents, all else being equal, the value at which a firm always has the option to liquidate, or sell-off of its assets. A low market-to-book value ratio is seen as providing a "margin of safety" and in some cases, is considered the "floor" supporting the market price. However, it should be noted that as some companies adopt more creative accounting policies and/or as the rules of FASB (Federal Accounting Standards Board) change, the resulting book value may not accurately reflect the market values of assets. Also, the productivity of assets, the combination of assets and entrepreneurial ability often create greater earnings and greater values than the book value of the assets suggests. When considering book value, use a reliable source that provides a good understanding of market values of assets.

Return On Equity: this value shows how much is being earned each year by the company, where the higher the percent returned, the better for the investor (note: a high debt level can also increase ROE, however the return will be riskier). Return on equity is computed by dividing earnings per share by book value per share. As a growth investor, you want to see steady or rising return on equity.
Fundamental ratio analysis is an investment approach that focuses on specific relationships, or ratios, of the financial data of a company.  This method offers a "snap shot" of a company's value, where the analysis is a review of a firm's financial report.

Recognizing the importance of these relationships and ratios, the Investment Account Manager provides the investor with a comprehensive set of variables that can be used to derive informative ratios that may be helpful in discovering undervalued securities.

When using IAM with QuoteMedia, the required fundamental data can be automatically downloaded.  If not, this fundamental data can also be manually entered into IAM.  Regardless, prior to using the valuation ratios provided by Investment Account Manager, you'll want to be certain you've updated your Current Asset Library asset library to reflect up to date data.  Once the fundamental data has been entered, users can review the various fundamental ratios provided by Investment Account Manager (see image below).

Q: How do I use the Price Alerts feature in Investment Account Manager?

The Price Alerts feature is a valuable tool found within Investment Account Manager to keep users notified when the market price of an asset crosses its high or low target price.

To enter or update price alerts select:

  • Asset Library Menu | Price Alerts

Each time market prices are updated, this feature automatically checks the updated market prices against your previously entered high/low price targets.  The price alerts screen then indicates in color which price target has been crossed: if the high alert has been exceeded, the high alert price shows in green; if the low alert has been crossed, the low alert price shows in red.

You can sort securities (ascending or descending order) by placing your mouse pointer over a column label and using a left-double click.
Use the Edit Tab to change price alerts for a selected security.

Use the Security Search Tab to list all portfolios within Investment Account Manager currently holding open positions for the highlighted asset, i.e. all portfolios cross-referenced for the selected asset.

Users also have the following choices:

  • Print: print a report listing all existing securities with price alert limits.

  • Internet Research: immediately access the Internet for free stock research and news. You can find fundamental variables, recent quotes, industry classifications, company news, and much more for the currently selected security.

  • Set Alert Range: users can globally set price alert targets as a percentage above (high) and / or a percentage below (low) the current market price of securities.  For example, users could enter 15% as the percentage above and 10% as the percentage below for price targets.  Security price alerts will be automatically derived and entered to coincide with these percentage settings. This is particularly helpful to closely relative market price changes.

  • Remove All Alerts: use this choice to remove all existing price alerts from securities entered.
Q: How Do I Back Up Investment Account Manager to the Cloud?

Backing up your IAM data is essential.  Frequent backups ensure that your personal data is retrievable in the event of computer failure.  A popular method used to backup IAM data, is to utilize a cloud drive, such as Windows OneDrive.  Here are the steps to do so.

  • Open Windows File Explorer.
  • Note the location of your OneDrive folder.
  • Select which folders you wish to Sync (if necessary).
  • Create a new folder under your OneDrive.  For example, name the folder IAM Backups.
  • Open IAM and select File Menu, Backup Data.  Change the destination of the backup files. Select C:\Users\OneDrive\IAM Backups (to match your setup).
  • Then, backup your data. When restoring your data you will select this folder to be used.
Q: Is Investment Account Manager Compatible on a Mac?

Yes. We have many users that use Investment Account Manager v3 Individual on a Mac using one of several Windows emulation software tools, such as Crossover, Parallels or VMware.  We suggest trying our free demo as available on our web site to verify performance and functionality. 

Q: Latest Version of Investment Account Manager, How Can I Check?

To verify you are running the latest release of Investment Account Manager, select the Menu Bar | Check for Updates choice. 

Use this choice to automatically verify if you are currently running the latest version of Investment Account Manager. You will be notified as to whether or not you have the current version. If not, you will be prompted to download the latest file.

Note: if this choice is inactive in your copy of Investment Account Manager, this indicates your technical support period has expired. To extend technical support for an additional year, renew thru our website store, or contact our technical support team: 800-247-6354.

You can view the details of the current release as well as all previous releases on the maintenance releases page.
Frequently Asked Questions / Downloading From Financial Institutions?
« Last post by Forum Administrator on July 30, 2018, 01:57:00 PM »
Q: Can I download financial transactions from online financial institutions into Investment Account Manager?

Investment Account Manager is able to download transaction data from 50+ leading financial institutions, including: Charles Schwab, E*Trade, Fidelity Investments, Scottrade, TD Ameritrade, Vanguard, Wells Fargo, and many more. Users can view the available list of financial institutions when creating a portfolio in IAM by selecting the dropdown for Financial Institution and scrolling the list of available choices. If your Financial Institution is not listed, but does OFX transactional downloads, please contact the IAM technical support team and we will try to add your institution to our list.

Additionally, IAM can also import any standard OFX (Open Financial Exchange) data file. If your financial institution is not listed, but you are able to download an OFX file directly from their web site, this file can be imported into IAM for transaction posting.

Downloadable OFX files are often listed as Quicken QFX, and these too will work.
Q: Does Investment Account Manager Accurately Derive Investment Performance?

Investment Account Manager calculates the modified IRR method to derive the internal rate of return for investment performance. This method calculates return for the period taking into effect the exact timing of each external cash flow. The model properly weights the timing of cash flows (additions/ withdrawals) for a portfolio or an individual asset, for a selected date range, to provide the return calculation. [CFA Institute Handbook Second Edition]. Investment Account Manager also allows users to store monthly, quarterly or annual IRR results of portfolios, and then geometrically link these returns for any sequential period for time weighting of sub-period IRR results. 

Pages: 1 ... 6 7 [8] 9 10