Monthly Performance Report - Version 11 Beta

[StarBright2011]

Mark,

I am happy to see the modifications/additions in version 11.

I have run into a small problem with the Monthly Performance Report. I just purchased Fund Manager in January 2011. I decided to set it up with zero balances for 01/01/2011 and maintain investments from 01/03/2011 onward. When I run the Monthly Performance Report with starting dates of 01/01/2011, 01/03/2011 or 01/04/2011, it shows blanks for January. In all cases, the performance for February is correct -0.06%. The performance in the Monthly Performance Report for February agrees with the results in the normal Performance Report. For January, the normal Performance report shows -3.90% and the new Monthly Porformance Report shows blanks.

Thanks,

Ernest

[Mark]

Hi Ernest,

Thanks for testing out the new 11 beta. The Jan field will be blank, unless your report start date is 1/1 or earlier. If the starting report date is 1/1, but you didn't own it until 1/3, your figure will be N/A (not blank) with the default yield interpolation range settings. See "Options / Yield Interpolation Range...". The 2 options:

Allow Interpolation Prior to Earliest Recorded Data
and
Only Report ROI Yields When Item is Owned for Entire Yield Term

would need to be un-checked in order for you to get an ROI yield reported for 1/1 - 1/31 when you didn't buy it until 1/3.

The Portfolio Performance report should be reporting the same, assuming you have the date range set the same. The yield interpolation range settings are global, and apply to anywhere that yields are reported. Try creating a Portfolio Performance report for 1/1 - 1/31, and you should get the same as you do in the Monthly Performance report for January, assuming you are reporting ROI as your performance metric.

[StarBright2011]

Thanks, Mark.

I have my Performance Metric set to "%Gain".

When "Only report ROI Yields When Item is Owned for Entire Term" was checked in "Yield Interpolation Range", I was seeing the -3.90 for "%Gain" and N.A. for "Yield" on the normal Performance Report while showing Blanks on the new Monthly Performance Report for January.

I unchecked "Only report ROI Yields When Item is Owned for Entire Term" in "Yield Interpolation Range", I get the same results for the normal Performance Report and now I get -3.90 for January on the new Monthly Performance Report.

Thanks, again.

Ernesr

[Mark]

Hi Ernest,

The "interpolation range" settings should not affect any %Gain calculations. Those options only affect ROI/TWR yields. If you get a blank in the Monthly Performance report, this means that time period was not fully included in the date range of the report. If you're seeing something that isn't consistent with this, please let me know.

[StarBright2011]

On another note, I memorized the Monthly Performance Report for Start Date, Floating End Date and Performance Metric of % Gain. It appears that the Performance Metric is not memorized. Once I close the report and open it again, the dates are as expected; however the Performance Metric reverts back to ROI.

Thanks,

Ernest

[Mark]

Hi Ernest,

Good catch, thanks for pointing this out. I see that too. We'll get this fixed.

[Mark]

Hi Ernest,

The bug you reported about the Monthly Performance Report metric not being recalled from a memorized report has been fixed in FM 11 Beta 2, which you can get now on the beta page:

http://www.fundmanagersoftware.com/fm11beta.html

[StarBright2011]

Thanks, Mark.

The Report Metric is memorized and works great!

Ernest