Microsoft KB Archive/174983

INV: Broker Import - Updating Historical Data

PSS ID Number: Q174983 Article last modified on 11-18-1998

WINDOWS:

WINDOWS

================================================================ ==

The information in this article applies to:

 == MSN MoneyCentral == 

= SUMMARY =

A broker imported account may not include all the historical data you want for an investment in MSN Investor. Because a broker may only keep historical transaction data for a limited time, you may want to manually add historical data, or add extra transactions to compensate for missing information.

This article describes how to manually update this historical data.

= MORE INFORMATION =

When Investor imports data from a broker, it may add an Add or Remove Shares transaction dated 1/1/97 to make the position reported by Investor match the position reported by the broker.

If you wish to manually add previous historical data, you need to delete the fake transaction.

Adding Historical Data
To add older historical data to your broker imported account, follow these steps:


 * 1) Gather your records.
 * 2) In Portfolio Manager, double-click the investment to go to Investment Details.
 * 3) On the Transactions tab, click the 1/1/97 Add (or Remove) Share transaction, and then click Delete.
 * 4) Click New to add the appropriate historical transactions: Buys, and Sells with the correct dates, quantities, prices, commissions, and other information.

NOTE: If you want to enter historical data to a certain date, you can create a Buy transaction for the total of all previous entries using the average cost as the price per share. Or you can use an Add Shares transaction if you do not know what the previous prices were.

Correcting Imported Data
Sometimes your broker may not record all data for a transaction. For example the price may be missing for a transaction, which may result in an incorrect Cost Basis or problems with other calculations in Investor. This could happen if a purchase or sale was recorded as a transfer by the broker and hence exported to Investor as an Add (or Remove) Shares transaction.

You may be able to adjust for this by adding transactions manually.

As an example, if purchases were imported as an Add for 100 shares on 7/1/97, but you know that the price was $20 per share, you could add the following two transactions to allow Investor to return more accurate calculations:

7/1/97 Remove Shares - Quantity 100

7/1/97 Buy - Quantity 100 - Price $20

The Remove Shares transaction compensates for the additional shares recorded in the new Buy transaction.

After making these manual changes, the account’s cash balance may change. To correct this balance, Update the Imported Brokerage Data, from Portfolio Manager’s File drop-down menu.

= Additional query words: money msmoney money98 =

Keywords : kbdta kbonline mnyinvest Version : WINDOWS: Platform : WINDOWS Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.