Free template · Google Sheets

Free trading journal template for Google Sheets

Log your trades in one tab and read your results in the others: dashboard, analytics and a P&L calendar. Plain formulas, nothing to install or enable.

Free, no signup needed. Works in any browser. Using Excel on Windows? Get the Excel journal

SuperTrader Trading Journal · Dashboard
Dashboard tab of the free SuperTrader trading journal for Google Sheets
Inside the journal

Five tabs, already connected.

SuperTrader Trading Journal · Dashboard
Dashboard tab of the free SuperTrader trading journal for Google Sheets
SuperTrader Trading Journal · Journal
Journal tab of the free SuperTrader trading journal for Google Sheets
SuperTrader Trading Journal · Analytics
Analytics tab of the free SuperTrader trading journal for Google Sheets
SuperTrader Trading Journal · Calendar
Calendar tab of the free SuperTrader trading journal for Google Sheets
SuperTrader Trading Journal · Settings
Settings tab of the free SuperTrader trading journal for Google Sheets
What's inside

Everything you need to review a trade.

  • Every trade: open and close time, direction, size, prices, stop loss, take profit, costs, profit, risk-reward, strategy, session, psychology, two screenshot links and a note.
  • Deposits and withdrawals, kept separate from your trading results.
  • Wins, losses and breakeven trades, with a breakeven threshold you set.
  • Any period, with the From and To dates on the Dashboard.
  • Any market. You enter the result of each trade, so it works for forex, stocks, futures, options and crypto.
  • Up to 1,000 trades per copy.

Your own copy in three steps.

  1. 1
    Open the template
    Click Get the free Google Sheet. It opens in a new tab, no signup needed.
  2. 2
    Make a copy
    Choose Make a copy. The journal is saved to your own Google Drive.
  3. 3
    Make it yours
    Enter your starting balance and your lists in Settings, then replace the example row in the Journal with your first trade.

What you need

  • A Google account. The journal works in Chrome, Safari, Edge and Firefox on any computer, and in the Google Sheets app on a phone or tablet. The charts are easier to read on a larger screen.
  • There are no macros, scripts or add-ons, so Google never asks you to approve anything.
  • Using Excel on Windows? The Excel journal adds a form for logging trades and app-style screens. Get the Excel journal
Spreadsheet vs. app

When typing every trade starts to cost you time.

CompareGoogle Sheets journalSuperTrader
Logging a tradeTyped into a row, one at a timeUploaded from your broker's file, or synced automatically on Pro
P&LYou enter the resultCalculated from your fills
Works onAny browser, and the Google Sheets appWeb, iOS and Android
Charts and calendarBuilt in, update as you typeBuilt in, always current
AINoneMax AI chat about your trades; pattern agents on Pro and Elite
PriceFreeFree plan for up to 30 entries; paid plans for more
1-Click Import
Upload your broker's trade-history file and your trades import in seconds: Robinhood, IBKR, MT4, Tradovate, Schwab and 1,000+ more. The Free plan holds up to 30 entries.
AI that reads your trades
Ask Max, the AI chat, about your results in plain language. On Pro and Elite, agents such as Revenge Radar flag trades entered within 30 minutes of a loss.
Analytics without formulas
A dashboard and P&L calendar, calculated for you and always current. Basic analytics on the Free plan; per-strategy and per-symbol breakdowns on Pro.

Questions about the Google Sheets journal

Yes. Click Get the free Google Sheet and choose Make a copy. There is no signup, no card and no trial that ends.

Get the Google Sheets trading journal.

Free, no signup needed. Your copy is saved to your own Google Drive.

Free No signup No macros Your copy stays in your Drive