FREE · EXCEL, GOOGLE SHEETS AND PDF

Free trading journals

A Futures Trading Journal and an Options Trading Journal. Each has a trade log with dropdowns and formulas, a dashboard with charts, a weekly review, a rules checklist and a printable PDF. Educational templates, not advice.

Futures Trading Journal

For ES, MES, NQ, MNQ, CL, GC and friends. Dollars, points and R in one log.

  • Setup (playbook), session, direction, contracts
  • Entry, stop, target, exit, fees, so R-multiple and P&L calculate themselves
  • MAE and MFE in points and in R, and how much of the move you captured
  • Rules followed (yes/no) and a 0-4 process score
  • Mistake tag, emotion before and after, screenshot link
  • Dashboard: expectancy, profit factor, drawdown, equity curve, results by setup, session, weekday, mistake and emotion

Options Trading Journal

One row per position, whether it is a single option or a multi-leg spread.

  • Strategy, thesis, legs, debit or credit, contracts, width
  • DTE, IV rank, net delta, theta and vega at entry
  • Max risk and max reward calculated for you; R-multiple and % of max profit captured
  • Exit reason, adjusted or rolled, assigned, fees
  • Rules followed, mistake tag, emotion, screenshot link
  • Dashboard: results by strategy, DTE bucket, IV-rank bucket, thesis and exit reason, with charts

How to use them

  1. 1
    Set up

    Open the Setup sheet. Enter your account size, risk per trade (for example 1%) and daily loss limit. Check the contract table or the strategy list and rename the playbook to the setups you actually trade.

  2. 2
    Log every trade

    One row per trade (options: one row per position). White cells are yours; grey cells are formulas. Log within five minutes of closing, while you remember what you felt.

  3. 3
    Score yourself

    Answer the four process checks and tag one mistake. A good process can lose money; the journal is there to protect the process.

  4. 4
    Read the dashboard weekly

    Look at expectancy in R, drawdown, rules followed, and which setups, sessions or DTE buckets pay for you. Treat fewer than 30 trades as noise.

  5. 5
    Write one rule

    On the Weekly Review sheet write what to repeat, what to fix and one rule for next week. Then tick the Rules Checklist each day.

To open the Excel file in Google Sheets: upload it to Google Drive, right-click, then Open with Google Sheets. Dropdowns and formulas carry over; the chart styling may differ slightly.

Why these columns

We studied what the popular journals track (TradeZella, Tradervue, Edgewonk, TraderSync, TradesViz and free spreadsheet journals) and kept the fields that change decisions: setup tags, R-multiple, MAE and MFE, rule adherence, session, mistake and emotion tags, and for options strategy, legs, DTE, IV rank, Greeks at entry, max risk and reward, adjustments and assignment. A spreadsheet will not import your broker fills; if you want that, paid journal apps do it.

Want to learn what the numbers mean? Read the free supplement on Psychology & Risk Management, then browse the free library.

Educational only. Not financial advice. Trading futures and options involves substantial risk of loss. A journal records your results; it does not predict them.