A spreadsheet is the best place to start journaling. It's free, flexible, and forces you to decide what really matters. The problem is that most templates online either track too little (date, pair, P&L) or so much that you stop filling them in after a week. Here is the layout that works.
The 14 columns
- Date — the day you entered.
- Time — entry time, so you can find your best and worst hours.
- Session — Asia, London, New York, or overlap.
- Instrument — EURUSD, XAUUSD, NQ, AAPL.
- Direction — Long or Short.
- Setup tag — one short name per setup (e.g. "London breakout"). Keep the list under ten.
- Entry price
- Stop loss
- Take profit
- Position size — lots, contracts, or shares.
- Risk amount — what you lose if the stop is hit, in your account currency.
- Result amount — the actual profit or loss.
- R-multiple — result divided by risk (formula below).
- Notes — one sentence on why you took it and one on how you managed it.
The three formulas that matter
R-multiple: =L2/K2 (result ÷ risk). A +2R trade made twice what it risked.
Win rate per setup: =COUNTIFS(F:F,"London breakout",M:M,">0")/COUNTIF(F:F,"London breakout")
Expectancy per setup: =AVERAGEIF(F:F,"London breakout",M:M). This is the average R you earn per trade on that setup. Positive means you have an edge; negative means it's a leak.
Columns people add that you can skip
Emotion scores from 1–10, weather, "confidence level," and indicator readings rarely change a decision. If a column hasn't changed how you trade after 50 entries, delete it.
Where spreadsheets break down
- Screenshots. Pasting charts into cells is slow and bloats the file.
- Manual entry. After a busy day, you skip logging — and the trades you skip are usually the bad ones.
- Analysis. Breakdowns by session, day of week, and setup need pivot tables you have to rebuild.
That's the point where a dedicated journal pays off. Pro Journal Trader uses this same column layout, attaches your chart to each trade, syncs MT4/MT5 automatically, and builds the setup, session, and pair breakdowns for you. Start with the free trial and import your spreadsheet history.