Home › Tools › Trade journal template

Free tool

Free trade journal template

A plain CSV file that opens in Excel, Google Sheets and Numbers. Nothing to sign up for.

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.

Download journal-template.csv

The file includes three hypothetical example rows (labeled EXAMPLE ROW in the notes column). Delete them before use.

Columns

ColumnWhat to enter
dateTrade date (YYYY-MM-DD)
instrumentMNQ, NQ, MES, ES, etc.
setupYour named setup (e.g., ORB retest, 20 EMA pullback)
directionlong / short
entry, stopFill price and initial stop
targetPlanned target(s); separate scale-outs with "/"
exitActual exit price(s); "/" for multiple
contractsTotal contracts
risk_usd|entry − stop| × point value × contracts (1R)
pnl_usdNet P&L after fees (the hypothetical example rows assume zero fees)
r_multiplepnl_usd ÷ risk_usd
maeMax adverse excursion in points (worst move against you)
mfeMax favorable excursion in points (best move for you)
rules_followedyes / no / partial
mistake_tagsShort tags separated by ";" (early-entry, moved-stop, revenge-trade, oversized, against-htf-trend, chased)
notesContext, emotions, screenshot link

Workflow

  1. Before entry: fill date → target, contracts and risk_usd.
  2. After exit: fill exit, pnl_usd, r_multiple, mae, mfe.
  3. Same day: grade rules_followed and add mistake_tags honestly.
  4. 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).