A clean spreadsheet trade journal separates variance vs. execution errors by pairing objective pre-trade risk/plan fields with standardized post-trade tags and simple formula-driven summaries. If a trade breaks a rule, it gets flagged immediately—so you can filter out process mistakes and see whether your underlying setup and ATR/risk sizing actually have positive expectancy.

1. Core Columns for a Clean Trade Log
Keep one row per closed trade and group columns in logical left-to-right order so you can use standard Excel/Sheets formulas (SUMIFS, COUNTIFS, AVERAGEIFS) without clutter:

2. Standardized Tags for Variance vs. Execution Errors
Use dropdown data validation (Data > Data Validation > List) on your tag columns so spelling never drifts and summary formulas stay accurate:
Rule_Compliance (Binary Gate):
Pass — Setup, stop placement, sizing cap, and cool-off rules were followed.
Breach — Any rule was broken (even if the trade ended up green).
Outcome_Type (Primary Bucket):
Normal_Variance — Rules were followed cleanly, stop was hit or setup failed to follow through.
Execution_Error — A rule, sizing cap, order/stop habit, or emotional guardrail was violated.
Regime_Mismatch — Rules were followed, but setups are repeatedly failing in current volatility/trend conditions.
Error_Tag (Specific Mistake Label — use "None" when Pass):
FOMO_Early_Entry — Entered before confirmation or chased an extended candle.
Oversized_Position — Exceeded allowed dollar risk or let leverage dictate size.
Stop_Moved_Or_Skipped — Widened stop mid-trade, removed stop, or exited late on emotion.
Revenge_Or_Tilt — Traded out of frustration, after a loss, or during a cool-off window.
Correlated_Stacking — Stacked overlapping exposure across correlated markets/trades.
Bad_Fill_Or_Slippage — Entered/exited poorly around news spikes or thin liquidity without accounting for spread/slippage.
3. Essential Summary Metrics & Sheet Layout Tips
Keep a Summary / Dashboard block (or second tab) driven by formulas so you never hand-count stats:
Variance vs. Breach Split: Count how many trades are Pass vs. Breach, and compare average Realized_R on Pass trades against Breach trades—breaches often drag down averages sharply.
Loss Breakdown by Bucket: Track total $ and count of losses under Normal_Variance, Execution_Error, and Regime_Mismatch so you know whether to fix execution habits, adjust regime filters, or simply accept normal variance.
Layout Hygiene: Put one table per sheet (avoid side-by-side summary tables next to your trade rows), freeze the header row, format dates and currency consistently, and set page setup to Landscape, Fit to 1 Page Wide if you export or print clean review sheets. (This is trade-journaling methodology, not financial advice.)