Understanding IAM's Historical Price Libary
« on: August 16, 2018, 12:57:14 PM »
Historic Prices

The Historic Prices library stores the historical security data. enabling users to recreate portfolios as of a specific date. for instance, you might want to review your portfolio as of past date, or review a from-to report.

Price history, earnings, dividends, etc. are maintained in the historic library, and users can derive reports for the historic date to derive portfolio values, performance, etc. After you have created historical prices for a date in this library, that date will be available for reporting.

Historic Price Library organizes all the information for securities stored for an as-of-date entry. Columns can be sorted by left double-clicking a column header, or moved by using a single left-click of the mouse and then dragging the column to a new location. The Look For window allows users to search for a specific item in the left-hand column.  You can filter the Historic Asset Library to show all securities, 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.

Add New Date: use this choice to create an as-of-date entry. Users are prompted to enter a date, and Investment Account Manager will then cross-references all portfolios to determine which assets owned on the date entered. After the historic library has been created for this date, Investment Account Manager will connect to the Internet and attempt to retrieve prices for the date. For each date created, Investment Account Manager will use the information currently stored in the current library data to update the historic library. Prices will be retrieved for the historic date, and any prices not found will be returned with a market price of $1. These will need to be manually updated by the user.

Important Note: when creating month end historic price dates, always use the calendar month end date.  Investment Account Manager will find the proper prices for the most recent market closing date, and store the prices using the calendar date.  This is required for deriving month end portfolio performance returns.

Delete Old Date: use this choice to remove an as-of-date entry from the historical prices library.

Default Settings: use this choice to reset the historic prices table to default column widths and order.

Delete All History: use this choice to clear all stored historic price dates.  New users should use this choice to delete all sample historic price dates included with the Investment Account Manager demo version sample data prior to creating historic dates for their own investment portfolios.

Update Prices: use this choice to update prices for the historic date using the Internet. Be sure to check prices returned. It is also used to re-update prices in the event securities are added after the last update.

Export: use this choice to export an existing historic price date to a file. This permits the user to create a historic price file for use on another system. The file is in comma separated format (csv) providing symbol, date, price, dividend, earnings, and beta (as found in the asset library).

Print: use this button to print the Historic Price library information. Securities are organized on this report based on the column sort order last selected by the user. To sort columns, left double-click on a column header. For example, if you want to organize this report based on past price/earnings ratios, use a left-double click on this column.

Delete: use this button to delete individual assets from the Historic Price library. Do not remove an asset from the historic list if the asset was held in any portfolio as of the date. Removing this security will result in inaccurate historical reports for the as-of-date.

Add: use this button to manually add assets directly to the list to reflect securities owned in portfolios for the historic as-of-date entry. Important Note: if you have already created the prior year-end historic price date for the year-to-date range, but then enter purchase activity for a new asset to this portfolio for this prior year (out of sequence), be certain to update the stored price in the Historic Price Library for this prior year-end date. The priced used for performance will reflect $1.00 unless this issue was previously entered to the historic price file.

The Edit/Update Tab shows the security information for the highlighted asset in the historic asset list tab. Users can edit on this tab the existing information as necessary. Also provided is a link to the Yahoo! Finance Historical Quotes page for the selected issue.

Use the Save button to record changes.

Use Cancel to ignore changes.

Important: Anytime you add purchase transactions proceeding the dates found in your existing historic asset library, the security involved is added to all the required libraries with a $1.00 price. Either manually change the price, or use the update prices to retrieve via the Internet.