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.
=(H2-F2)*D2*E2*IF(C2="Short",-1,1)-I2| 1 | Date | Symbol | Side | Qty | Mult. | Entry | Stop | Exit | Fees | Setup | Notes | Net P&L | Risk $ | R | Delete |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
You've logged 5 trades by hand.TradeReview can import them from your broker file and keep these stats for you.Try it free
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.
| Column | Filled in by | Why it's there |
|---|---|---|
| Date, Symbol, Market | You | Filter by period, instrument and asset class later. |
| Side | You (Long or Short) | Flips the P&L sign for shorts. |
| Qty, Multiplier | You | Multiplier makes one formula work for shares, futures, options and forex. |
| Entry, Stop, Target, Exit | You | Stop and target are what you planned before entering; that's what makes R honest. |
| Fees | You | Commissions, exchange fees and swap. Skipping them flatters every stat. |
| Setup, Mistake / tag, Notes | You | The part that turns a trade log into a journal. "By Setup" groups on this column. |
| Net P&L, Risk $, R-multiple, Planned R:R | Formula | Per-trade result in dollars and in units of risk. |
| Result, Cumulative P&L, Drawdown $ | Formula | Win/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)
| Stat | Formula | How to read it |
|---|---|---|
| Win rate | Wins ÷ closed trades | A win is net P&L above zero after fees. Break-evens count as non-wins. |
| Profit factor | Gross profit ÷ |gross loss| | Above 1.0 makes money. Around 1.5 or higher is solid. |
| Payoff ratio | Average win ÷ |average loss| | Read it together with win rate: a 35% win rate needs a payoff above roughly 1.9 just to break even. |
| Expectancy | Net P&L ÷ closed trades (also as average R) | What one more trade of this system is worth on average. |
| Max drawdown | Lowest 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
| Market | Qty | Multiplier | Example |
|---|---|---|---|
| Stocks & ETFs | Shares | 1 | 100 shares of AAPL |
| Crypto | Coins | 1 | 0.2 BTC |
| Futures | Contracts | Point value | ES = 50, MES = 5, NQ = 20, MNQ = 2, CL = 1,000 |
| Options | Contracts | 100 | Prices are the option premium, e.g. 2.35 |
| Forex | Lots | 100,000 | 0.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:
- Check completeness. Every closed trade logged, every trade has a stop. The Stats tab counts trades logged without a stop.
- Read expectancy in R, not dollars. Dollar results swing with position size; average R tells you whether the decisions were good.
- Open By Setup. Find the setup with negative average R over at least 20 trades. Stop trading it or change it.
- Sort by the Mistake column. Add up what each mistake cost. "Chased entry" costing 4R a month is a rule to write down.
- 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 template | Journal app (e.g. TradeReview) | |
|---|---|---|
| Cost | Free | Free plan; paid plans for file import and auto-sync |
| Getting trades in | You type every trade | Import broker file or auto-sync |
| Customising | Anything; it's your sheet | Within the app's fields, tags and strategies |
| Charts and screenshots | Paste links manually | Built in |
| Phone | Awkward on a small screen | Native apps |
| Best for | A few trades a week, full control | Active 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.