Custom report showing N.A. for ROI, but have prices.

[hilofarmgal]

Sorry if you've already addressed this, but I'm unable to find my question in the forum. My custom report uses my master portfolio (several sub-portfolios) to get the ROI(end) and ROI(3mo) for my investment period of 20 years, all investments, to current date. MSFT shows as having been acquired as recently as 3/2009 and shows me a 3month ROI but N.A. for the ROI(end). Why? I checked the data register for the master portfolio and there are prices during the holding period. I've used the "get historical prices" feature, and all seems to be ok. What else can I check? Am I not understanding how this works?

[Mark]

Hello hilofarmgal,

When calculating the beginning value for any yield term, the closing price as of the prior day is used. So, for example, if your yield term starts on 1/1, the starting point is the price on the morning of 1/1, which is the same as the close on 12/31. You would want a price recorded on 12/31 for this example.

The ROI (end) field displays the yield for the term starting on the first transaction date, and ending on the report's ending date. Therefore, you must have a price recorded on the day before your first transaction, or have your interpolation options flexible enough for Fund Manager to interpolate a price for this date. You can control how flexible Fund Manager is in interpolating a needed price point when one isn't recorded by using "Options / Yield Interpolation Range...". Press "Help" in that dialog for an explanation of those options.

One quick test to see if the N/A result is because of interpolation limits is to turn off interpolation limits by un-selecting "Enforce Maximum Interpolation Range" and selecting "Allow Interpolation prior to first recorded data". The interpolation type does not matter for this. With these settings you have told Fund Manager to always figure out some price, no matter how far you have to interpolate. This can lead to big errors if you're missing a lot of pricing data, but you can just temporarily use these settings to figure out if the problem is from a lack of pricing data.

Again, the key date to look for recorded closing prices is the beginning of whatever yield term you are calculating. In the case of ROI (end) the beginning is the date of your first purchase.

[hilofarmgal]

Mark,

thanks! that works....