Re: V7.x ROI

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

In Reply to: Re: V7.x ROI posted by Mark on March 05, 2005 at 20:55:20:

: : : : Hello Mark,
: : : : I have this issue too. It occurs when I do a "custom" portfolio report, but not on a "ROI" portfolio report. Everything seems fine on the "ROI" report; I get "N/A" if a ROI is not applicable. I checked the interpolation range, and I have both boxes unchecked, with the "step" box checked.
: : : : Even when I play around, checking and unchecking the boxes, placing different amount of days in the enforce max. interpolation range, I still don't get the "n/a" when it should apply.
: : : : Again, this happens on the "custom" portfolio report. All is fine on the graphs and on the "roi" portfolio report.
: : : : Thanks,

: : : Hi Fred,

: : : On the custom report, which fields are you using? Any of the ROI yields in particular? Is the custom report showing the yield for an investment, symbol, investment type, asset type, investment goal, or a sub-portfolio? Or, does it do it for all of these types?

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

: : Mark,

: : My custom report uses investment name, inv inception, end value, symbol, end shares, end %port, ROI (3m), ROI(6m), ROI (1y), ROI (3y), ROI (5y), ROI (btw). Report show ROI yield for an investment. Where it should be NA it has the same value ROI yield as the shorter period (where I had the investment for the full period). So, if I held an investment for only 1 year the 1 year ROI is shown for 3 and 5 ROI also. And "Allow Interpolation Prior to First Recorded Price" is unchecked.

: : Regards//Cliff

:
: Hi Cliff/Fred,

: Thanks, the custom report is calculating the ROI yields using "Step" interpolation and allowing interpolation before the first recorded price. It is doing this no matter what the yield settings are for interpolation, which makes it different from the ROI report and the Portofolio Editor. I will fix this for 7.2 so it is consistent with those two, where the yield interpolation options are based on your settings. Thanks for pointing this out.

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

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

Replies:

• Re: V7.x ROI Mark 14:09:29 04/23/05 (0)