Last Updated on January 10, 2023 at 10:03 pm
Use this Excel sheet to automatically calculate rolling upside capture, downside capture and rolling returns for equity mutual funds by comparing them with 72 BSE/NSE Indices. While the rolling returns provide a consistency measure for overall reward (return), the upside/downside captures provide a consistency measure for outperformance during up-market periods and protection during down-market periods respectively.
In simple terms, an upside capture ratio of 120% implies that the fund has captured 20% more gains than the index has. Therefore a consistently high upside capture is desirable.
A downside capture of 80% implies that the fund has captured only 80% of the index losses a consistently low downside capture (including negative values) is desirable.
Please refer to these articles for a deeper understanding:
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
Simplify Mutual Fund Analysis with Upside/Downside Capture Ratios
An introduction to Downside and Upside Capture Ratios
It is not practical to expect mutual funds to outperform the index during both up-market and down-market periods. Typically, an aggressive fund will beat the market during up-market periods but will lose more than what the market does during falls.
A conservative fund will contain losses well, but may not beat the market when it moves up as much as aggressive funds.
A look at rolling upside/downside capture will give us an insight about the investing style of the fund.
The excel sheet linked at the bottom of this post will help you do just that.
For example, this is the 5Y rolling upside/downside capture for Quantum Long term Equity vs Nifty 50 TRI.
Notice the red dots. The downside capture is typically less than 100%. Thus the fund is efficient in containing losses (when compared to losses of the Nifty 50).
The blue dots – upside capture – are also less than 100% most of the time. This means that the fund is not aggressive when it comes reacting to market up moves.
The capture ratio (green dots) = upside(blue)/downside(red) is also shown. A capture ratio of close to or above 100% is “good” regardless of investing style.
Now what you make of HDFC Top 200 vs BSE 200 (price index), 3-year rolling from April 3rd 2006.
I suggest you try it for 5Y or 7Y and see how it looks.
Here is a screenshot of the main inputs page
