Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Peter Willms

Pages: 1 [2]
Frequently Asked Questions / Understanding IAM's Current Asset Libary
« on: August 16, 2018, 12:29:30 PM »
IAM's Current Asset Library
As you create and add transactions to portfolios, Investment Account Manager automatically populates the Current Asset Library database. This asset library is utilized by the program to store shared asset-descriptive information, such as name, type, current market price, dividend rate per share, etc. If multiple portfolios own the same asset, the asset-descriptive information is readily available, and other portfolios can then share this information, eliminating keystroke redundancy.

The Current Asset Library stores the most recent asset information that is shared globally by portfolios. This current data is used for deriving values, reports, etc. on current reports (versus historical reporting). The Current Asset List Tab displays (in table format) all the securities currently included in the Investment Account Manager current asset library.

To manually edit or update a security, simply left double-click on that security in the grid. This facilitates name changes, symbol changes, fundamental data updates, etc.

The table can be resorted on a specific column.
Point your mouse to any column heading, the appearance of your mouse will change to a "downward pointing arrow". By left double-clicking your mouse on the column header (or moved by using a single left-click of the mouse and then dragging the column to a new location) you can change the sort order of the table. For example, left double-click on the yield column which will position this as the left hand column. Sort the Current Asset List in either Ascending or Descending order by selecting the appropriate radial dial. The list will be resorted, based on the far-left column field, in either ascending or descending order.

You can filter the Master Asset Library to show all securities in the current asset library, or filter by specific portfolio by clicking the drop down arrow to the right of the filter box, selecting the portfolio, and then selecting the Go! Button.

Use the Default Settings button to restore the asset library table to pre-defined column widths and order.

Print Library: use this button to print a list of assets in the current asset library.

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

Delete Not Held: The Delete Not Held Assets feature will "clean-up" your Current Asset List. This feature scans the system, showing those assets without any Current Position records, in any of your portfolios. These assets can then be marked as necessary for deletion. Tip: even though an asset is removed from the Current Asset List, portfolio transaction records (sale, income, original, etc.) recorded in individual portfolio(s) are retained in the portfolio(s). These records are maintained for proper reporting. Deleting from the Master will not affect historical portfolio transaction records.
Add: use this button to add securities to the current asset library. You can use this feature to add securities to the list which are not held in any of your portfolios.

Support / Using IAM's Utility Program to Repair the Program
« 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
« 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).


Pages: 1 [2]