Back to: The Mastermind Vault
Points-First Backtest — Built for Testing Ideas, Not Just Logging Trades
Information
Description
Traders who want a clean, practical way to backtest and iterate: compare variants, test management rules (scale-in/out), and validate whether improvements actually move expectancy and drawdown — without overcomplicated spreadsheets.
Includes:
Trade log with Entry / Exit / High / Low / L/S
Auto metrics: P/L, Max Pain, Max Gain, NET results
A structure that’s easy to extend (position sizing, partial exits, and grouped trade evaluation)
Objectives
This Excel backtest template is designed to help you answer the only questions that matter in a backtest: does the idea work, and how can it be improved? It’s a simple, beginner-friendly sheet that calculates results in points (net of costs) so you can evaluate the edge first, then apply sizing models later.
What it does automatically:
Long/Short-aware P/L from Entry and Exit (no manual sign fixing)
High/Low tracking to calculate:
Optional TP block (e.g., 350 / 750 / 1250 / 2000) with a clean NET result that avoids errors from hidden columns.
Supports multiple entries / pyramiding / scale-out using a simple trade number / grouping approach