Rolling Returns vs Trailing Returns: What's the Difference?

A trailing return measures a fund's performance from a fixed date in the past to today. When a fund factsheet says "3-year return: 14.2%", it means: if you invested exactly three years ago today and redeemed today, this is what you would have earned (annualised).

This is simple to calculate and easy to understand. The problem is that it's completely dependent on the start date. Change the start date by three months and the number might be 11% or 18% — the same fund, the same three-year window length, but wildly different figures.

Rolling returns calculate the return for every possible start date over a given period length. For a 3-year rolling return with monthly data, you'd compute: Jan 2021 → Jan 2024, Feb 2021 → Feb 2024, Mar 2021 → Mar 2024 … all the way to the most recent 3-year window. Each calculation gives you one data point. Put them all together and you have a time series of 3-year returns.

The result is a distribution: what has this fund typically returned over 3-year periods? What was the best 3-year window? The worst? What percentage of windows were positive? What's the median? These questions cannot be answered with a single trailing return — but they're exactly what a serious investor needs to know.

Consider two funds, both showing a 3-year trailing return of 13% as of today. Here's what their rolling 3-year data might look like across the last five years of windows:

Fund A rolling 3Y returns: Min 4%, Median 13%, Max 22%, % positive windows: 95%. Fund B rolling 3Y returns: Min −3%, Median 13%, Max 28%, % positive windows: 72%.

Both funds show exactly the same trailing return today. But Fund A is a steady compounder that rarely has a bad 3-year period. Fund B is a high-variance bet that occasionally delivers spectacular results but also occasionally loses money over three years. The trailing return tells you nothing about this difference. Rolling returns make it obvious.

The core problem with trailing returns is that any single start date is arbitrary. Markets are not linear — they crash, recover, boom, and stagnate. A fund measured from a crash bottom looks brilliant; the same fund measured from a peak looks mediocre. Neither picture is necessarily fair.

Rolling returns average out this bias by using every possible start date. A fund that was genuinely good over any 3-year period — regardless of when those three years started — will show high and consistent rolling returns. A fund that looks good only from certain convenient start dates will show wide dispersion in its rolling return distribution.

MFLens fetches NAV history for every Indian mutual fund from AMFI's public data via mfapi.in. Rolling returns are calculated using daily NAV data, with annualised returns for each window computed using the standard CAGR formula: (End NAV / Start NAV) ^ (365 / days) − 1.

We calculate rolling windows for 1Y, 3Y, 5Y, 7Y, and 10Y periods, then compute the distribution statistics: mean, median, min, max, and the percentage of windows with positive returns. The rolling chart plots every window as a data point over time, so you can see how performance evolved — not just where it stands today.

Trailing returns have their place: they're standardised across the industry, comparable across funds on the same date, and useful for year-end tax calculations. If you want to compare how two funds did in a specific calendar year, trailing returns are the right tool.

Rolling returns are the right tool for evaluating a fund manager's consistency, identifying start-date bias, and making investment decisions. Before investing in any fund, look at its rolling 3-year and 5-year return distributions. A fund with a strong median and a high percentage of positive windows — across all market conditions — is a much safer bet than one with a spectacular current trailing return and a volatile history.