Re: Money Market Inaccuracies in Rebuilt Subportfolios

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on September 10, 2007 at 17:32:21:

In Reply to: Re: Money Market Inaccuracies in Rebuilt Subportfolios posted by Steve on September 10, 2007 at 15:04:03:

: Mark,

: : If you already have a money market, and you want these transactions to go into your existing investment (rather than create a new investment), you need to assign the CUSIP property of your existing investment. When importing from OFX transactions are matched up to existing investments based on the CUSIP investment property.

: : : The money market instrument, post-OFX download, is messing up the collective balance of the default cash account and the rest of the subportfolio, and also creating incorrect subportfolio return calculations, but it isn't clear to me where the errors arise.

: : You might try and start by looking at the balance at an early date. For example, you can look at the end of the very first year, and work your way forward.

: I'm trying to simplify things by starting at 7/28/07, and am beginning the construction from the money market and other portfolio entries on the statement from that date.

:
: : : Did you receive the files I sent containing the default cash account and post-ofx money market account? The reason I sent the files is to determine if there is something basic that I may hopefully correct. So far, I'm not seeing the problem.

: : Yes, I received 3 investment files, but I wasn't sure which one was what, or what I was looking for?

: File non8.dat is my hand-entered initial balance, intended as the default cash account, with balance of $222,627.66 initially, with a balance at year's end of 399,423.92, whereas the TRUE balance is $281,360.49

: File zz15.dat is the money market account that comes into existance due to my vendor's abrupt switch of money markets, which has a balance on 7/31/07 of -234,204.78

: The 3rd file zrf10 is not so important, as it appears empty.

: Please help me with this, if possible.

Hi Steve,

I suspect my answer isn't quite what you're looking for, but can you formulate a specific question for me to address? It sounds like you've done a lot, and I'm not sure where to begin on helping you.

I'm not going to be able to tell you what transactions are wrong, but I can tell you why something is reporting the way it does, given the way you have your data recorded.

Why don't we focus on none8.dat. I see the initial purchase of $222,627.66 on 7/28/2006. There are then a bunch of buys/sells after this, and you end up with a balance of $193,716.38 on 12/31/2006. Is this correct? If not, then you need to look at all of the transactions between 7/28/06 and 12/31/06, and see which ones are incorrect. The Data Register with the data type of "Investments (all)" is a good place to do this from.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: