Here is the November 2016 list of equity mutual fund lump sum and SIP returns; upside capture, downside capture and capture ratios over 1,2,3,4,5,6,7,8,9 year periods determined up to Oct 26th 2016.
Pranav Date played a key role in making this listing possible. He wrote a code to match the Value Research fund name and category with appropriate AMFI scheme code. This is a crucial step as it would be very difficult to manually do this for 386 equity funds.
How to use this sheet: Mutual Fund Screening with Downside and Upside Capture Ratios
The benchmarks used are tabulated below.
|Banking||EQ-BANK||BSE Bankex TRI|
|Tax planning or ELSS||EQ-TP||BSE200-TRI|
TRI - refers to total reference index
Balanced Index: A new & accessible benchmark for balanced mutual funds
Here is a couple of screenshots
Users can use the sort option to list only the category that they want.
Register for the New Delhi DIY Investor meet: April 23rd 2017Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!