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 flow | Closing value before next flow |
|---|---|
| 100 | 110 |
| 210 | 189 |
| Result | Value |
|---|---|
| Return | -1% |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening value after flow (row 1) | 100 | 110 | Return | -1% | -10% |
| Closing value before next flow (row 1) | 110 | 121 | Return | -1% | 8.9% |
