Almost nobody knows their actual return. They know which stocks did well, they remember the winners vividly, and they have a rough figure in mind that is nearly always too high. Measuring properly is uncomfortable, which is exactly why it is worth doing.
Use XIRR, not what your app shows
Every broker and mutual fund platform can export your transaction history. Paste the dated cash flows into a spreadsheet with the current value as the final flow, apply the XIRR function, and you have the real number in about ten minutes.
Against what?
A return with no benchmark is not a measurement. The right comparison is the thing you would have bought instead — for most people, a broad low-cost index fund, which is available to anyone with no work and almost no fee.
| Comparison | Whether it is fair |
|---|---|
| Your XIRR versus a broad index fund’s XIRR over the same dates | Fair. Same period, same cash-flow timing, same currency. This is the honest test. |
| Your return versus the index’s point-to-point return | Unfair to you — your money went in gradually, the index figure assumes a lumpsum on day one |
| Your smallcap-heavy portfolio versus the NIFTY 50 | Unfair in both directions. Compare against a smallcap index, or you are measuring style, not skill |
| Your best stock versus anything | Not a measurement at all. This is the one people quote. |
Include everything
- Every account. Including the one you stopped using after it went badly. Excluding it is exactly the survivorship bias you are trying to escape.
- Costs and taxes. A pre-tax, pre-brokerage return is not a return you received.
- Cash drag. Money sitting idle waiting for opportunities is part of your capital and part of your result.
- A long enough period. Three years is the minimum for the number to mean anything; five is better. One good year proves nothing.
What the answer is for
The point is not self-criticism. It is a decision: if after five honest years you are meaningfully behind a broad index fund, the rational response is to move the core of your money there and keep a small satellite for the part you enjoy. That is not failure — it is acting on evidence, which is the whole discipline.
Five years of results
You calculate your XIRR across all accounts, after costs and taxes, over five years: 11.2%. A broad index fund over the same dates, with the same cash-flow timing, returned 13.6%. You spent roughly four hours a week on research throughout. What do you conclude?
14% return achha hai ya bura? Index ne 12% diya toh achha, 22% diya toh nahi. Par dost ka ek stock 60% bhaaga — woh comparison hai hi nahi, woh uska poora portfolio nahi hai. Sahi paimana index hai, dost ki story nahi.
- Absolute return is meaningless once you add money over time. Use XIRR.
- A return without a benchmark is not a measurement.
- Compare against the index you would actually have bought, over the same cash-flow dates.
- Include every account, all costs and taxes, and idle cash.
- If you are behind after five honest years, moving the core to an index fund is acting on evidence.
Mark it done to track your progress through the curriculum.
Common questions
Short, direct answers to what people ask about this topic.
- xirr meaning in portfolio returns
- XIRR — the extended internal rate of return — is the annualised return that accounts for the exact date and size of every rupee you put in and took out. It is the honest measure once you have been adding money over time, because absolute return treats a rupee invested last month exactly like one invested five years ago. Both Excel and Google Sheets have an XIRR function that takes a column of dated cash flows with today’s portfolio value as the final entry.
- the return figure that weights every cash flow by how long it was invested is called
- XIRR, the extended internal rate of return. Absolute return — total gain divided by total invested — ignores timing completely, which is why it flatters anyone who has been adding money steadily. XIRR solves for the single annualised rate that makes all the dated inflows and outflows reconcile with today’s value.
- what should I compare my portfolio return against
- Against the broad low-cost index fund you would otherwise have bought, measured over the same dates and with the same cash-flow timing. Comparing your gradual investing against an index’s point-to-point figure is unfair to you, and comparing a smallcap-heavy portfolio against the NIFTY 50 measures style rather than skill. A return quoted with no benchmark is not a measurement at all.
- how many years of returns do I need before the number means anything
- Three years is the minimum for the figure to carry any weight, and five is considerably better. A single strong year mostly records which style the market happened to favour, not whether your process works. Shorter windows also let one lucky position dominate a number you are about to draw conclusions from.
- why is the return my broker app shows higher than my xirr
- Because most portfolio screens display absolute return — total gain divided by total invested — which ignores how long each rupee was actually working, so recent additions carry the same weight as money invested five years ago. App figures also usually cover only that one account and sit before brokerage, STT and tax. Your XIRR across every account, after costs, is the number that reflects what you actually earned.