Educational only, not financial advice. Futures trading involves substantial risk of loss and is not suitable for everyone. Examples are hypothetical and illustrate math only; they are not a record or promise of results.
The file includes three hypothetical example rows (labeled EXAMPLE ROW in the notes column). Delete them before use.
Columns
| Column | What to enter |
|---|---|
date | Trade date (YYYY-MM-DD) |
instrument | MNQ, NQ, MES, ES, etc. |
setup | Your named setup (e.g., ORB retest, 20 EMA pullback) |
direction | long / short |
entry, stop | Fill price and initial stop |
target | Planned target(s); separate scale-outs with "/" |
exit | Actual exit price(s); "/" for multiple |
contracts | Total contracts |
risk_usd | |entry − stop| × point value × contracts (1R) |
pnl_usd | Net P&L after fees (the hypothetical example rows assume zero fees) |
r_multiple | pnl_usd ÷ risk_usd |
mae | Max adverse excursion in points (worst move against you) |
mfe | Max favorable excursion in points (best move for you) |
rules_followed | yes / no / partial |
mistake_tags | Short tags separated by ";" (early-entry, moved-stop, revenge-trade, oversized, against-htf-trend, chased) |
notes | Context, emotions, screenshot link |
Workflow
- Before entry: fill date → target, contracts and risk_usd.
- After exit: fill exit, pnl_usd, r_multiple, mae, mfe.
- Same day: grade rules_followed and add mistake_tags honestly.
- Weekly: filter by setup and mistake_tags and compute expectancy with the R-multiple & expectancy calculator. Judge process first, P&L second, and treat small samples (under 30 trades) with caution.
Pair it with the pre-trade and post-trade checklists.
Educational only. Not financial advice (NFA).