An introduction to Downside and Upside Capture Ratios

Published: June 22, 2017 at 10:52 am

Last Updated on

Readers may be aware that I often use rolling returns, where anualized return is calculated between two dates and the calculation dates are shifted to the next possible business day.  I have developed a rolling downside and upside capture calculator and before publishing it, would like to discuss what they are in simple terms.

A rolling return calculates every possible return between two dates and each month I publish 3Y, 5Y and 7Y returns bet April 20006 to the end of last month. You can refer to last months data here: Monthly mutual fund screeners The idea is to find out how consistent the fund has been in beating its benchmark. This is a rolling reward calculator.

I had earlier published a rolling risk calculator: Evaluating Volatility in Returns – a rolling standard deviation tool. Since I have fallen out of love with the standard deviation and its cousins – the average, alpha, beta, gamma etc. – I wanted to make an alternative rolling risk tool.

The best way to understand upside can downside capture is via an example.

Consider the following data set for a fund and index.  The monthly NAV and price data is shown along with the monthly return, which is just the absolute difference or the percentage gain or loss.

Now I take funds monthly returns can compute annualized return or cagr in the following wayIf m1, m2, m3, ….. are monthly returns over a year, then

(1+CAGR) = (1+m1) x (1+ m2) x (1+ m3)x…..

From which the CAGR (compounded annualized growth rate or annualized return) = 8.16% as shown above.

With this information in mind, let find tabulate the fund and index monthly returns when the index monthly return was positive (>0) and when it was zero or less (<=0)

First observe the two rightmost columns. There were only two instances when the index monthly returns were <=0. Correspondingly, the fund returns were also negative.

In one instance, the index fell by -14.75% and the fund only -5.17%. In another instance, the index fell by -12.44% and the fund by -13.39%.

Similarly, the two adjacent columns show fund and index returns when index returns were positive.

Suppose I take the fund returns when the index returns were positive and calculate CAGR.

The calculation is identical to the standard CAGR (shown above), but the monthly returns when the index returns were <= 0 are left out.

The 31.68% is known as Upside-CAGR-FUND.

Similarly, we can calculate an Upside-CAGR-Index using only positive index monthly returns.

we can extend the calculation to obtain a Downside-CAGR-Fund and Downside-CAGR-Index.

Upside Capture Ratio

Upside capture ratio  = Upside-CAGR-Fund/Upside-CAGR-Index.

It tells you “how much of the index gains the fund captured”.  This should be higher than 1 or 100% – whenever the index gives +ve returns, we expect the fund to provide higher +ve returns.

Downside Capture Ratio

Downside capture ratio  = Downside-CAGR-Fund/Downside-CAGR-Index.

It tells you “how much of the index losses the fund captured”.  This should be less than 1 or 100% – whenever the index falls, we expect the fund to fall lower.

Capture Ratio

Capture Ratio = Upside Capture/Downside Capture. (should be above or close to 1 o 100%).

Now the goal (well, mine anyway) is to look for a consistently low downside capture. This means the fund typically had lesser losses than the index. My experience suggests that it is not possible to expect a consistently high upside capture, but more on this later.

Rolling Upside and Downside Captures

Now imagine these ratios calculated on a rolling basis. For example,

first data set = Apr 2006 to Apr 2007 (for 1Y calculations

second data set = May 2006 to May 2007

third data = June 2006 to June 2007

and so on until we exhaust all the data that we have.

This is an example of a 5Y rolling capture ratio data set for Quantum Long Term Equity vs Nifty 50 (TRI).

Do you like what you see? Can you interpret this graph? Will you invest in such a fund?

To be continued ……

___________________________

GameChanger- Forget Startups, Join Corporate & Live The Rich Life You want

My second book, Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantco-authored with Pranav Surya is now available at Amazon as paperback (₹ 199) and Kindle (free in unlimited or ₹ 99 – you could read with their free app on PC/tablet/mobile, no kindle necessary).

It is a book that tells you how to travel anywhere on a budget and specific investment advice for young earners.

 

You can Be Rich Too with Goal-Based Investing 

is my first book with PV Subramanyam. It helps you ask the risk questions about money, seek simple solutions and find your own personalised answers with nine online calculator modules.

The book is available at:

Amazon Hardcover Rs. 271. 32% OFF

Infibeam Now just Rs. 270  32% OFF. If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

Flipkart Rs. 279. 30% off

Kindle at Amazon.in (Rs. 90.74 74% OFF) Read with free app

Google PlayRs. 90.74 Read on your PC/Tablet/Mobile

Now in Hindi!

Pre-order the Hindi version via this link

Do share if you found this useful
Share your thoughts on this topic at the  Reddit freefincal_user_forum

Reach your financial goals like a pro! Join our 1600+ Facebook Group on Portfolio Management! 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!
Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
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. 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 investingPublished by CNBC TV18, this 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

Travel-Training-Kit-Cover-new This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling 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 android apps