Reference files and checking protocol The initial figures are a fictional two-year example, not trading performance. Calculate returns for 2–24 equal periods with deposits at period ends. All amounts are in USD; no currency conversion. Withdrawals and irregular dates are outside this calculator. The optional machine header is period;value_before;contribution. Its identifiers stay unchanged in every language. Initial value and period length are entered separately. Use positive known values, up to 1,000,000,000 USD per amount, at most two decimal places. A decimal point or comma is accepted; do not use grouping separators. Zero account values are outside this positive-capital model. Maximum 16,000 characters. 1. Choose one account, one currency and one consistent valuation basis. Include the value of open positions if they belong to that account; a cash balance alone may not be its total value. 2. Record initial value at boundary 0, each equal-period-end value BEFORE the deposit, the deposit AFTER that valuation, and the final value. For this example choose one-year periods and initial value 100 USD. 3. Paste the reference input rows. The first year ends at 200 USD; deposit 120 USD afterwards, so the next opening value is 320 USD. The second year ends at 160 USD with no new deposit. 4. Check TWR: (200/100) × (160/320) − 1 = 0 over two years. The two period returns are +100% and −50%; do not add them. Annualized TWR is also 0%. 5. In a spreadsheet enter investor flows −100, −120, +160 in three consecutive cells. IRR of that range is −20% per yearly period. Check the residual: −100 − 120/0.8 + 160/(0.8×0.8) = 0. Preserve zero-flow cells in longer schedules. 6. Reconcile monetary loss: 160 − 100 − 120 = −60 USD. A 0% TWR does not mean that contributed money broke even. 7. Delete the middle valuation, leaving its deposit 120. MWR remains −20% a year; TWR is unavailable. If the middle value had been 100, the same cash flows would give TWR −27.272727…%. Do not fill a missing valuation with zero. 8. If a missing boundary has NO external deposit, adjacent intervals may be combined for total TWR. The missing individual-period return remains unknown. 9. Check cost treatment. A fee deducted inside account value is not an external contribution and must not be deducted twice. Record exclusions and adjustments separately. 10. For actual irregular dates, use a dated cash-flow method such as XIRR with its 365-day convention. This input schema is not a date parser. Withdrawals are outside this calculator; general signed-flow IRR can have multiple or no solutions. Displayed returns are rounded for reading. Calculations and CSV exports use the unrounded model values. CSV rates are decimal fractions, not percentages. Rate unit: decimal fraction (0.1 = 10%); decimal point; no grouping; unknown values blank GIPS Standards Handbook for Firms — https://www.gipsstandards.org/standards/gips-standards-for-firms/gips-standards-handbook-for-firms/ Microsoft IRR — https://support.microsoft.com/en-us/excel/functions/irr-function?nochrome=true Microsoft XIRR — https://support.microsoft.com/en-us/excel/functions/xirr-function?nochrome=true