Re: %Gain-I Report

[ Message Board ] [ Archives ] [ Search ]

In Reply to: %Gain-I Report posted by Clive on March 06, 2006 at 19:05:10:

: I have a relatively new investment with data range of 12/28/05 to 03/03/06 (less than 3 months of data). I use the %Gain-I report settings to get yields for 3mo & 6mo time periods in order to get simple rates of return (non-anualized) for periods of less than 1 year.

: For this particular investment, FM displays values for these time periods even though the data range is insufficient. Is there any way to force FM to display N.A. for investments with insufficient data ranges? I've tried restricting interpolation ranges, but no luck.

: Thanks,

: Clive

Hi Clive,

The %Gain-I figures are not "yields". They are not time weighted. The interpolation range settings only apply to the "yield" calculations. The ROI and Fund Performance yields are the only yield calculations.

You can see the equation for %Gain-I here:

http://www.fundmanagersoftware.com/help/def_percgaini.html

This will only report NA when the "Purchases" value is $0. This happens when the starting value is zero, and there are no purchases in the time range covered.

If you wanted to use an ROI yield figure, you could report the 3 and 6 month ROI yields, and turn off the interpolation range option that allows interpolation prior to earliest recorded data. In this case, you will get an NA if the start of the yield term is before your first transaction. The ROI yields are all annualized though.

Thanks,
Mark
--
Mark Beiley
Fund Manager - portfolio management software for Windows

Replies: