Skip to content

Resource · Included with membership

A Backtesting Worksheet That Records Costs and Failed Setups

Record candidates, rejected setups, fill assumptions, costs, rule versions, and untouched evaluation data in an auditable backtesting worksheet.

Published

Test and holdout ledgers show retained and excluded rows separated by a locked chronological boundary.
Conceptual illustration: test and holdout ledgers show retained and excluded rows separated by a locked chronological boundary.
Image credit

Conceptual illustration: test and holdout ledgers show retained and excluded rows separated by a locked chronological boundary.

FavAcademy · Original commissioned AI illustration; public use authorized

Public summary

A backtest is a controlled historical experiment with execution assumptions. Build an original worksheet that records every candidate, costs, uncertain fills, and rule versions. Work a small invented net-result example and keep an untouched evaluation period from becoming another tuning sample.

Backtest Records and Exclusion Audit Workbook

Preserve frozen rule and dataset splits, calculate consistent net R outcomes and retain exclusions and missing costs.

Included with membership

  • Editable Backtest Records and Exclusion Audit Workbook (XLSX)· Editable workbook
  • Printable Backtest Records and Exclusion Audit Workbook (HTML)· Printable companion

The full guide is available to eligible members. Open member resource.

Risk disclosure

All returns, costs, and splits are invented learning examples. A backtest cannot guarantee live fills, tolerable losses, or future results.