Presenting a simple way to measure mutual fund performance consistency

A simple way to measure how consistent a mutual fund has been in outperforming a benchmark over a given period, in the form a simple percentage is discussed in this post. Depending on your feedback I will include this in this months mutual fund return listings.

The simplest and most intuitive way to measure outperformance is to use rolling returns.As regular readers may be aware freefincal has rolling return calculators for both lump sum and SIP investments with a choice of 50 benchmark indices for comparison.

The most important advantage with rolling returns is that they are simple to understand. Way more simpler than the greek alphabets - alpha, beta, gamma, Sharpe, Sortino etc. and even simpler than upside and downside capture ratios.

What are rolling returns

Suppose I ask what is the return for the last 3 years for a fund. I am considering the NAV growth between two days. The current NAV and the NAV three years ago. This is known as a point to point calculation. The return value depends on when I choose to make a calculation. 

Instead, if I have NAV data for the past 10 years and calculate the three return between

1st Jan 2006  to 31st Dec 2008

2nd Jan 2006 to 1st Jan 2009

3rd Jan 2006 to 2nd Jan 2009 and so on for every business day from 1st Jan 2006 to the current day.

So you can imagine that I will get 100s of 3Y return data points for the fund.  Then I repeat the exercise by choosing an appropriate benchmark and compare the two. Here is an example.

HDFC-top-200-3Y-rolling-returns

The graph immediately tells you that the fund has been quite regular in beating the chosen benchmark. This gives a easy to understand visual measure of performance consistency.

This can be expressed as a percentage too:

Consistency score = (no of times fund has beat index)/(total no of rolling return entires). Expressed as a percentage.

Higher this score, the more consistent the fund has been in outpeforming the benchmark.

Three-year rolling return consistency score wrt Nifty 50 TRI

data-mutual-fund-performance-consistency-score-nifty-50-tri

The funds which have a scopre above 70% are highlighted in green. The same data in bar chart form.
mutual-fund-performance-consistency-score-nifty-50-tri

Three-year rolling return consistency score wrt Nifty 50 Value 20

The Nifty 50 Value 20 is a concentrated index of 20 value stocks from the Nifty 50. It is a much more stringent benchmark for evaluating large cap funds. However much of the index data is backtested. So we will have to check real time data for a while to evaluate the suitability of this index.

data-mutual-fund-performance-consistency-score-nifty-50-value-20

mutual-fund-performance-consistency-score-nifty-50-value-20

Amusing only ICICI Focussed Blue Chip has a reasonable track record against the Value 20 index.

icici-focussed-blue-chip-rolling-retuns

The consistency score is a simple way to determine outperformance with respect to a chosen benchmark. Do let me know what you think about this.

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

20 thoughts on “Presenting a simple way to measure mutual fund performance consistency

  1. Abhishek

    Fabulous article again.. Makes me wonder. Why botHer with mfs at all. Buy the stocks in the nifty 50 value 20 using a discount broker. Keep for long term. And we could beat most mfs without worrying about choosing the right fund.
    Your thoughts please?

    Reply
    1. freefincal

      Thank you. That is a certainly a possibility. Only caveat is, much of the NV20 data available today is backtested. So one should keep an eye on how it fares against Nifty 50 in real time.

      Reply
  2. Dinesh Singh

    This is definitely a simpler and more elegant way to assess consistency. You must adopt it in this month's MF returns listing.

    Reply
    1. freefincal

      Please use the rolling return calculators links in this post or search for them and you can calculate it for any fund. The NAV is from AMFI and indices from moneycontrol, bse and nse

      Reply
  3. Kaushik

    Hello Pattu, This is a good concept. But this could also be biased because the data relies on past history of the fund.Past returns are no guarantee for future performance.
    Also there would be very few data points for new funds say ppfas.This could actually make an investor biased.. Correct me if I am wrong

    Reply
    1. freefincal

      1) I have only shown funds with a 1000 3Y returns
      2) Show me an analysis that does not depend on past performance. Happy to learn more about it.

      Reply
  4. Dinesh Singh

    Buying the stocks in NV20 and keeping them for long term will not work as constituents of NV20 and their weights will keep changing every quarter. A better way would be to invest in R*Shares NV20 ETF and pay the Expenses which are very low (0.39% in 2015) where the AMC will keep the portfolio aligned with NV20. But will it be worth it as a fund like ICICI Focused Bluechip will still beat NV20 (and R*Shares NV20 ETF).

    Reply
  5. Ashish

    Maybe you add a threshold of beating to count consistency score. For example, whether fund beats benchmark by 1% or 0.01% count as same in current calculation. I am interested in knowing times fund beats benchmark by at least 0.5% (say) as premium for managing MF accounts and additional work.

    I will interested in this tool if it can compare any fund and any (from select set of) benchmarks.

    Also, long standing request, you should start versioning you tools. Difficult to keep track of latest versions.

    Reply
    1. freefincal

      Reg versions, I have stopped posting them in multiple places. So the change log is available. I will see how a threshold works. Thanks.

      Reply
  6. Vijay sood

    Dear Sir,
    A great analytical tool. But how do we make use of it. Let us say there are two funds , say "Fund A" and Fund B". Fund " A" has beaten index 100% times whereas Fund "B" has beaten only 70% times. But every time fund "B" has outperformed it i by a very wide margin, whereas "A" more or less mimics index with a positive bias. At the end of day " B''s performance will be much better than that of "A". It shall be therefore better to invest in "B" , provided , of course that the score of out performance is not very low. Request comments as I may be wrong,

    Regards.
    V K Sood

    Reply

Do let us know what you think about the article