Trailing returns mislead: what rolling returns reveal across 830 funds
A single “5-year return” is one accident of your start date. The median fund's swung 10.6 points by window.
Open any fund page and you'll see a single number: "5-year return: 14.2%." It looks like a fact about the fund. It's really a fact about one start date — the day exactly five years ago. Pick a slightly different entry point and that number can look completely different. Trailing returns quietly hide this; rolling returns expose it.
We measured it across every fund with five years of history. The result is a number worth sitting with: the median fund's 5-year annualized return swung 10.6 percentage points depending on which five-year window you happened to measure.
Trailing vs rolling, plainly
A trailing return measures one span: today back to N years ago. A rolling return measures every N-year span in the fund's history — start-in-January, start-in-February, and so on — and reports the distribution: the average, the best window, the worst window, and how often the fund was positive. Instead of one lucky (or unlucky) number, you see the range of experiences real investors actually had.
| What rolling returns show (5-year windows) | Value |
|---|---|
| Funds measured (5Y history) | 830 |
| Median fund's best-minus-worst 5Y window spread | 10.6 points |
| Example — a low-volatility debt fund's 5Y rolling range | 6.05% to 8.47% |
Why the spread matters
Two investors in the same fund, entering a year apart, can walk away with materially different five-year returns — not because the fund changed, but because the window did. A headline "5Y: 18%" might have been anywhere from 12% to 24% for the person who started a few months either side of you. The trailing number treats one of those outcomes as the outcome. The rolling range treats all of them as what they are: the honest spread of what the fund has actually delivered.
What to look at instead
When comparing funds, the useful rolling numbers aren't just the average — they're the worst window (how bad did patient investors ever have it?) and the percent of windows that were positive / above your target (how reliable is it?). A fund with a lower average but a much better worst-case is often the steadier hold. That is exactly what a rolling table shows and a single trailing number can't.
A worked case: an 18-point gap on one fund
The 10.6-point median swing above is the typical case. Here is what it looks like at the extreme, measured across our fund universe on 31 July 2026.
| Fund | Trailing 5Y | Rolling 5Y avg | Rolling min | Rolling max |
|---|---|---|---|---|
| ICICI Prudential Technology Fund | 6.42% | 25.25% | 5.41% | 37.26% |
| Tata Digital India Fund | 6.84% | 25.29% | 5.63% | 37.63% |
| Aditya Birla SL Digital India Fund | 6.67% | 24.52% | 4.97% | 35.39% |
| ICICI Prudential Commodities Fund | 14.19% | 30.11% | 13.78% | 45.87% |
| Tata Small Cap Fund | 15.02% | 29.39% | 14.90% | 41.23% |
The three technology funds show a trailing five-year return around 6.4–6.8% against a rolling five-year average near 25% — a gap of roughly 18 percentage points a year on the same fund over the same nominal horizon.
It comes entirely from the start date. Indian technology funds ran into a peak about five years before this snapshot, so anyone measuring from exactly that day gets a poor number. The rolling minimum and maximum columns show the range: 5.41% at worst, 37.26% at best, for identical five-year holds started a year or two apart.
What rolling returns still don't fix
They remain backward-looking. A wide historical range says the fund has been volatile across entry points. It says nothing about whether the next five years resemble any of those windows.
They are bounded by available history. A fund with six years of NAV data has very few distinct five-year windows and they overlap heavily, so its rolling statistics carry far less information than those of a fund with fifteen. Our fund pages show the history length so you can judge this yourself.
Key takeaways
- A trailing return is one number tied to one start date; it hides how much entry timing mattered.
- Across 830 funds, the median fund's 5-year return swung 10.6 points by window.
- Even a stable debt fund's 5-year rolling return ranged 6.05%–8.47%.
- Rolling returns show the average, the worst window, and how often the fund was positive.
- Judge consistency by the worst window and the hit-rate, not the headline number.
- At the extreme, three technology funds showed ~6.4% trailing 5Y against ~25% rolling 5Y average.
- Rolling statistics are weak for short-history funds, because the windows overlap heavily.
See these ideas on real stocks
StockLearn runs this read on ~2,000 NSE stocks every evening. Nifty 50 is free, no login.
Browse today's scan →This article reports figures computed from StockLearn's own fund dataset (AMFI NAV data, direct-growth plans) over a specific period. It is educational research, not investment advice or a recommendation to buy or sell any fund. Past performance does not predict future returns.