Re: V7.x ROI

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

In Reply to: Re: V7.x ROI posted by TW Hayes on April 22, 2005 at 20:17:12:

: Mark - I think I'm having a similar problem. In version 6, I had a custom report with a column for ROI-End. That would show the ROI for each investment and that ROI matched the ROI shown on the graphs. With V7, I only get N.A. in that column. I've tried adjusting interpolation ranges and that doesn't seem to help. If I select ROI-btw, the I get an ROI in the report, but only for the investment that I've held for the longest time period. All the rest still show N.A. I appears like the calculation for ROI in V7 in reports is being done on the date range of the longest held investment whereas in earlier versions the ROI in the reports was based on a different time period for each investment. Is this a bug or am I doing something wrong?

: Thanks. TW Hayes

Hi TW,

There is a known bug for the "ROI (end)" field in version 7.2. This will be fixed in the 7.3 release. The "ROI (btw)" should work, but if you have your date range of your report set for "inception to date" this will set the starting report date to the earliest inception date for all your investments. If you also have the option to allow interpolation prior to inception turned off, then all of the investments, except the earliest one will show up as NA. This sounds like what is happening here. You can either change the report date range, or you can turn on "Options / Interpolation Range... / Allow Interpolation Prior to First Recorded Price", and this should fix the "ROI (btw)" values showing up as NA.

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

Replies: