Re: reports and adjusted historical quotes

[ Q3 01 - Q1 03 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Re: reports and adjusted historical quotes posted by JACK KLEINERT on September 07, 2001 at 14:53:08:

: : : Dear Mark,

: : : I have been a satisfied user of Fund Manager for several years, but I have just discovered that all
: : : my portfolio performance reports have been inaccurate all this time, apparently because I have
: : : been using historical quotes. As a result it seems that my gains and yields have been based on
: : : adjusted prices, rather than the real prices on the date of the beginning of the report. For example,
: : : if Fund A had an actual NAV of 9.81 on 1/1/98, but an adjusted NAV of 9.20 when gathered on 9/1/01,
: : : the earlier date will result in a lower total value (based on the original number of shares) for that fund than
: : : actually existed when it was purchased on that date, therefore it will show a much larger gain at the end of
: : : the report period (9/1/01) than actually occurred.

: : : How do I correct this in my reports? I realize that if I go to unadjusted quotes my overlaid graphs
: : : will not be accurate. I would like both accurate reports and accurate graphs.

: : : Thanks,
: : : Jack Kleinert

: : Hi Jack,
: : If you are recording your own distributions and splits, then you
: : should use the regular "Yahoo (Historical)". The "Yahoo (Adjusted-Historical)"
: : is adjusted for distributions and splits. It sounds like you are recording
: : your own distributions and splits, so you can just use the regular historical
: : server, and both your graphs and reports will be accurate. Did you have a
: : concern about the overlaid graphs?

: : Thanks,
: : Mark
: : --
: : Mark Beiley
: :
: : Fund Manager, portfolio management software for Windows 95/98/ME/NT/00
: :
: :

: Mark,

: I appreciate your comments and realize why my problem exists. However,
: it raises another question. How do I get accurate reports when I track funds in
: my portfolio which come and go -- I sell and rebuy a year later -- and funds I am watching and
: comparing with those I own? My portfolio contains about 70 funds, only
: a few of which I own at any one time. I would like to have adjusted historical quotes
: for those I do not currently own, and, as you point out, just historical
: quotes for those I own and record distributions for. The problem is keenest
: when I generate a report for a year or two, only part of which I have earned
: certain funds. It seems I would have to somehow separate all my historical
: quotes from funds I currently own.
: I'm sorry to throw you such a convoluted problem.

: Thanks,
: Jack

Hi Jack,
It is really up to you however you prefer to track the data. Sounds like
you're aware of the issues, and you could track it either way, as long as
you stay consistent. You might consider just using the historical server for
all your investments, whether you own them or not, and recording the
distributions manually. Another option is to use the historical server
for the ones you own, and the adjusted for the ones you don't. It is really
up to you, however you wish to manage your data. Personally, I prefer using
just the historical server, and recording the distributions/splits explicitly, rather
than having their effects hidden in an adjustment of the price.

Thanks,
Mark
--
Mark Beiley

Fund Manager, portfolio management software for Windows 95/98/ME/NT/00

Replies: