Time-Weighted Return Calculator

Log buys and sells with dates to get net return, money-weighted return (XIRR) and a true time-weighted return chained from share prices at each trade.

The interactive tool loads here when JavaScript runs.

About this tool

What is the Time-Weighted Return Calculator?

The Time-Weighted Return Calculator measures how a holding has really performed when you have added and withdrawn money along the way. You log each buy or sell with its date and amount (and optionally shares and price), enter today's value, and it reports three numbers: the net return on money invested, the money-weighted return (XIRR, annualized) and the time-weighted return.

The time-weighted return needs a valuation at every cash flow. This tool gets it from share prices, so it is calculated only when every transaction has a share count; it then works for a single fund or stock. Without shares it shows n/a rather than guessing. XIRR and net return work from dates and amounts alone.

Transactions and the current value are saved in your browser's localStorage, so they survive a page reload. Nothing is sent to a server. Four sample portfolios load with one click.

  • True time-weighted return chained from per-share prices
  • Money-weighted return (XIRR) on actual days / 365
  • Buys and sells with dates, shares and prices
  • Four sample portfolios to explore
  • Text report download, copy and share
  • Data saved locally in your browser, nothing uploaded
Read the guide: Time-Weighted vs Money-Weighted Return (TWR vs XIRR)

Updated

How to use the Time-Weighted Return Calculator

  1. Click a sample such as Monthly SIP to see the layout, or Clear All Data & Start Fresh to begin with your own data.
  2. Under Add Transaction, choose Buy or Sell, set the Date and Amount, and fill in Shares (and Price per Share if you know it). Click Add Transaction.
  3. Repeat for every purchase and sale, then type today's portfolio value into Current Value.
  4. Read Total Returns, Net Investment, Time-Weighted Return and Money-Weighted Return (XIRR, annualized).
  5. Use Copy, Share or Report to export a summary and the transaction list as text.

Worked examples

Buying more at the top

Input

Buy 10,000 for 1,000 shares on 2023-01-02; buy 9,000 for 600 shares on 2023-07-03; current value 19,200 (1,600 shares at 12)

Output

TWR +20.00% (sub-periods +50% and −20%); net return +1.05%; XIRR about +0.83% a year if today is 2024-07-01

The fund itself rose from 10 to 12, so TWR is 20%. You put the bigger second deposit in at 15, just before the price fell, so your money-weighted result is close to zero. Both numbers are correct; they answer different questions.

Chaining is not averaging

Input

Prices 10 at the first buy, 12 at the second, 15 today

Output

Sub-period returns +20% and +25%; TWR = 1.20 × 1.25 − 1 = +50%

The average of 20% and 25% is 22.5%, which understates the real gain. Geometric linking matches the simple fact that the price went from 10 to 15.

Background and insight

Time-weighted return (TWR) splits the history at each deposit or withdrawal, measures the return of each sub-period, and links them geometrically: (1 + r1)(1 + r2)...(1 + rn) − 1. Averaging the sub-period returns would be wrong: +50% followed by −50% is a 25% loss, not zero. Because each sub-period is measured on its own, the size and timing of your deposits drop out, which is why the GIPS standards use TWR as the default measure for comparing fund managers.

For a single holding the price per share is the valuation, so each sub-period return is simply the price at the next transaction divided by the price at this one, minus one. The tool takes the price from Price per Share or derives it as amount / shares, and the final price is today's value divided by the shares you still hold.

Money-weighted return (MWR) is the internal rate of return of your actual cash flows: the annual rate at which buys, sells and today's value have a net present value of zero, using actual days / 365 like spreadsheet XIRR. It reflects your timing. If MWR is well below TWR, your deposits arrived before poor periods; if it is above, you added money before good ones.

Common use cases

  • Judging a fund, not your timing

    Use TWR to compare a fund with its benchmark when your own deposits were irregular.

  • Measuring your own results

    Use XIRR to see the annual return your actual money earned, including the effect of when you bought and sold.

  • Checking a SIP

    Log monthly instalments with units allotted to see both the fund's return and your rupee-cost result.

  • Reviewing a broker statement

    Re-enter trades from a statement to verify the XIRR the platform reports.

Tips and limitations

  • TWR is only meaningful here for a single security or fund. A mixed portfolio needs a full valuation at every cash flow, which share prices of one holding cannot give.
  • Cash dividends are not modelled, so both returns understate a holding that pays them out. Accumulating (growth) share classes avoid the problem because income stays in the price.
  • XIRR over periods shorter than a year is annualized and can look extreme; a 5% gain in two months annualizes to over 30%.
  • Data stays in this browser's localStorage. Clearing site data or switching browsers starts you from empty.
  • These figures describe past performance for your own analysis. They are not advice and say nothing reliable about future returns.

Sources and further reading

  1. GIPS Standards for Firms, CFA Institute. The performance standards that use time-weighted return
  2. 2020 GIPS Standards for Firms, CFA Institute. The full text, including when money-weighted return is allowed
  3. XIRR function, Microsoft Support. The actual-days / 365 IRR convention the money-weighted figure follows

Frequently asked questions

What is the difference between time-weighted and money-weighted return?

Time-weighted return measures the investment itself and removes the effect of when you added or withdrew money. Money-weighted return (XIRR) measures your actual money, so it rewards or penalises your timing. Fund managers report TWR; your own portfolio result is closer to MWR.

How do you calculate time-weighted return?

Split the period at every cash flow, compute each sub-period return as ending value divided by starting value minus one, then multiply (1 + r) across the sub-periods and subtract one. For one holding, each sub-period return is just the ratio of share prices, which is how this tool computes it.

Why does the calculator show n/a for time-weighted return?

Because at least one transaction has no share count, so there is no price for that date and the sub-period cannot be measured. Add the number of shares or units to every transaction; the price is then taken from Price per Share or worked out as amount divided by shares.

Is XIRR the same as CAGR?

Only when there is a single deposit and no withdrawals. CAGR assumes one starting amount growing to one ending value. XIRR handles many dated cash flows in both directions and finds the single annual rate that makes them balance, so it is the right measure for SIPs and irregular investing.

Why is my XIRR much lower than the fund's reported return?

Usually because you invested more just before a fall or less before a rise. The fund's reported return is time-weighted and ignores your cash flows. A large gap between the two is a measure of how much your timing cost or earned you.

Where are my transactions stored?

In your browser's localStorage under keys for this calculator. They are never sent to a server, they persist across reloads on the same device and browser, and Clear All Data & Start Fresh deletes them.

Is there an in-depth guide to the Time-Weighted Return Calculator?

Yes. “Time-Weighted vs Money-Weighted Return (TWR vs XIRR)” covers the background, how it works, common pitfalls and worked examples. Read the full guide.