Google Sheets · 100% free

Free Options Trading Journal for Google Sheets

Copy our Google Sheets trading journal and tailor it for calls, puts, spreads, and premium—one row per trade or per spread with fees and setup tags baked into the 2019 v2 dashboard.

No signup · Same 2019 v2 sheet · 15+ metrics

Key takeaway

TradeJournal.co's free options trading journal Google Sheets template lets you copy the 2019 v2 sheet in one click, log premium and setup tags, and review expectancy by strategy. For automatic options broker import and AI analytics, use TradeJournal.co (14-day free trial and a free $300 pro trader onboarding call).

Options journal — Google Sheets

Sheet copy links live on our main Google Sheets trading journal template page.

Copy the Google Sheets on our template page

The 2019 v2 sheet (plus 2018 and example portfolio) is on one page—make a copy in Google Sheets or export to Excel. Customize it for options using the tips below.

Google Sheets trading journal template

No signup · File → Make a copy · optional auto-import

What to track in your options trading journal

Options P&L is easy to misread if you only log premium—capture structure and risk so reviews match what you actually traded.

Strategy type

Single leg, vertical, iron condor, 0DTE scalp—tag structure so win rate is meaningful.

Premium & fees

Log credit/debit and commissions; net P&L belongs in the fees column for honest stats.

Underlying & DTE

Note ticker, expiration, and days to expiration in Notes or custom columns.

Max risk & R

Define risk per trade so position size does not distort your expectancy math.

Customize the sheet for options in minutes

  • Rename Setup to your strategies (0DTE, earnings play, credit spread).
  • Use Notes for strikes, width, and assignment risk on each row.
  • Track fees on every fill—options commissions add up on active weeks.
  • Weekly: use the Performance dashboard to drop structures with negative expectancy.

Rated 5 stars on TrustPilot

Join 12,000+ traders who journal with TradeJournal.

See all reviews
TrustPilot review from Lance
TrustPilot review from Matt
TrustPilot review from Nate

FAQ

Yes. Treat each closed spread as one journal row with net premium in P&L fields, or log each leg on its own row if you prefer leg-level stats—stay consistent week to week.

The template focuses on P&L, win rate, and setup analytics—not live Greeks. Record delta or IV context in Notes if it drives your decisions.

This page is the free Google Sheets copy. Our options trading journal article compares software features and broker import—both link back to the same pillar template for the spreadsheet.

Make a Google copy first, then File → Download → Microsoft Excel (.xlsx).

Start journaling options trades today

Copy the Google Sheet free—or automate reviews with TradeJournal.co when manual entry slows you down.