Presenting a simple way to measure mutual fund performance consistency

Published: September 21, 2016 at 11:32 am

Last Updated on

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.


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:

Join our 1500+ Facebook Group on Portfolio Management! Losing sleep over the market crash? Don't! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free! Did you miss out on the lockdown discount? You can still avail it! Follow instructions in the above link!

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


The funds which have a scopre above 70% are highlighted in green. The same data in bar chart form.

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.



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


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.

Do share if you found this useful
Join our 1500+ Facebook Group on Portfolio Management! Losing sleep over the market crash? Don't! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free! Did you miss out on the lockdown discount? You can still avail it! Follow instructions in the above link!

Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!)

About the Author

Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice.
He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association. For speaking engagements write to pattu [at] freefincal [dot] com

About freefincal & its content policy

Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. We operate in a non-profit manner. All revenue is used only for expenses and for the future growth of the site. Follow us on Google News
Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication.Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)

Connect with us on social media

Our Publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingThis book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.

Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want

Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

Your Ultimate Guide to Travel


This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when traveling, how traveling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for Rs 199 (instant download) 

Free Apps for your Android Phone

Comment Policy

Your thoughts are the driving force behind our work. We welcome criticism and differing opinions.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.


  1. 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?

    1. 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.

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

  3. A good work again..! Definitely a lot simpler but much relevant method to analyse past performance…!! Thanks a lot …!!!

  4. Please share the excel used to calculate this and let us know from where you got the data regarding NAV and index

    1. 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

  5. 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

    1. 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.

  6. 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).

  7. 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.

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

  8. 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,

    V K Sood

  9. Wonder why limit it to 3-year rolling returns. Could the conclusions be different on consistency if we run, say, a 10-year rolling returns (for older funds) instead, for the same benchmark? Since the objective is to determine consistency in performance, would it be better indicator of performance measurement using longer range rolling returns ( if data is available)? Your thoughts!

Comments are closed.