A trading journal template needs to capture three things for every trade: what you planned before you got in (setup, entry, stop, target, size), what actually happened (the exit and the result in R), and whether you stuck to your own rules. The rest is optional. The template on this page has 21 columns, takes about a minute per trade, and works the same in Excel and Google Sheets. Copy it below, no email needed.
Copy the trading journal template
Open a blank sheet, click cell A1 and paste the header row. The columns are separated by tabs, so Excel and Google Sheets drop each one into its own cell. Then click M2 and paste the formula row: it fills Risk, P&L, R and Planned R, and you drag those four cells down as far as you like.
Date Time Market Side Setup Timeframe Entry Stop Target Exit Size (units) Fees Risk P&L R Planned R Followed plan (Y/N) Mistake Grade (A/B/C) Chart link Notes
Columns A to U. The formulas below assume this exact order.
=ABS(G2-H2)*K2 =IF(J2="","",IF(D2="Short",G2-J2,J2-G2)*K2-L2) =IF(OR(N2="",M2=0),"",N2/M2) =IF(G2=H2,"",ABS(I2-G2)/ABS(G2-H2))
Risk is the distance to your stop times size. P&L is blank until you enter an exit. R is P&L divided by Risk.
What each column is for
| Column | What you write | Why it's there |
|---|---|---|
| Setup | One word from a fixed list: Pullback, Breakout, Reversal, Unplanned | This is the column you'll sort by on Sunday. Free text here ruins the totals. |
| Entry, Stop, Target | Prices you decided on before the order went in | Without a stop you can't work out R, and without R you can't compare trades of different sizes. |
| Size (units) | Shares, units or ounces | Lets the sheet check that each trade risked roughly what you meant it to. |
| Exit | Your actual fill | Compared with Target, it shows whether you cut winners short. |
| R | Calculated | Profit or loss in units of risk. Risk $100, make $180, that's +1.8R. |
| Planned R | Calculated | Target distance divided by stop distance, the reward to risk you signed up for. |
| Followed plan | Y or N, honestly | Splits bad luck from bad behaviour. |
| Mistake | A tag from a short list: moved stop, early exit, chased entry, oversized, revenge | A fixed list means you can count them with one formula. |
| Grade | A, B or C for the decision, not the result | A losing trade taken by the rules is still an A. |
| Chart link | A link to a screenshot taken at entry | Memory rewrites trades. A picture doesn't. |
The grade column is the easiest one to skip, and it's the one we'd keep if we had to delete everything else. Outcome and decision are different things. A stop-out on a setup you took exactly as planned is a normal cost of trading. A winner you got by moving your stop twice is a habit that will eventually cost you a large loss. If you only look at P&L, the second trade looks better than the first.
Setup names should describe something you can see on the chart. "Pullback to the 20 EMA" or "bull flag breakout" works. "Good feeling" doesn't.
A filled-in example week (made up)
Here is the template in use. Every number is invented to show the arithmetic, not taken from a real account. The trader has a $10,000 account, risks 1% ($100) on each trade with a position size worked out from the stop, and fees are left at zero to keep the sums readable. Ten trades, Monday to Friday.
| Day | Trade | Setup | Entry | Stop | Exit | P&L | R | Followed plan |
|---|---|---|---|---|---|---|---|---|
| Mon | EUR/USD long | Pullback | 1.0850 | 1.0830 | 1.0886 | +$180 | +1.80R | Yes |
| Mon | GBP/USD short | Breakout | 1.2700 | 1.2725 | 1.2725 | -$100 | -1.00R | Yes |
| Tue | XAU/USD long | Breakout | 2400.0 | 2392.0 | 2416.0 | +$200 | +2.00R | Yes |
| Tue | EUR/USD short | Unplanned | 1.0872 | 1.0892 | 1.0899 | -$135 | -1.35R | No, moved stop |
| Wed | GBP/USD long | Pullback | 1.2660 | 1.2640 | 1.2692 | +$160 | +1.60R | Yes |
| Wed | XAU/USD short | Reversal | 2425.0 | 2433.0 | 2433.0 | -$100 | -1.00R | Yes |
| Thu | EUR/USD long | Breakout | 1.0905 | 1.0885 | 1.0899 | -$30 | -0.30R | No, early exit |
| Thu | EUR/USD long | Unplanned | 1.0898 | 1.0883 | 1.0880 | -$118.80 | -1.20R | No, revenge |
| Fri | GBP/USD long | Pullback | 1.2710 | 1.2690 | 1.2738 | +$140 | +1.40R | Yes |
| Fri | XAU/USD long | Breakout | 2441.0 | 2433.0 | 2436.0 | -$62.50 | -0.63R | Yes |
Invented trades for illustration only. Size was set so a full stop-out cost about $100: 50,000 units on a 20-pip EUR/USD stop, 12.5 ounces on an $8 gold stop. Size, target and grade columns are hidden here to fit the screen.
Source: Arithmetic on the made-up week above
What the journal shows that the P&L doesn't
The account statement for this week would say: up about $133, won 4 of 10. That's all. The journal says something more useful. The three pullback trades made +4.80R. The four breakouts roughly broke even. And two trades that were never on the plan, a short taken out of boredom on Tuesday and a revenge buy on Thursday, gave back 2.55R between them. Every trade marked N in the Plan column lost money, -2.85R in total.
Notice the win rate too. Forty percent sounds bad, and the week still finished positive, because the average winner was nearly twice the size of the average loser. That's the relationship the risk reward calculator shows you before a trade: at a planned 1:2, you break even winning about a third of the time, before costs.
Running total in R after each of the ten made-up trades, with and without the unplanned ones
| Label | All ten trades | Without the 2 unplanned trades |
|---|---|---|
| 1 | 1.8R | 1.8R |
| 2 | 0.8R | 0.8R |
| 3 | 2.8R | 2.8R |
| 4 | 1.4R | 2.8R |
| 5 | 3.0R | 4.4R |
| 6 | 2.0R | 3.4R |
| 7 | 1.8R | 3.1R |
| 8 | 0.6R | 3.1R |
| 9 | 1.9R | 4.5R |
| 10 | 1.3R | 3.9R |
Removing trades after the fact isn't a strategy. The point is to see what a habit costs so you can stop it next week.
Source: Arithmetic on the made-up week above
The review routine
- Each trade
Two minutes after the exit
Fill in Exit, check the R, mark Followed plan and the Mistake tag, give the grade, and paste the chart link. Do it before you look at the next chart, while you still remember why you got out.
- Daily
Five minutes at the close
Read the Notes column for the day. If you broke a rule twice, that's your only job for tomorrow: not breaking it a third time.
- Sunday
Thirty minutes with the summary
Paste the summary formulas below into an empty corner of the sheet. Look at total R by setup, count the mistake tags, and open the chart links for your biggest win and biggest loss. Write one rule change for next week, and only one.
- Monthly
Decide what to drop
A setup with a negative average R over a decent number of trades gets cut or traded smaller. A mistake tag that keeps showing up gets a hard rule, for example no trades for an hour after a full stop-out.
Closed trades =COUNT(O2:O1000) Win rate =COUNTIF(O2:O1000,">0")/COUNT(O2:O1000) Average R per trade =AVERAGE(O2:O1000) Total R =SUM(O2:O1000) Average win (R) =AVERAGEIF(O2:O1000,">0") Average loss (R) =AVERAGEIF(O2:O1000,"<0") Total R, Pullback setup =SUMIF(E2:E1000,"Pullback",O2:O1000) Trades that broke the plan =COUNTIF(Q2:Q1000,"N") R from broken-plan trades =SUMIF(Q2:Q1000,"N",O2:O1000)
Change "Pullback" to each of your setup names to get their totals. Format the win rate cell as a percentage.
Excel, Google Sheets or a journal app?
Excel and Google Sheets run this template identically. Sheets is easier if you log from your phone, and Excel is happier past a few thousand rows. Paid journal apps import fills from your broker, which removes the typing, and they add charts and filters. What none of them can do is fill in the Followed plan and Grade columns for you, and those two are where most of the value sits.
WolfGPT has a private Trade Journal inside the app, on a paid plan or the trial. You log the market, direction, entry, size and a note, close the trade with an exit price, and it works out the P&L and keeps a running win rate, net P&L and count of open and closed trades. It doesn't calculate R-multiples or group trades by setup, so if those columns matter to you, keep this sheet alongside it. If you run a chart read before a trade, save a screenshot of it and link that in the Chart link column: a month later you can check how the read compared with what actually happened.
| This sheet | WolfGPT journal | |
|---|---|---|
| P&L worked out for you | ✓ | ✓ |
| Running win rate | ✓ | ✓ |
| R-multiple per trade | ✓ | ✕ |
| Totals by setup | ✓ | ✕ |
| Plan, mistake and grade columns | ✓ | Notes field |
| Chart reads in the same place | ✕ | ✓ |
| Cost | Nothing | Paid plan or trial |
Checked against the WolfGPT app in November 2026.
Questions people ask
What should a trading journal include?
At minimum: date, market, direction, setup, entry, stop, exit and size, so you can work out the result in R. The columns that make it useful are the behavioural ones: whether you followed your plan, what mistake (if any) you made, and a screenshot of the chart at entry.
How do you calculate R-multiple in Excel?
Risk is the distance from entry to stop times the size, =ABS(G2-H2)*K2 in this template. R is the profit or loss divided by that risk, =N2/M2. A trade that risked $100 and made $250 is +2.5R; a full stop-out is -1R.
Is a forex trading journal different from a stock one?
Only in the units. Log forex size in units (0.10 lots is 10,000 units) and gold in ounces, so the P&L formula works. If your account currency differs from the quote currency, either convert the P&L or rely on R, which doesn't care about currency.
How many trades before a journal tells you anything?
Habits show up fast, often in the first week. Whether a setup has a positive average takes much longer, because short runs of wins or losses happen by chance. Judge setups over dozens of trades taken the same way, not over a good fortnight.
Should I log trades I didn't take?
Yes, in a separate tab. A missed setup that would have worked, or one you skipped and was right to skip, tells you about your rules as much as the trades you took. Use the same columns and leave Exit as the price where the plan would have closed.
Does WolfGPT have a trading journal?
Yes. The Trade Journal is part of the paid plan and the trial. It records trades, calculates P&L when you close them and shows your win rate and net P&L. It doesn't track R-multiples or setups, which is why we publish this template too.