Wwolfgpt.app

WolfGPT / Trading guides

Trading journal

A trading journal template with the formulas already written

Paste the header row and four formulas into a blank sheet and you have a working trade log in about two minutes. Below it: a made-up week of ten trades, what that week reveals once it's logged, and the Sunday review that makes the log worth keeping.

By The WolfGPT teamUpdated November 7, 2026
Analyze a chartUpload a screenshot of any chart

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.

You touch the log three times1BeforeSetupTimeframeEntryStopTargetSizeChart link2AfterExitP&LRPlan kept?MistakeGrade3SundayR by setupMistakesBest setupWorst habitNext ruleA minute per trade, 30 minutes a week
It's tempting to fill in only the middle box. The first and last are where the useful information comes from.

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.

Header row (paste into A1)
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.

Formula row (paste into M2, then drag down)
=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

The columns that do the work
ColumnWhat you writeWhy it's there
SetupOne word from a fixed list: Pullback, Breakout, Reversal, UnplannedThis is the column you'll sort by on Sunday. Free text here ruins the totals.
Entry, Stop, TargetPrices you decided on before the order went inWithout a stop you can't work out R, and without R you can't compare trades of different sizes.
Size (units)Shares, units or ouncesLets the sheet check that each trade risked roughly what you meant it to.
ExitYour actual fillCompared with Target, it shows whether you cut winners short.
RCalculatedProfit or loss in units of risk. Risk $100, make $180, that's +1.8R.
Planned RCalculatedTarget distance divided by stop distance, the reward to risk you signed up for.
Followed planY or N, honestlySplits bad luck from bad behaviour.
MistakeA tag from a short list: moved stop, early exit, chased entry, oversized, revengeA fixed list means you can count them with one formula.
GradeA, B or C for the decision, not the resultA losing trade taken by the rules is still an A.
Chart linkA link to a screenshot taken at entryMemory 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.

Example log: one made-up week, ten trades
DayTradeSetupEntryStopExitP&LRFollowed plan
MonEUR/USD longPullback1.08501.08301.0886+$180+1.80RYes
MonGBP/USD shortBreakout1.27001.27251.2725-$100-1.00RYes
TueXAU/USD longBreakout2400.02392.02416.0+$200+2.00RYes
TueEUR/USD shortUnplanned1.08721.08921.0899-$135-1.35RNo, moved stop
WedGBP/USD longPullback1.26601.26401.2692+$160+1.60RYes
WedXAU/USD shortReversal2425.02433.02433.0-$100-1.00RYes
ThuEUR/USD longBreakout1.09051.08851.0899-$30-0.30RNo, early exit
ThuEUR/USD longUnplanned1.08981.08831.0880-$118.80-1.20RNo, revenge
FriGBP/USD longPullback1.27101.26901.2738+$140+1.40RYes
FriXAU/USD longBreakout2441.02433.02436.0-$62.50-0.63RYes

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.

40%Win rate4 winners from 10 trades
+1.33RNet result for the weekAbout $133 at $100 risk per trade
1.70RAverage winnervs an average loser of 0.91R
-2.55RLost on 2 unplanned tradesNeither was on the plan

Source: Arithmetic on the made-up week above

What the journal shows that the P&L doesn't

Total R by setup, made-up week-2-1+1+2+3+40Pullback3 trades+4.80RBreakout4 trades+0.08RReversal1 trade-1.00RUnplanned2 trades-2.55RR (profit or loss in units of risk)
Same ten made-up trades, grouped by the Setup column.

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.

Two unplanned trades cost about two thirds of the week

Running total in R after each of the ten made-up trades, with and without the unplanned ones

All ten tradesWithout the 2 unplanned trades
Two unplanned trades cost about two thirds of the week
LabelAll ten tradesWithout the 2 unplanned trades
11.8R1.8R
20.8R0.8R
32.8R2.8R
41.4R2.8R
53.0R4.4R
62.0R3.4R
71.8R3.1R
80.6R3.1R
91.9R4.5R
101.3R3.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

  1. 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.

  2. 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.

  3. 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.

  4. 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.

Summary formulas (paste into W1 of the same sheet)
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 template vs the WolfGPT Trade Journal
This sheetWolfGPT 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✕✓
CostNothingPaid 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.

Keep reading

WolfGPT is an AI chart analysis tool for education only. Nothing on this page is financial advice or a recommendation to buy or sell anything. Trading carries a high risk of loss, and past results do not predict future results. Read the full disclaimer.