Re: Discrepency in internet price retrieve

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on August 03, 2007 at 15:09:00:

In Reply to: Re: Discrepency in internet price retrieve posted by Av on August 03, 2007 at 14:48:14:

: : : : : Hello,
: : : : : I created a portfolio and entered transactions (since my broker and many fund companies are not available for internet transaction retrieval). I did a internet price retrieve to get all subsequent prices. What I notice is that the ending values of some funds are exact to the dollar while others are off by a few hundred dollars. Why the discrepency?

: : : : : Thanks,

: : : : : Anil.

: : : : Hi Anil,

: : : : The value is calculated by multiplying your share balance by the closing price. I would suggest verifying that your share balance is exactly correct. If the share balance is correct, then check the closing price. If the share balance is off, look at your recorded transactions, to see why.

: : : : Thanks,
: : : : Mark
: : : : --
: : : : Fund Manager - Portfolio Management Software

: : :
: : : Thanks for the response.
: : : I don't think either is the issue. Here is an example- I enter a Buy transaction for a fund in say 2002, taking care to enter the # of shares and price correctly. After that, I make no further transactions except for dividend/lt/st cap gains etc that are re-invested. If I check the # of shares now, the number that Fundmanager shows doesn't match up with what my fund company shows (ofcourse, I did an internet retrieve of the price). So, it is as if FM didn't get the re-invested dividends/gains correctly.

: : : Thanks,

: : : Av

: : Hi Av,

: : It sounds like your share balance is off. Retrieving prices does not affect share balance. When you recorded your reinvested distributions, did you record all the shares correctly? In your example, your current share balance should be the shares you bought in 2002, plus all the shares from your reinvested distributions.

: : Open up the Data Register, and choose the "Investments (all)" data type. This will show you all the recorded transactions that affect your share balance. If your share balance is off as of today, look at all the recorded transactions prior to today to see which one/why your share balance is off now. For example, if you bought 200 shares, and reinvested 5 on one day, and then 7 on some other day, your current share balance will be 212. The current share balance is simply summing up all the shares you've purchased with transactions on/before the date in question. These transactions can be either buys, sells, or reinvested distributions.

: : Thanks,
: : Mark
: : --
: : Fund Manager - Portfolio Management Software

: Mark,
: Is that not the whole point of doing an internet retrieve? I am not recording the additional reinvestments myself. Given a starting number of shares, say 100, when I do internet retrieve of prices (not transactions) and specify that dividends etc be reinvested rather than distributed, I thought FM would figure out correctly the number of shares I recieved due to reinvestment and at the end of the day, the figures would match with what my broker/fund company claims the numbers are. Infact, like I stated originally, FM does exactly that. Many of my funds match exactly to the dollar (and many times to the cent). However, in some cases the difference ends being a few hundred dollars. Hence my query. Am I not using the product correctly or maybe I need to set something else up or use a different server? I use Yahoo Historical server now...

: Thanks.

: Av

Hi Av,

I didn't understand that you were retrieving distributions from Yahoo. This should work fine, assuming Yahoo has all of the correct distribution data. Sometimes there can be small differences between the number of shares you receive, and what FM would calculate based on the Yahoo data. Yahoo only reports dist/share, not the actual shares you received. I would still suggest reviewing your recorded transactions against those shown in your broker account. Your current share balance is a sum of all the recorded buys and reinvestments. If the current share balance is not right, then one of your buys or reinvestments isn't recorded properly for some reason.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software

Replies: