Backtesting Spreadsheet, Excel Google Sheets Trading Strategy Tester, Backtest Journal, Expectancy, Win Rate, Prop Firm Simulator

What do your backtests really show once costs are taken out? The Backtesting Tracker measures your results and their uncertainty, with numbers.

Log your backtest trades (TradingView replay, FX Replay, Forex Tester or by hand): one row per trade, with prices or the R result directly. The file calculates everything and gives a careful statistical reading: what the sample shows, and what it cannot conclude yet.

━━━━━━━━━━━━━━━━━━
⭐ WHAT MAKES IT DIFFERENT
━━━━━━━━━━━━━━━━━━
• A statistical reading: net expectancy with its 95% confidence interval, win rate with its range, and an estimate of the trades still needed when the sample is not enough.
• Validation: set the date your rules were frozen; later trades are analysed separately to confirm (or not) the result.
• Cost sensitivity: expectancy if your costs rise 50% or double, and the cost that would cancel it.
• Everything after costs (spread, commission, slippage in R): you see what you really keep.
• Exit Lab: with MFE, the expectancy each target from 0.5 to 5 R would have given — a lead to test on new data, not a validated rule.
• Prop firm challenge simulator: 200 fixed scenarios drawn from your results (fixed risk as % of initial capital), share of scenarios that hit the target before the max loss (static or trailing), worst drawdown.
• No macros, no subscription, no connection: your data stays in your file.

━━━━━━━━━━━━━━━━━━
📊 WHAT YOU GET
━━━━━━━━━━━━━━━━━━
• Dashboard: verdict, net expectancy, profit factor, total R, worst drawdown, losing streak, automatic written analysis
• Compare 10 strategies or variants side by side, with R curve and chart
• Breakdown: results by side, session, weekday, quality, market context, criteria met and market
• Strategies: rules and a 5-criteria checklist, costs and planned risk
• A check on every row (stop on the wrong side, missing result, date order…)
• Guide with worked examples, 35-answer assistant, help on every column, 5 colour themes

━━━━━━━━━━━━━━━━━━
📦 IN THE DOWNLOAD
━━━━━━━━━━━━━━━━━━
• DEMO file (3 sample strategies, 226 trades)
• BLANK file (10 strategies, 2,000 trades)
• PDF Quick Start Guide (3 pages)
• Free corrective updates on request via Etsy Messages

━━━━━━━━━━━━━━━━━━
💻 COMPATIBILITY
━━━━━━━━━━━━━━━━━━
• Built for Excel 2013 and later (Windows and Mac) and Google Sheets (free, tested)
• Google Sheets does not keep the formula protection (everything else works)
• Not compatible with Apple Numbers

━━━━━━━━━━━━━━━━━━
⚡ HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. Download the ZIP after purchase (Account › Purchases and reviews)
2. Open the DEMO file to explore, then the BLANK file
3. Strategies: name the strategy, its costs in R and its criteria
4. Backtest Log: one row per tested trade, then read the verdict on the Dashboard

━━━━━━━━━━━━━━━━━━
ℹ GOOD TO KNOW
━━━━━━━━━━━━━━━━━━
• Digital product: nothing is shipped.
• No chart replay or market data: keep your replay tool, the file analyses your results.
• What it does and doesn't do is detailed in the “Scope” tab and on the matching photo.
• This is a digital download: digital downloads generally cannot be returned or cancelled on Etsy. File not delivered, damaged or not as described? Contact us through Etsy Messages so we can review the issue; Etsy's Purchase Protection and your statutory rights remain unaffected.
• Personal licence: use by the buyer only, no reselling or sharing.
• Educational tool: no investment advice. A backtest does not guarantee future results.
• Built by TrueLedger with the help of AI tools, then tested against an independent calculation on hundreds of cases.
• Prefer French? The French version is available in the shop.
• Strategy validated? Track it live with the TrueLedger Trading Journal. All four TrueLedger tools come together in the complete bundle: €44 instead of €61 for the tools bought separately.