|
|
Money Market Inaccuracies in Rebuilt Subportfolios[ Message Board ] [ Archives ] [ Search ] Posted by Steve on September 09, 2007 at 15:06:09: Mark, I'm doing something incorrectly in an effort to reconstruct a subportfolio that spans about 4 years. My objective is to reconstruct a previously built, already existing subportfolio as if it was begun on 7/30/06, and measure the expected accumulations until 7/31/07. The reason for doing this: the account consisted of 3 different money markets, and the balances are too confusing to follow. I am hoping to obtain a cleaner money-market record. Thus far, what I've done is: (1) begin with the money market balance on 7/28/06, and use that balance as the default cash account, (2) copy all the portfolio holdings that were present in the previously constructed subportfolio on 7/28/06, (3) then copy/add all the additional new holdings/sales over the past year from the previously constructed subportfolio to this newly constructed subportfolio. (3)Then use OFX to download all the transactions not addressed in the steps above. Some confusing elements arise at this point (no fault of FM, to be sure): (1) A new money market symbol pops in, and seems to offset the transactions of the default cash account, only no purchase price (i.e. number 1) is present. (2) The money market balances are once again substantially off. (3) The Portfolio Return measures register in negative territory, whereas a gain of about 15% was actually rendered. One known problem I'm attempting to address is the entire money market balance was transferred into a new money market product this past June by my firm's custodian. I'm sending you the money market files via email as there is probably a basic error in the way I am recording the money market problems. Thank you for any help you might provide.
|
| FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
| Copyright ©1993-2024 Beiley Software, Inc. All rights reserved. |