Re: reports and adjusted historical quotes
[ Q3 01 - Q1 03 Archive ]
[ Current Message Board ]
[ Archives ]
[ Search ]
Posted by JACK KLEINERT on September 07, 2001 at 14:53:08:
In Reply to: Re: reports and adjusted historical quotes posted by Mark on September 05, 2001 at 23:10:44:
: : 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?
: Mark Beiley
: Fund Manager, portfolio management software for Windows 95/98/ME/NT/00
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.