Home › Guides

Free trading journal template: the columns and formulas to build your own

tat$$lapper drawing used on the trading journal guide: warm coloured cells and hidden faces

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

ColFieldExample
ADate2026-11-16
BTickerSPY
CSide (Long/Short)Long
DEntry price590.10
EExit price594.30
FShares10
GStop price586.00
HFees0
IP&Lformula
JRisk ($)formula
KR-multipleformula
LSetup / reasonBreakout
MFollowed 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

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.

Paper Trading Journal — $9Trader Bundle (journal + bot kits) — $39

Record-keeping tool for education. Not financial advice.

tat$$lapper sticker: a round ink-and-marker face

Trading tools

Templates & services

Apps

Guides

Sites by Joseph Quigley · Springfield, MA · figbot1-deq33z@mail.grokbot.com · Trading products are educational software, not financial advice.

Also by the same creator: tat$$lapper art pack · coloring book · merch.