Performance by year

[Kelvin]

Is there any way to see portfolio (and investment) performance by year for a series of years? I know I can get 1 year, 3 year, 5 year, and 10 year performance, but I'm wondering if there's a way, at the end of 2014, to get the performance for 2010, 2011, 2012, 2013, and 2014 by individual year (other than specifying each year individually in the date settings for Portfolio Performance; that works for up to 6 years, but not more). I'm using v10.9, FWIW.

[Mark]

Hi Kelvin,

For portfolio performance you could use the new "Monthly Performance" report, that also gives a year number. For a sample of this report, see:

https://www.fundmanagersoftware.com/dem ... erformance

That report is not available in 10.9, but is in the current 2014 version.

That report won't show a breakdown on an investment level though. For that you would have to revert to the method you described of using multiple date ranges within a report. You could use a Custom report and only include the 1 field of ROI Yield (between).

Additionally, if you are using the Professional or Advisor version you can define your own fields, so you could define multiple fields for different date ranges, and then you only need to have 1 date for your report, as the user-defined fields could overwrite the report dates. For example, you could define a field called "2014 Yield", and in the field definition, define the dates for 2014.

[Kelvin]

You constantly amaze me, Mark. I've had FM for about 20 years, and the feature set continues to grow in useful ways. You give a lot of persuasive reasons to upgrade!

[NickyB]

Hi, I'd like to pick up on the ability to add new fields. It's a great option. I'd like to run a report with YTD settings, but add a field to show the MTD ROI. I've taken a look at the option to add a field and that should work perfectly. Would it be possible to get a copy of the formula definition you have used for say the ROI 3m? It would make it much easier to add the field. It would actually be great if you could release the formulas for most of the important calculation - I'm sure there must be other clients who would also benefit a lot from having a good starting point to develop additional metrics.

I look forward to you response.

PS I'm really enjoying the software - the feature set is really good!

[Mark]

Hi NickyB,

All of the equations are documented in the online help. For user-defined Custom report fields however you don't need to re-write the low level equation (actually you can't usually...). You can make use of built-in fields that already take care of solving the low level equation. FYI, the ROI yield equation is shown here:

https://www.fundmanagersoftware.com/hel ... s_roi.html

That isn't something you can write in a user-defined custom report field, but you can write an equation that says to solve the ROI yield for any particular date period you want. For example, if you use the equation:

EVAL(DELTADAYS(ENDDAYS(), 0, 0, -7), ENDDAYS(), ROI_btw)

This will calculates the ROI yield for the week ending on the ending report date. You are making use of the ROI_btw field which calculates the ROI yield between the starting/ending report dates. This equation is saying how to set those starting/ending report dates when doing this evaluation. To calculate an ROI yield from Jan 1, 2015 through the ending report date, you could use the equation:

EVAL(DATE2DAYS(1/1/2015), ENDDAYS(), ROI_btw)

or, to get the ROI yield for a particular month, like Dec 2014, use:

EVAL(DATE2DAYS(12/1/2014), DATE2DAYS(12/31/2014), ROI_btw)

Hopefully these examples help get you started. There is a lot more documentation on writing user-defined custom report fields in the online help. Just press "Help..." in that dialog, or visit:

https://www.fundmanagersoftware.com/hel ... ields.html

and

https://www.fundmanagersoftware.com/hel ... nsert.html

[NickyB]

Hi Mark

Thank you very much for the quick reply. Looking at the presented equations I understand what you are saying. It does however leave me with having to adjust the dates on the new field every month, either by changing the date or the number of days.

Is there no way to automate relative to the report date? Would it not be possible to infer start date relative to the report end date? Essentially I'm looking to create ROI_1m.

I appreciate your help!

[Mark]

Hi NickyB,

You can adjust a date relative to the ending report date, using the DELTADAYS function. It adds or subtracts months, days, or years. For example:

EVAL(DELTADAYS(ENDDAYS(), 0, -1, 0) + 1, ENDDAYS(), ROI_btw)

would get the ROI_1m figure, where it is for 1 month, ending on the ending report date. This is not the same as month to date (MTD). For example, if your ending report date was Feb 3, the equation would give you the ROI yield for the time from Jan 4 - Feb 3 (1 month).

[NickyB]

That is perfect thanks!

[B2B_Investing]

Mark,

Just to echo a comment above, FM continues to amaze me. Using the Monthly Performance report filtered by "investment goal" is a very powerful report. Since the drill down shows only the investments in the portfolio that match the filter, this offers some perspective on how to configure the portfolios and sub-portfolios. This permits the portfolio explorer to be setup by account but provides a way to track strategies that cross accounts.

Just like all software it has its quirk, but it is still the best non-institutional program I have found. Thanks again for such an amazing, flexible program.

Jason