Free trade journal template

A spreadsheet with one row per trade that works out your net P&L, R-multiple, win rate, profit factor, expectancy and drawdown as you type. Download it, or start logging below.

Free, no email needed. Opens in Excel, Google Sheets, LibreOffice and Numbers. The PDF is A4; here is the US Letter version.

trade-journal-template
L2=(H2-F2)*D2*E2*IF(C2="Short",-1,1)-I2
1DateSymbolSideQtyMult.EntryStopExitFeesSetupNotesNet P&LRisk $RDelete
Equity curve

What's in the template

The Excel file has four tabs: Trade Log (one row per trade, 1,000 rows ready), Stats, By Setup and Monthly (with a P&L chart). It ships with 8 example trades across stocks, futures, forex and crypto so you can see every formula working; clear rows 2 to 9 and start logging.

ColumnFilled in byWhy it's there
Date, Symbol, MarketYouFilter by period, instrument and asset class later.
SideYou (Long or Short)Flips the P&L sign for shorts.
Qty, MultiplierYouMultiplier makes one formula work for shares, futures, options and forex.
Entry, Stop, Target, ExitYouStop and target are what you planned before entering; that's what makes R honest.
FeesYouCommissions, exchange fees and swap. Skipping them flatters every stat.
Setup, Mistake / tag, NotesYouThe part that turns a trade log into a journal. "By Setup" groups on this column.
Net P&L, Risk $, R-multiple, Planned R:RFormulaPer-trade result in dollars and in units of risk.
Result, Cumulative P&L, Drawdown $FormulaWin/loss label, running equity, and distance below the last peak.

Using it in Google Sheets

Download the .xlsx, upload it to Google Drive, then right-click it and choose Open with → Google Sheets (then File → Save as Google Sheets to keep a native copy). Every formula uses functions that exist in both Excel and Sheets, so nothing breaks.

The formulas

These are the exact formulas in the template, written in plain terms. If you build your own sheet, copy them.

Net P&L     = (Exit − Entry) × Qty × Multiplier × (−1 if Short) − Fees
Risk $      = |Entry − Stop| × Qty × Multiplier
R-multiple  = Net P&L ÷ Risk $
Planned R:R = |Target − Entry| ÷ |Entry − Stop|

In Excel or Google Sheets, row 2 of the log looks like this:

Net P&L (O2): =IF(OR(G2="",J2=""),"",(J2-G2)*E2*IF(F2="",1,F2)*IF(D2="Short",-1,1)-N(K2))
Risk $  (P2): =IF(OR(G2="",H2=""),"",ABS(G2-H2)*E2*IF(F2="",1,F2))
R       (Q2): =IF(OR(O2="",P2="",P2=0),"",O2/P2)
StatFormulaHow to read it
Win rateWins ÷ closed tradesA win is net P&L above zero after fees. Break-evens count as non-wins.
Profit factorGross profit ÷ |gross loss|Above 1.0 makes money. Around 1.5 or higher is solid.
Payoff ratioAverage win ÷ |average loss|Read it together with win rate: a 35% win rate needs a payoff above roughly 1.9 just to break even.
ExpectancyNet P&L ÷ closed trades (also as average R)What one more trade of this system is worth on average.
Max drawdownLowest value of (cumulative P&L − previous peak)The worst run you had to sit through.

Worked example

Long 100 AAPL, entry 227.40, stop 225.90, exit 230.10, fees $2.00.
Net P&L = (230.10 − 227.40) × 100 − 2.00 = $268.00. Risk = 1.50 × 100 = $150. R = 268 ÷ 150 = +1.79R.

Short 1 ES future (multiplier 50), entry 5,790, stop 5,796, stopped out at 5,796, fees $4.50.
Net P&L = (5,796 − 5,790) × 1 × 50 × (−1) − 4.50 = −$304.50. Risk = 6 × 50 = $300. R = −1.02R (a full stop plus fees).

Settings for your market

MarketQtyMultiplierExample
Stocks & ETFsShares1100 shares of AAPL
CryptoCoins10.2 BTC
FuturesContractsPoint valueES = 50, MES = 5, NQ = 20, MNQ = 2, CL = 1,000
OptionsContracts100Prices are the option premium, e.g. 2.35
ForexLots100,0000.5 lots EURUSD; P&L comes out in the quote currency (USD for EURUSD)

Check your broker's contract specifications. Point values above are for CME contracts.

How to review your trade journal

Logging is half the job. Once a week, spend 20 minutes on this:

  1. Check completeness. Every closed trade logged, every trade has a stop. The Stats tab counts trades logged without a stop.
  2. Read expectancy in R, not dollars. Dollar results swing with position size; average R tells you whether the decisions were good.
  3. Open By Setup. Find the setup with negative average R over at least 20 trades. Stop trading it or change it.
  4. Sort by the Mistake column. Add up what each mistake cost. "Chased entry" costing 4R a month is a rule to write down.
  5. Write one change for next week. One, not five. The printable PDF has a weekly review page for this.

Template or trading journal app?

This templateJournal app (e.g. TradeReview)
CostFreeFree plan; paid plans for file import and auto-sync
Getting trades inYou type every tradeImport broker file or auto-sync
CustomisingAnything; it's your sheetWithin the app's fields, tags and strategies
Charts and screenshotsPaste links manuallyBuilt in
PhoneAwkward on a small screenNative apps
Best forA few trades a week, full controlActive traders, several accounts, partial fills

Start with the template. If you notice you're skipping entries, that's the signal to switch.

Questions

What should a trade journal template include?

At minimum: date, symbol, long or short, size, entry, stop, exit, fees and the setup you traded. From those, the template calculates net P&L, risk in dollars, the R-multiple, and running totals such as win rate, profit factor, expectancy and drawdown. A notes or mistake column is what turns a trade log into a journal.

Does this template work in Google Sheets?

Yes. Every formula uses functions that exist in both Excel and Google Sheets (SUMIF, COUNTIF, SUMPRODUCT, EDATE). Upload the .xlsx to Google Drive and open it with Google Sheets.

How do I calculate P&L for a short trade?

Net P&L for a short is (Entry − Exit) × Quantity × Multiplier − Fees. The template does this automatically when Side is set to Short.

What is an R-multiple?

Net P&L divided by the amount you planned to risk (|Entry − Stop| × Quantity × Multiplier). A trade that made twice what it risked is +2R; a full stop-out is −1R plus fees.

How is win rate calculated here?

Winning trades divided by all closed trades. A win is any trade with net P&L above zero after fees; break-even trades count as non-wins, which is the stricter of the common definitions.

Should I log partial exits as separate trades?

In this template, log one row per entry with your average exit price and total fees. If you scale in and out a lot, a journal app that imports fills from your broker will be more accurate.

Is a spreadsheet or a trading journal app better?

A spreadsheet is free and fully customisable, and enough for a few trades a week. Once you trade often, run several accounts, or keep skipping entries because typing them takes too long, an app that imports trades from your broker keeps the record complete.