Use this tool to analyse the consistency in performance of your mutual fund holdings with respect to their benchmarks (43 indices from BSE and NSE). You can also use this to evaluate new funds that you want to invest in. This is the fourth version of the Rolling returns calculator The present version is an offshoot of the Multi-Index Mutual Fund SIP/Lump Sum Returns Analyzer
The following Indices are available for comparison:
BSE Sensex, Cnx Nifty, BSE Small Cap, BSE Mid cap, BSE 100, BSE 200, BSE 500, NSE Mid cap, Nifty Junior, CNX Midcap 50, CNX 100, CNX 500, and many more sectoral indices obtained from Moneycontrol with this tool: Download Historical Data of BSE and NSE Indices
Let us now briefly discuss why a rolling return calculation is important.
Suppose we would like to know, how consistent a mutual fund has performed, how often has it performed better or worse than its benchmark (or a closely related index), how would be go about it?
In a rolling returns calculation, the key output is the frequency of outperformance.
The present version allows evaluating how often the fund has outperformed its benchmark in the interval chosen for analysis. Thus rolling returns analysis allows us to evaluate the consistency in the funds performance over different market conditions.
Note: Rolling returns analysis is useful but understanding market volatility is more important.
Evaluating rolling returns for last 1-2 years or more only makes little sense to me. That is you will need to look at a wider time intervals and not each quarter or each month.
If you wish to know more what is rolling returns and why one should calculate it, you can consult this post or this article
Trust me, once you start using rolling returns analysis, your perception of mutual fund performance will change.
Here is a list of analysis based on rolling returns
- Mutual Fund Size vs. Performance: A Case Study
- Mutual Fund Analysis:
The following screenshots of the rolling returns calculator illustrate its features
The Input page
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google Plus and Pinterest
Do check out my books
My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now . The Kindle edition is only Rs. 199.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner
The ultimate guide to travel by Pranav SuryaThis 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 ₹199 (instant download)
Free Apps for your Android PhoneAll calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)