Backtesting & Replay9 min readFact-Checked & Verified
Structuring a Professional Backtesting Journal: Metrics That Actually Matter
Transform your backtesting logs from vanity spreadsheets into quantitative analytical engines. Discover the critical metrics institutional desks track beyond simple win rate.
SMA
Quantitative Research DeskInstitutional Strategy & Replay Specialist • Updated
Executive Summary & Key Takeaways
- Mathematical Edge: Risk must be predefined prior to entry; position size is an output of your invalidation distance, not an arbitrary input.
- Asymmetric Payoff: Target setups offering at least 1:2.5 R:R to ensure capital growth even with conservative win rates.
- Emotional Invalidation: Moving stop losses or revenge trading under drawdown mathematically guarantees ruin.
1. Summary & Key Takeaways
• Win rate is an incomplete metric; without average payoff, profit factor, and drawdown depth, win rate tells you nothing about profitability.
• A professional backtesting journal captures both quantitative data (prices, timestamps, R:R) and qualitative context (session, structure, emotional grade).
• Profit Factor (Gross Profits / Gross Losses) must exceed 1.50 to provide adequate buffer against real-world friction.
• Tracking Maximum Adverse Excursion (MAE) exposes whether your stop loss placement is excessively loose or dangerously tight.
• Systematic journaling turns subjective trading into an auditable quantitative business.
Institutional Desk Rule of Thumb
"Never permit a single trade to risk more than 1.0% to 1.5% of liquid portfolio equity. If your strategy encounters 6 consecutive losses, your capital remains at 94%, leaving you mathematically equipped to fully recover."
2. Core Theoretical Explanation: The Anatomy of Trading Data
Amateur traders measure success by a single number: "Did I make money today?" Institutional quant funds analyze multi-dimensional performance attributes to detect structural edge decay before capital is lost.
Key Metrics Defined:
1. Profit Factor ($PF$):
$$PF = \frac{\sum \text{Gross Profits}}{\sum \text{Gross Losses}}$$
A $PF$ below 1.20 is fragile; 1.50–2.00 represents institutional baseline; $>2.50$ is exceptional.
2. Maximum Adverse Excursion (MAE):
Measures the deepest point of drawdown experienced during a winning trade before reaching target. If 80% of your winning trades never dip more than 0.4R into drawdown, your current 1.0R stop loss is needlessly wide, diluting your position sizing.
3. Maximum Favorable Excursion (MFE):
Measures the maximum potential profit reached before the trade was closed. Comparing your actual exit against MFE reveals whether you are consistently leaving multiple R on the table due to premature exits.
Interactive Math Laboratory
Model the formulas from this guide in real timeCash at Risk$100.00
Exact Position Units40.00 Units
3. Step-by-Step Backtesting Procedure & Practical Checklist
The Essential 12-Column Journal Architecture:
Record these exact 12 data points for every single backtested setup:
1. Trade Number (#1 to #100)
2. Asset & Timeframe (e.g., BTC/USDT 15m)
3. Date & Session Killzone (e.g., 2024-04-12, London Open 02:30 EST)
4. Setup Model (e.g., Turtle Soup Liquidity Sweep into 15m Bullish OB)
5. Direction (Long / Short)
6. Entry Price, Invalidation Price (SL), Target Price (TP)
7. Planned Risk-to-Reward Ratio ($R_{planned}$)
8. Trade Outcome (Win / Loss / Break-Even)
9. Realized Payoff in R-Multiples ($R_{realized}$)
10. MAE in R (How far did price go against you?)
11. MFE in R (How far did price go in your favor?)
12. Trade Notes & Chart Link (Before & After screenshot URLs)
Advertisement
Google AdSense Placement ZoneSlot ID: 7382910482 • Responsive Display Unit (Compliant Placement)
4. Common Mistakes & Institutional Best Practices
Common Mistakes:
• Logging Only Winners: Neglecting to record the painful stop-outs, destroying the statistical validity of the journal.
• Tracking Dollars Instead of R: Tracking +$450 vs -$200 masks position sizing inconsistencies. Standardize everything into R-units.
Institutional Best Practices:
• Weekly Journal Review: Group trades by session (London vs. New York vs. Asian) to identify your highest-performing time windows.
• Equity Curve Visualization: Plot cumulative R over trade count to verify that account growth is steady rather than dependent on lucky single-trade spikes.
5. Actionable Takeaways & Primary Metrics to Track
Primary Metric to Track: Profit Factor ($PF$) & System Sharpe Proxy ($S_p$)
$$S_p = \frac{\text{Average R per Trade}}{\text{Standard Deviation of R}}$$
Goal: Target a Profit Factor $>1.60$ and an $S_p > 0.30$. If your metrics hit these benchmarks across 100 trades, your setup is statistically prepared for forward capital deployment.
Dedicated Quantitative Utility
Strategy Simulator & Journal
Execute the mathematical models detailed in this guide inside our standalone interactive calculator.
Next Guide in Backtesting & Replay Series9 min read
Defining Systematic Rules: Setting Invalidation Criteria Before Replaying
Learn how to establish zero-ambiguity invalidation criteria before advancing historical candles. Discover why objective structural stops preserve edge and prevent emotional mid-trade adjustments.