manual entering transactions

[reddragon]

when manually entering transaction two years back when do you retreave historical prices as you enter these positions?

[Mark]

Hi reddragon,

It does not matter whether you enter the transactions first, or retrieve the pricing first. You can do it in any order.

[reddragon]

Can you give me any advice on how to get the money market to balance?
This is the second time I have entered every transaction on an acct that dates back to July 2008. I can not get the the money market to balance.

[Mark]

Hi reddragon,

Sure. I would suggest starting towards the beginning of your data (July 2008). Create yourself a Portfolio Value report for the end of July 2008. Also, open up the Data Register with the cash investment selected, and the "Transactions (all)" data type selected. The cash balance shown in the Portfolio Value report for July 31, 2008 is the sum of all transactions up to that date, which you can view in the Data Register. Make sure the share balance matches on July 31, 2008. If it doesn't, then one or more transaction on/before July 31, 2008 is missing, incorrect, etc. Find the one that is wrong, and edit it, or add anything missing. Once you get July 2008 balanced, move forward. You may want to do it one month at a time, or you could do it a year at a time. The bigger step you take, it can be harder to find the missing transaction, but you can experiment, and see how quickly you can move forward. Repeat this until the current date, at which time your share balance should be correct as of today.

In addition to the "share" balance, verify the market value. The market value is simply the share balance times the closing price. If the share balance is correct, then the market value will be correct if the share price is correct. For cash investments, you should only have a price of 1 recorded. To view all your recorded prices, change the Data Type in the Data Register to "Prices". Any non-1 prices you can edit here.

[StarBright2011]

I would like to add one more thing.

Sometimes the cash balance is incorrect because, when you do an internet price retrieval, if cash is set to "Retrieve Price", a symbol of "CASH" returns a price different than $1.00. When Mark said check the cash prices, this is one reason why this can happen.

To correct this, if it is happening, from the Portfolio Editor, Right-click on cash. Then, click on Properties. Now click on the "Internet Retrieve" tab. Uncheck the "Retrieve Price" box, if it is checked.

I hope this helps.

[reddragon]

Thanks I went back and did what you said balanced it out month by month starting with 07/01/2008. I balanced every month except the last month 06/01/2011 I am off by 460.24 and can not figure out why. can you help/

[reddragon]

Maybe I have to run Historic priceing all the way back? Its a guess

[reddragon]

The money market fund balances I actually have a margin balance in the acct and it is accurate. can not get the month of 06/30/2011 to balance out??

[Mark]

Hi reddragon,

Are you comparing value or share balance? If the share balance is correct on 5/31, but incorrect on 6/30, then one or more transactions between these dates is missing/wrong, etc. I would focus on share balance first, and get that correct. Use the Data Register as I described earlier. Once you verify share balance, then look at the value. If the share balance is correct, then as long as your recorded closing price of 6/30 is correct, your value will be correct too. Since we're talking cash here, the price is pretty easy, as they should all be 1.0.