# 19. Rolling Returns

## 19.1 – Point to Point return

The previous chapter gave us a perspective of how returns are calculated given the time frame under consideration. So, now if I were to provide you with the following data point –

Fund – Aditya Birla Frontline Equity

Starting date – 2nd January 2013

Starting investment value – Rs.1,00,000/-

Starting NAV – 100.83

Ending date – 2nd January 2015

Ending NAV – 161.83

And asked to find out the returns, you’d probably do it with ease. Let us do the math –

Number of units = 1,00,000/ 100.83

= 991.7683

The ending value of investment  = 991.7683 * 161.83

= Rs.1,60,497.9

The growth in this lumpsum investment over two years can be calculated by applying the  CAGR formula –

= [160497.9/100000]^(1/2) – 1

=26.69%.

Which as would recognize is a phenomenal growth rate.

Now, let us say you are mighty impressed with your investment, and you start to propagate the fund. A friend walks up to you asks for the performance, and you proudly declare the 2-year growth rate is 26.69%.

Your friend is impressed and decides to invest.

Now, I want you to think about this for a moment. What do you think is the fundamental flaw here?

Did you lie or mislead your friend by letting him know the returns you’ve enjoyed? – No

Well, then what do you think is wrong here?

The growth rate of 26.69% is a massive generalization of two-year growth rate. When you mentioned this return to your friend would believe that this is the kind of performance even he is likely to enjoy.

The 26.69% return is valid when the money is invested on 2nd January 2013 and measure its growth on 2nd January 2015. In other words, the growth rate is really only for this starting and ending points; it is right for these exact two dates.  It is a very personalized experience.

If I were to invest and measure the returns on any other dates, then the profits will be different.

So, whenever you measure returns or growth between two dates, the value you calculate is only valid for the two years under consideration. Hence, such a measurement of returns is also called the ‘Point to point’ return.

To get an accurate representation of how the two-year return (growth rate) looks, you need to calculate the ‘Rolling Returns’.

## 19.2 – Rolling Return

The rolling return gives us a perspective of how the ‘n years’ return (growth) has evolved over the last ‘n years’.  Sounds confusing? I’m sure it is, so here is what we will do.

We will take up an example and figure out the rolling return calculation. I’m sure understanding the rolling return concept becomes much easier if you know the math behind.

By the way, many websites publish the mutual fund’s rolling return, so it is not essential to remember how to calculate the rolling returns. However, by knowing the rolling returns math, you will understand the concept of rolling return quite easily.

So let us get started.

I’ve got the historical NAV data of AB Frontline Equity Growth-Direct. The starting date is from 2nd January 2013, and I’ve got this till 2nd January 2020, that’s about seven years of data.

My objective here is to find out the 2-year rolling return for this fund. To do this, I’ll have to start in 2015.

I take the NAV on 2nd January 2015 and the NAV 2 years ago, i.e. on 2nd January 2013 and calculate the return between these two data points. Next, I move the date by one day, i.e. between 3rd January 2015 and 3rd January 2013, take the NAV for these two dates and calculate the return between these dates. I’ll again move the date by one day, i.e. 4th January 2015/2013 and calculate the return.

So on and so forth, such that I have a time series of 2-year return.

Let us calculate the first rolling return –

NAV on 2nd January 2013 – 100.83

NAV on 2nd January 2015 – 161.83

Since its two years, we apply CAGR –

[161.83/100.83]^(1/2)-1

26.69%

The 2nd rolling return in this series would be –

NAV on 3rd January 2013 – 101.29

NAV on 3rd January 2015 – 161.45

=[161.45/101.29]^(1/2)-1

26.25%

I suppose you get the sequence. I’ve stacked up the data side by side on excel, and this is how it looks –

The starting date is 2nd January 2015, right up to 2nd January 2020.

As you can see, I have the latest date and NAV (shaded in blue). Next to this, I have the date and NAV for two years ago (shaded in pale yellow). I have calculated the CAGR against these two NAVs. If I do the CAGR across all the dates, I get a time series of the daily 2-year return starting from 2nd January 2015.

Before we proceed, let us look at this statement about rolling return again – ‘Rolling return gives us a perspective of how the ‘n years’ return (growth) has evolved over the last ‘n years’. Does this sound confusing now?

I hope not ☺

Anyway, one minor thing to note here – look at the 2nd data point, I have NAV for 5th January 2015, but I don’t have the NAV for 5th January 2013, but instead have the NAV data for 3rd January 2013, which I’ve used. As you may have guessed, this happens due to the weekend factor. So I’d suggest you ignore this bit.

Also, at this point, you should realize that if my objective were to calculate the 1-year rolling return, my starting point would be 2014, and if the objective is to estimate three years rolling return, then I would start from 2016.

Now that we have the Rolling Return time series starting from 2015, I can do a couple of things with the data. To begin with, we can calculate the range of returns for the time series we have calculated. To estimate the range, we simply have to calculate the max and min.

Here is the max –

And here is the min –

What does this mean? Well, assume two people invested in the AB Frontline Equity fund. The lucky person invested on 19th August 2013 and pulled out his investment on 19th August 2015. This person makes 37.76%.

The unlucky fellow also invested for two years, but he/she invested on 19th September 2017 and stayed invested till 19th September 2019. Unfortunately, this person lost money!

The point that I’m trying to make is that no two, 2-year returns are the same. The returns change depending on when you choose to invest and when you decide to pull out your investment.

Here is a graph of the rolling 2-year return starting from 2015.

And as you can see, the two-year returns have ranged from 37% to nearly -1.0%. If you were to invest for two years, then your return could have been anywhere within this range.

To get a perspective of the likely 2-year return, you can take an average of the rolling returns; this is called the ‘Rolling Return Average’.

The average is 15.35%.

So as you can see, the rolling return gives us a lot more insights compared to a point to point return.

So the next time you want to invest in a mutual fund, as a part of the analysis, include these two things –

1. Identify the period you are interested in investing
2. Find out the historical rolling return min, max, and average for the period

For example, if I’m looking at investing in a large-cap equity fund for seven years, I’ll check the historical 7-year rolling return for that particular fund. By doing so, I will get a perspective of historical return range plus its average.

In my opinion, this is much better than looking at a point to point return. By the way, I’ve used 2 years rolling return as an example. If you are looking at investing in EQ funds, then please consider at least 5 years rolling returns or higher.

In the next chapter, let us discuss other MF metrics that matter.

### Key takeaways from this chapter

1. Point to point return gives a perspective of the return only for the two days under consideration
2. Point to point return should not be taken as a generalization of return
3. The rolling return gives a better perspective of the return
4. Rolling return average is a better representation of the returns one can expect

1. simha says:

Thanks for this insightful chapter on rolling returns. This is somewhat new to me.
Seems rolling returns average also doesn’t fit. Since if I invest based on rolling returns average of 15%. But my actual return can be anywhere from -1% to 37%. So the 15% also kindof has no meaning. Seems the investment is very risky indeed. I agree that if the return is say between 8% and 25% with average of 15% then it makes sense. Probably 5/7 yr rolling returns might have lesser spread and be more meaningful. This probably also explains the fact that equity investments is for long term.
This is most insightful. Thanks!!

• Karthik Rangappa says:

Thats absolutely right. 2 years of data is pointless when you look at EQ funds. But it is convenient to convey the point of having a widespread and explain rolling returns. For this reason, if you look at the last line, I’ve mentioned that you need to take at least 5 years of data for EQ fund.

2. Purushottam pandey says:

Nice .. tell me the methode how to pull out money from mf when market is rooling down side. Correct procedure to withdraw money..

• Karthik Rangappa says:

You just have to place a withdrawal request on the terminal.

3. simha says:

Totally agree. Your explanation of rolling returns just nailed home the equity volatility risk for short term. Understand that you took 2 yr example to make us understand the concept. But as a byproduct the equity volatility risk realization dawned upon me. Though I was aware of it before. -1% to 35% really drives home the point.

• Karthik Rangappa says:

That was the point, to explain Rolling returns and also highlight the risk of Eq returns over short duration of time. Happy reading 🙂

4. M N reddy says:

This is really an attempt to confuse. Its plain timing the market/ buying low selling high concept. Mathematically it appeals. If its known before hand what is low one can wait
to buy low. But even buffet can not tell as to which is going to be lowest.

• Karthik Rangappa says:

Certainly not an attempt to confuse people. Everyone knows about timing the market, but we all know its easier said than done. The real message of this chapter is to help people understand that you should consider a wider set of data points to be aware of the range of returns that are possible. Also to drive home the fact that Eq funds can be risk if investments are made for short duration.

5. Sridhar says:

Extremely useful knowledge tip provided. Thank you Zerodha team…

• Karthik Rangappa says:

6. simha says:

Karthik,
In varsity the login and signup is not working. I used to have an account here. Now when I try to login it doesn’t work(even coming here from kite doesn’t work). So I tried to create a new account but it says new account creation is disabled. I am not able to reply to a comment. It only creates a new separate comment. With account probably it is possible since you are able to reply.

• Karthik Rangappa says:

7. Prashant says:

Sir, please explain me the procedure to have my data inputs in hand, for eg : if i want to roll 7-years return, what years range should be in hand atleast to calculate. I mean, do i need 7 years data to roll 7 years? I am confused at this point. Also, we are seeing it on daily rolling basis. How to do it – may be weekly or monthly ? And is it useful?

• Karthik Rangappa says:

For example, if you want to stat from 2010, then need to have the data starting from 2013.

8. Nandhakumar Subramaniyan says:

Wonderful write up…u guys have made finance so easy for some one like me from non finance background. Right from investing to derivative trading. U guys were one of the trigger for me read and invest rather than blindly investing based on news or advice. I owe u a lot…Thank u

• Karthik Rangappa says:

So happy to hear that! Good luck and happy reading. Hope your investing journey is successful.

9. Bhuvan Chand says:

Thank you, Sir, for bringing this topic to us. The concept you explained is neither new nor complicated but still overlooked by a novice MF investor like me. This concept has triggered a doubt that when I see CAGR on the Zerodha Coin while investing, how does it gets calculated?

For say, if I am looking at ABSLLDF 5 years CAGR today i.e. 01/08/2020, it is 8.63%. https://coin.zerodha.com/funds/14057710.00206600/aditya-birla-life-duration-fund-direct-plan

So what is the period behind this calculation is it 01-08-2015 to 31/07/2020? I mean that the CAGR appearing on the coin or other platforms is rolling one or it is calculated at a particular day of every year.

• Karthik Rangappa says:

Bhuvan, on coin it is point to point. It refers back to the same data ‘n’ years back and does the CAGRM math.

10. Akash says:

Sir
Thank you for clarifying this concept of rolling returns.
In the above example, you have calculated two year rolling average return as 15.35%. Sir how you arrived at this figure? As per my calculation, its coming out to be 18.4% (Max(37.76)+Min(-0.96))/2).

Thanks

• Karthik Rangappa says:

This is the average of all the data points, that’s how the average is calculated. Max+min/2 gives you the ‘Mid-range’, not average 🙂

11. Medha Gangal says:

Hello Karthik Sir,
Thanks for explaining the basics of mutual funds in a simplified manner. I am eagerly waiting for the next chapter on analysis and selection of mutual funds. When can we expect it to be published?

Thanks and best regards!

• Karthik Rangappa says:

Hopefully by next week 🙂

12. Medha Gangal says:

Thanks Sir

• Karthik Rangappa says:

Welcome!

13. rasik says:

This, something so basic yet never came across such valuable information.
Thanks

• Karthik Rangappa says:

Happy learning, Rasik!

14. Manasiz says:

• Karthik Rangappa says:

PDF will be available after the module is complete.

15. Nischal Kumar says:

Hi Karthik, Quick Question – Are rolling return and trailing return both same?

• Karthik Rangappa says:

No, Trailing returns are based on point to point measurement.

16. Nischal Kumar says:

Got glued to this personal finance materials and dint get bored at all. Finished all 19 chapters today itself. How nicely you explain such complex things! Fabulous!

• Karthik Rangappa says:

Thanks, Nischal. Thats a lot of reading for 1 day 🙂

17. VAIBHAV MITTAL says:

Where can we find rolling returns data for different mutual funds?

• Karthik Rangappa says:

I believe Morningstar or Value research provides this.

18. bajaj says:

• Karthik Rangappa says:

19. nikhilesh shukla says:

karthik sir please tell me how to make trading strategies?? what to look for in stock before selecting for trade?

• Karthik Rangappa says:

20. Giri says:

Sir I am a pretty decent 2d animator and I am planning to convert Varsity content into short videos. I of course plan on giving Varsity and Zerodha its due credit. Do I have you blessing to move forward with this? Thank you.

• Karthik Rangappa says:

Please do go ahead. It should be ok as long as you give Varsity and Zerodha due credit. Also, share the links here so that other people can also benefit. Thanks.

21. Mukta says:

Where to find the data on Rolling Returns? Averages generated by online portals are either based on annual returns or CAGR. Even the Coin App shows just CAGR of the fund.

• Karthik Rangappa says:

I think Moneycontrol has this, remember seeing it.

22. Amit says:

Is there some place where rolling return for equity funds can be viewed?

• Karthik Rangappa says:

Amit, I’m not sure about this. Maybe you should check the screener.in or Tijori Finance for this.

23. Vicky says:

Thanks Karthik for this article. It is really insightful about the returns generated by MFs and why we shouldn’t look at the point to point returns. Rolling returns gives us clear idea about how the fund is performing. Although the risk of fluctuation of returns -1% to +35% is really big and one should only look to MF investment for long terms (as you said for 5 years atleast).
It’s always good to read an article in Varsity. Keep publishing such content.

I really noticed one thing in the Varsity that although the Varsity works under the Zerodha Brokerage firm, you don’t promote or advertise any of your product unless there is necessary to understand anything about when you explain it.
Thanks for it again 🙂

• Karthik Rangappa says:

Thanks for the kinds words, Vicky. Yes, we don’t intend to clutter it with promotional stuff. Our idea here is to share whatever we know, and we will stick just to that 🙂
Happy learning!

24. Shashank Arya says:

This is great!

• Karthik Rangappa says:

Happy learning!

25. Manish Kothari says:

On which website can we get the rolling returns of mutual funds

Thanks for all information abour rolling returns and it is worth of knowledge. But still I am not convinced if this method is helpful in evaluating individuals investment return. Suppose I invested 2000/- on 1st of march 2015 and if I want to withdraw amount on 1st of march 2020 then I will definitely look for point to point return (CAGR) instead of rolling returns. Also, i guess, since benchmark returns are also calculated with point to point method, rolling return method won’t help to compare with benchmark returns.
Maybe rolling returns method is just another parameter (secondary) to track MF performance?

• Karthik Rangappa says:

Yes, the point of return is for measuring your returns, but the rolling return is to get a perspective of the past returns. In my view, rolling return is much better than regular looking at point to point return.

27. Ajay says:

Where can i get rolling retrun data availabe. I mean i dont want to calculate it

• Karthik Rangappa says:

I saw Rupeevest has a nice portal to check RR I suppose.

28. AG says:

Where can I get the 10Yr NAV data to calculate the min/ max/ avg rolling return for few MFs I am planning to choose from? Or is there a website that lists that?

• Karthik Rangappa says:

Try the AMFI website.

29. Danish Tamboli says:

Here as Simha said having a range of -1% to 37% and averaging it to 15% would be a foolish thing to do, So in this case, wouldn’t it be better to have weighted rates, as on the basis of frequency of that rate/ rate range? and rather than just having a single weighing factor, we could have -ve or lower returns (say 0-7%) have a greater importance/weight than higher returns (7+), Wouldn’t this method of calculation project a lower than actual rate of return, but would be conservative in a good way, that it’s taking into account a worse possible case?

Would love to hear your opinion on this @karthik as this is an assumption I’m making from my recent exploration into data analysis as a student still in his undergraduate programme. 😅

Also, I wish I knew about Varsity 2-3 years back, great material, written beautifully, recently found out about this via Tanmay Bhat’s stonks podcasts. I’ve always felt quite intimidated with posts on other sites, but Varsity does an excellent job breaking it into smaller easier to understand and digest chunks.

• Karthik Rangappa says:

Danish, can you please give more context to the weighted rates? The question is, how will you assign weights? Nice to know about the podcast. Can you share to link please?

30. Danish Tamboli says:

So Weights and biases are something that is extensively used in Machine Learning models, Weights are something that keep changing as a model learns to predict the outcome, on the other hand, Biases are constants that remain the same over multiple iterations of the model (Constants).

Lets take a simple equation say y= b0 + b1x +b2x
here b0 will be your constant, such as an intercept, and b1 and b2 are weights that change over iterations to better fit a model.

The idea behind it is that certain features are more important than others, say in recognizing a Face, the prominent features would be the Eyes, Nose, Ears, Mouth, etc, and hence would have greater weight as compared to other features such as say freckles, the difference in the shape of the face from one person to another, Eyebrows, Eyelashes, etc. As the prominent features make predicting a face much easier and generalized.
The bias, in this case, would say be faces of a particular race, could be due to facial color.

So, my null hypothesis is, in ideal conditions, your SIP’s profit/loss per month over a span of say 5 years will be distributed normally, (so no profit-no loss / negligible profit/loss), but this usually isn’t the case, most times you experience a significant percentage of profit or loss. (-10% ,+10%).(where standard Hence not normally distributed.

Now hence if we have higher weights to the Tails (Ends) of this distribution (say 2.5/5th and 95/97.5th percentile), where again the 2.5/5th percentile (Loss) has a higher weight than 95/97.5th percentile (Profit) and lower weights elsewhere. What this would do is make a conservative calculation of your overall profit.

As to how to go about assigning weights, it’s an interactive process, basically trial and error (either manually or machine learning) till your start getting numbers that you think are good.
Could be as simple as say 1.5 for 2.5/5th percentile, 1 for 95/97th percentile, and 0.5 for rest.

https://www.researchgate.net/profile/Caio_De_Oliveira2/publication/317371065/figure/fig3/AS:638065001385993@1529137959645/Comparison-between-a-t-distribution-with-n-10-and-a-normal-distribution-The-area.png

I hope I’ve expressed myself in an easy to understand manner. 😅 I could be totally wrong in my assumptions though, hope someone could correct if I am.

Regarding the podcast here’s the Link of Episode 1: https://www.youtube.com/watch?v=KW2sdHBGzCI&ab_channel=HonestlybyTanmayBhat , It’s had a total of 3 episodes so far.

I have a small doubt – the spread ranges from 37% to -1%, and as we can see from the graph, return rates are declining post 1/2/2018.
As a novice investor, should I consider investing in a fund that is on a declining rolling return rate from past 1/2 years? In this example, the fund had phenomenal gains from 2013 to 2015, and 2017-2018 but the return rate is declining post 2018.

Also, just a curious thought, can the rolling return curve be used as a rough estimate to pull out from the fund (if we see a consistent decline for an year or so)?

Doubts aside, absolutely love the Varsity modules! Thank you for spreading this knowledge free of cost 🙂

• Karthik Rangappa says:

Aditya, when you look at rolling returns, look for two things –

1) Consistency of returns
2) Compare it with other funds of similar nature, this gives you a perspective of how the fund is performing on a overall basis.

Yes, if the returns are declining over the years (while other funds are performing), you may want to relook at this.

32. Prateek Pandey says:

Hey Karthik,
I could write a blog thanking you for your service in form of Varsity 🙂 For now, it’s a big Thank-you 🙂
regarding my question is there a place where I can find rolling returns data for a mutual fund?

• Karthik Rangappa says:

Thanks Prateek, this means a lot to us 🙂

Check Rupeevest website, they give out the rolling returns.

33. Prasannakumar Bansode says:

But , what type of returns are published on website ? Where to look for rolling return?

• Karthik Rangappa says:

We will soon have this on Coin as well, but check Morningstar for now.

34. Nipun says:

Hi Karthik,

Great article! Thanks for simplifying concepts with math and real-world data 🙂

You mentioned “many websites publish the mutual fund’s rolling return”, Can you please name a few such websites?

I looked at the Value Research website, they provide 1Y, 3Y, 5Y returns. They don’t explicitly mention that it’s a rolling return but it is right?

• Karthik Rangappa says:

Nipun, thanks for the kind words. I think folks at Rupeevest provide the rolling returns.

35. Avi says:

So sir if I were to invest for next five years, I should look last 10 year historical performance, starting 2011from 1st jan 2015 and 1st jan 2011 I need to calculate so on and so forth
Am I correct sir

• Karthik Rangappa says:

That’s right, both risk and return should be evaluated 🙂

36. Mohanish Golatkar says:

What do the historical returns stated for a MF when we use websites like valueresearchonline signify? Is it the point-to-point return for that particular day on which we are checking the returns or is it some other form of return?

• Karthik Rangappa says:

I guess some of these sites provide you with a variety of returns such as – calendar returns, point to point, FY returns.

37. VenkataKrishna says:

Explained very well in an easy to understand way.

In the first key takeaways, it was written two “days”. I think it was meant to be “years” as per the case studied.

• Karthik Rangappa says:

Ah, thanks. Let me check on this.

38. Purav Kansara says:

Please tell which website shows rolling return of mutual funds . Thanks

• Karthik Rangappa says:

Have mentioned the same in this chapter right?

39. Andrew Femin says:

Thanks for this crystal clear explanation. In some websites that compare the returns of various mutual funds, I see the term “Annualized returns”. Can you please explain how different(or similar) it is to CAGR/XIRR?

• Karthik Rangappa says:

It is the same as CAGR, Andrew.

40. Nitin K says:

Great chapter and beautifully explained.

• Karthik Rangappa says:

41. Mohit says:

Hi Karthik sir,

Can you give some insight as to is there a metric like rolling XIRR to find/compare out the historical rolling SIP min, max, and average for a period?

Like we have the concept of rolling returns to analyze mutual funds when we want to invest in lumpsum to finally receive an absolute return for the investment tenure, I wonder if there is a similar concept of rolling XIRR returns to analyse/benchmark mutual funds when we want to investas SIP?

If not, how can we use the concept of rolling CAGR itself to compare with the XIRR data?

• Karthik Rangappa says:

No, XIRR is based on your actions, so a rolling XIRR will not be available. You can compare XIRR and CAGR to get an estimate of how the fund has performed during a given period versus how you have performed (assuming you are doing a SIP).

42. Mohit says:

Thanks, got it! Just one side query: Will the Coin users be notified via email about significant changes in a mutual fund they are invested in via SIP?
For eg: let’s say the expense ratio of the Fund is increased or if the Fund Manager is changed. These are some significant changes that can occur in a fund, and if that is so, its important that the investors are made aware of the same. So will Coin or the AMC notify via email? Do you know any good website/platform which provides this notification service?

• Karthik Rangappa says:

No, we don’t have this feature Mohit. Also defining ‘significant’ can be a very tricky affair 🙂

43. Prabha says:

Thanks Karthick for introducing this concept. It looks like our SIP date also makes an impact on the returns. Is there a way to find a best date to start SIP?

I checked the historical NAV of few funds and I can see NAV is lower on the 25th or 20th of month compared to 5th of month in most of the cases. Is it because many SIP’s starts at the beginning of the month which may influence in increase of share price& NAV? Can you please let me know if my assumption is correct?

• Karthik Rangappa says:

I’m really not sure (and I believe it does not matter), all my SIPS are on 5th of every month 🙂

44. Shaishav says:

Thanks for detailed explanation on topic!! It really helped me to understand this concept.

• Karthik Rangappa says:

45. Varun Fatehpuria says:

Karthik, many thanks for the materials. What is the time period i.e. start date and end date that we should typically look at for 1/3/5 year rolling returns.

• Karthik Rangappa says:

At least 3 yrs or more, Varun.

46. Darshan says:

Thanks Karthik for demystifying the concept of rolling returns for so many! Please confirm if the returns zerodha coin app show for 1,3 & 5 years for each fund are rolling or point to point returns? Plus, how to normalize the returns with the help of standard deviation to identify the scheme with highest risk adjusted returns! I hope coin will have this! (morning star and moneycontrol do present more details about mutual fund schemes and as a zerodha enthusiasts, I would like to have this info in coin too!)

• Karthik Rangappa says:

Darshan, the returns shown on Coin is a simple point to point, we don’t have rolling returns. For now, you can look at SD, shape, and capture ratio to get a sense of how risky the fund is. Unfortunately, we don’t have these on Coin, but we are trying to bring out a new version with these.

47. Kunal says:

Please correct me if I am wrong or explain where I am getting wrong conceptually.
1. If I want to analyze 5 year rolling returns and I have data for 10 years from 2010-2020. Will my starting point be some what like this:
end value(1/1/2015)-(1/1/2010) beginning value
end value (2/1/2015)-2/1/2010)…. and so on.

2. How can I calculate 5 year rolling returns, with a monthly frequency.

Please correct me if I am wrong in the first point

• Karthik Rangappa says:

1) Thats correct.
2) 5 yrs is 60 months, so assuming you have 10 yrs data i.e. 120 months, then you calculate the rolling 60 months returns.

48. Simran says:

Hey,
Why don’t we talk about the rolling returns of shares ( stock market)?

• Karthik Rangappa says:

There was no context for it, but anyway, for a share, it may not make sense since its lot more volatile compared to a portfolio.

49. Suraj says:

Where can I get historical NAVs data to put them in an excel sheet?

• Karthik Rangappa says:

AMFI website.

50. Honey Narang says:

You may also use ‘=Googlefinance’ function in google sheets to get NAVs of any MF for any date ranges. Really nice feature of Google Sheets, I’m using it for maintaining all my investments MF, Stocks, Indices at one place

• Karthik Rangappa says:

Ah, I’ve not used that. Let me check, thanks for letting us know.

51. Kunal Modi says:

Hello Karthik,
Thanks for the prompt revert.
Would you mind elaborating on the monthly returns point I had asked in my previous comment.
I am having a little trouble understanding it

• Karthik Rangappa says:

For monthly, you need to define the OHLC first –

O = OPening price of the first day of the month
H = Highest price during the month
L = Lowest price during the month
C = Closing price on the last day of the month

Once you have this for all the months across all the 10 year data points (120), then you proceed to calculate the Rolling return the way you described in the first part of your question.

52. Sahil says:

How to find graph of rolling returns of some particular MF of particular rolling period? Q2. Best way to get historical data?

• Karthik Rangappa says:

YOu can get that on few websites that I’ve mentioned in the chapter itself.

53. Manish Chandra says:

Which websites can I refer to in order to check rolling returns of a MF fund?

• Karthik Rangappa says:

I think Rupeevest used to have this, Manish. PLease check their site. Thanks.

54. Deepthi says:

What if I have invested in a Eq fund for one year and then before the maturity date I would want to extend it by another 6 months , can it be possible.

• Karthik Rangappa says:

Yes, you can.

55. Samaksh says:

Is the rolling returns concept useful just for lumpsum investments? How would it work with SIPs?

• Karthik Rangappa says:

RR gives you a good perspective on the return profile. You can use that for either lumpsum or SIPs.

56. Ramesh says:

Can some one please suggest the best reliable online platform/website to calculate the rolling returns?

thanks

57. Ramesh says:

58. Mala Bhatnagar says:

For a while I am inclined to move to index funds given it has more more clarity and the fact that most fund don’t end up beating it. But when I tried to use this rolling rate concept to index fund (HDFC nifty 50) vs say Axis focused 25, my average return are coming in much lower (14% vs 21%). I have used the daily NAV data from 2013 onwards. Based on this my Axis focused fund look more promising. I am missing something in my understanding and analysis?

• Karthik Rangappa says:

Not really, probably Axis manages the tracking error better which may result in higher returns. But please do double check.

59. Poulomi says:

This is good – thanks a bunch.

• Karthik Rangappa says:

60. Gaurav says:

What is the minimum number of samples one should look at and does this change for different year returns ?

61. Keshav Taparia says:

Sir can you tell me in brief about what rolling returns are ?
You tried very well but I couldn’t understood the same .

• Karthik Rangappa says:

That’s the best I could explain in 🙂
Can you tell me which part is confusing? Maybe I’ll try and explain just that bit?

62. Nipun says:

Hi Karthik,

Great explaination!

Curious to know how can get rolling returns indicator on a stocks chart? Something similar to line chart of Simple Moving Average/Exponential Moving Average?

Can you point out any such performance indicator for a stock which is similar to rolling returns supported either by Tradingview or ChartIQ chart on Kite platform?

• Karthik Rangappa says:

I’m not sure if this is available on either of the platforms, Nipun.

63. Sunil says:

Thanks Karthik for good lessons.

Regards,
Sunil

• Karthik Rangappa says:

I think Rupeevest is the other source, not many out there.

64. Abhinav G says:

I understand the rolling returns graph as way to understand how returns (CAGR) changes over time. But what would an average rolling return tell me? Please clarify.

• Karthik Rangappa says:

In a sense yes. It gives you a quick perspective on how returns were for the two dates under review.

65. Shivansh Agarwal says:

what’s the difference between “trailing returns” and “annualised returns” as I looked for it, I am not able to find the difference between the both I am finding them the same.

• Karthik Rangappa says:

Annualised return is the return (or growth rate) measured on a yearly basis. Trailing returns is similar but the time duration can be defined to anything – quarterly, half yearly, yearly etc.

66. Shivansh Agarwal says:

I was calculating rolling return for a fund over a period of 5 years but due to weekend factor the difference in dates by the time I have reached “8 Apr, 2022” has gone upto 3 months the 5years ago NAV for the latest date is “30 Jun, 2017”.
so is this normal while calculating rolling return or there is some another way to overcome this huge gap

• Karthik Rangappa says:

No. Why don’t you clean up the data series and remove the weekends?

67. Shivansh Agarwal says:

I have done it, I have removed all the dates in which there was a weekend or a holiday

• Karthik Rangappa says:

Ah, ok. Then have you cross-checked if the dates are exactly the same for both arrays? These two things is where most go wrong.

68. Shivansh Agarwal says:

I have done it, I have removed all the dates in which there was a weekend or a holiday but then to this problem is there.
how can I resolve it

69. rahul says:

so ideally choose those funds which have less rolling return spread?

• Karthik Rangappa says:

Yeah. Less is relative to your risk appetite 🙂

70. NIKITA says:

in rolling return ,let assume for 5yr we calculate
period is 2015-2020
1-1-2019/1-1-2016
end with 1-1-2018/1-1-2017………..is right?
period for 5 yr calculation for 2015-2025 is right ?
which one is right?
AND also expln how to calculate average rolling return ?
THANKS

• Karthik Rangappa says:

You can move the starting and ending dates by 1 day, and you will get the rolling returns, Nikita.

71. Ananth says:

Thanks for this. If not anything, the rolling return trend of a MF might point to the competency of the Fund manager (for the duration of him/her managing the fund. Is there a site that helps sort MFs by their rolling returns? I couldn’t find any or I am bad at looking. Moneycontrol has only a CAGR option. Thanks!

• Karthik Rangappa says:

Not many out there, Ananth. A site called Rupee Vest used to publish this data, you may want to check their site once.

72. Rishik kedia says:

Sir, from which website we can get data about rolling returns of a particular mutual funds

• Karthik Rangappa says:

Rishik, if I’m not wrong I’ve mentioned the website which has the rolling return detail. Can you please double check?

73. Log says:

Hi Karthik Sir, I believe more than just average. The average and distribution around it maybe even more important and insightful. For example we can have wide distribution of average 18%, but has rolling returns distributed from -1% to 37% it maybe less desirable than say rolling returns which are only 15%, but returns are tightly distributed from 10% to 20%.

• Karthik Rangappa says:

Yup, you do have a point.

74. Saurab Kanwar says:

Very insightful chapter Karthik, thanks a lot team!
Do we show rolling returns of mutual funds as a metric on Coin or we have to check it with AMC issuing the fund?
I can see CAGR but not rolling returns.

• Karthik Rangappa says:

The factsheet provides this, Saurab.

75. Aryan says:

Hi!
Thanks for explaining this concept so well. I just had this one doubt that, how does one time the market well enough, to know that the market is approaching a low or high? How can someone time the market well enough, so that one can make the maximum advantage out of a lumpsum investment?

• Karthik Rangappa says:

Aryan, that’s an answer I’ve been trying to find for myself for the last 18 years 🙂

76. Ashutosh Kankne says:

Sir,
Rolling returns of same mutual fund for same time period for same time interval is showing different on different websites. Please advise which website to follow for the same.

• Karthik Rangappa says:

Ashutosh, i think the AMC website itself provides the data now. Look for the rolling returns in the fact sheet of the scheme you are interested in.

77. Neeraj says:

Sir, how did yo arrive at 15.35% as Rolling Return Average?

• Karthik Rangappa says:

Its based on the calculation, which we have discussed in the chapter.

78. Neeraj says:

• Karthik Rangappa says:

Good luck!

79. lleo says:

Is there a source where we can calculate the rolling returns for the stocks as they occur, similarly to how we calculate the returns from mutual funds?
Is the rolling return shown by the SMA and EMA in stocks?

• Karthik Rangappa says:

Rolling returns are published by the AMC’s fact sheet itself. Even the returns are calculated by the AMC or 3rd party sites like value research.

80. Vinoth says:

Could you please help me find a page that offers more detailed information for comparing different mutual funds? I’ve been using Money Control, but I’m having difficulty understanding the example they provide.

81. Sanjay says:

What are the screening tools for 5yr/10yr rolling return? Is the filter available in Coin?

• Karthik Rangappa says:

No, but I think AMCs have started reporting this as well.

82. Anirban Basak says:

Sir,

Is there any source from which I could get the ready data for various periods of average rolling returns of different funds.

• Karthik Rangappa says:

I think the fund houses have started publishing this data themselves in the fact sheet, you can check that Anirban.

83. Rujul Bhatt says:

Thanks, Kartik for writing this chapter. Unfortunately, not all funds publish this information. How do you track this information for the funds that do not publish it? In addition, how do I find latest rolling returns of NIFTY Indexes? For instance, NSE published rolling returns of NIFTY MidCap 150 in September 2021 through Whitepaper but nothing after that.

• Karthik Rangappa says:

Rujul, I did notice few AMCs publish rolling returns and assumed its a standard effort. Did you check thrid party sites like Morning star and Value research?

84. Rujul Bhatt says:

Happy New Year, Kartik!

Out of the 28 active MidCap funds, I wanted to review 6 MidCap funds after applying all the hygiene criteria’s. Out of these 6, Kotak/ Edelweiss did publish rolling returns on their website (differs from what 3rd party like ET Money published) but I could not find anything for SBI Magnum/ HDFC MidCap/ Quant MidCap either on their website or on 3rd party site such as Value Research/ MorningStar. ET Money do publish the rolling returns for all the funds but I am not sure how credible that data is!

• Karthik Rangappa says:

Happy New year to you as well. One thing you can do is to speak to the investor relation cell of the AMC and ask for the rolling returns. Most of them acknowledge it I guess.

85. Ishwar says:

@Zerodha – You had NAV for Fri 4’th Jan 2013 and yet for 5’th Jan 2015 you used NAV for Thu, 3’rd Jan 2013. Any reason for not choosing Fri 4’th Jan 2013? Kind of similar pattern where you haven’t used NAV for other Fridays like Fri 11’th Jan 2013, Fri 18’th Jan 2013…

Is it an oversight or any reason for skipping Fridays in “2 Years ago” calculation?

• Karthik Rangappa says:

Are you sure? There is no reason to skip Friday NAV, must be an oversight.

86. Daniel Fernandez says:

1) Could you please state where can an individual investor find rolling returns of an Index Funds such as NIFTY 50 and NIFTY 150?

2) Would it be fair to assume that rolling returns of NIFTY MidCap 150 would be higher than NIFTY 50 Index?

Looking forward to hearing from you.

• Karthik Rangappa says:

1) Can you check with Tijior Finance, I think they do.
2) Ah no, you cant generalize this. This really depends on market cycles. There could be times when largecaps could perform way better than mid caps.

87. Md Sivlee Rahman says:

So how can i get the 12 month Rolling return, and If I do 12 month gap between two data points, i Don’t need to annualized roght?

• Karthik Rangappa says:

Yeah, for 12 months, you dont really have to do that.

88. Disha says:

Hi,

How can I get NAvs for these many years? If I want to invest tody from what to what date I should consider the data.

Regards

• Karthik Rangappa says:

Please check the AMFI website, or perhapse the AMC’s investor relationship desk?