Re: NAV Change in custom report

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: NAV Change in custom report posted by Brian on January 07, 2005 at 04:00:18:

: Upgraded to FM 7.0.

: Previously used a custom report with following fields :
: Share Price (ending)
: Change in price from previous
: Change in value fom previous
: Percent change in value from previous.

: In the custom report these appear as :
: Investment Name, End NAV, NAV Change, Value Change, % change.

: Using a time period like "Earliest To Date", after downloading price data for present day, the report would show the difference in prices and value since previous day (or previous day for which there was price data - ie..since last data download). The idea was to be able to quickly see price changes of investments in table form since last time portfolio was checked.

: The above custom report worked as intended in V 6.8 but now the "NAV Change" field shows the price change from first date in the date range until present. The " Value Change" and " % change" still work as previous version (they still show change from end report date to previous day).

: The description of "Change in price from previous" in the custom report settings states :
: "The change in closing share price from the ending report date to the previous day".

: Is there maybe some error in V7.0 in the calculation behind this field.

: Thanks...

Hi Brian,

Thanks for the bug report. I see this now too. You are correct, it was
incorrectly calculating the change from end to start, rather than end to (end - 1). I've fixed this for the next release.

FYI, in the Portfolio Editor you can turn on the "Change" column to see
the information you're looking for here.

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

Replies: