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.
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.
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.