Time-weighted investment return · Calculation guide

Measure portfolio performance between external deposits and withdrawals.

Calculation guide

Use a valuation immediately before and after each external flow. Reinvested distributions stay in portfolio value. Returns are cumulative over all rows, without annualization.

TWR_pct = 100 × (product(end_i / start_i) − 1).

Inputs

Opening value after flow

Example entry 100 (in the selected currency). Minimum 5e-324.

Closing value before next flow

Example entry 110 (in the selected currency).

Worked example

Periods in chronological order

Opening value after flowClosing value before next flow
100110
210189
ResultValue
Return-1%

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening value after flow (row 1)100110Return-1%-10%
Closing value before next flow (row 1)110121Return-1%8.9%
Time-weighted investment return →

Sources