Free trading journal template: the columns and formulas to build your own
A journal is the cheapest trading tool you'll ever use, and you can build one yourself in 15 minutes. Here's a complete layout with formulas you can paste into Excel or Google Sheets.
The columns
| Col | Field | Example |
|---|---|---|
| A | Date | 2026-11-16 |
| B | Ticker | SPY |
| C | Side (Long/Short) | Long |
| D | Entry price | 590.10 |
| E | Exit price | 594.30 |
| F | Shares | 10 |
| G | Stop price | 586.00 |
| H | Fees | 0 |
| I | P&L | formula |
| J | Risk ($) | formula |
| K | R-multiple | formula |
| L | Setup / reason | Breakout |
| M | Followed plan? (Y/N) | Y |
The formulas (row 2)
I2 =IF(C2="Long",(E2-D2)*F2,(D2-E2)*F2)-H2
J2 =ABS(D2-G2)*F2
K2 =IF(J2=0,"",I2/J2)
Fill them down. Then add a summary area:
Win rate =COUNTIF(I:I,">0")/COUNT(I:I)
Average win =AVERAGEIF(I:I,">0")
Average loss =AVERAGEIF(I:I,"<0")
Profit factor =SUMIF(I:I,">0")/ABS(SUMIF(I:I,"<0"))
Average R =AVERAGE(K:K)
Plan followed % =COUNTIF(M:M,"Y")/COUNTA(M2:M)
How to review it
- Weekly: sort by Setup and compare average R per setup.
- Look at trades where you didn't follow the plan. Most leaks show up there.
- Paper trade a new setup for at least 20–30 trades before judging it.
Want it done for you?
The Paper Trading Journal ($9) is this layout finished and polished: auto-calculating P&L, return %, risk and R, a summary sheet (win rate, average win/loss, profit factor, results by setup and by month), plan and emotion tracking, 500 rows with dropdowns, and Excel, Google Sheets and Notion versions.
Record-keeping tool for education. Not financial advice.
