The entire template is on this page. Copy the columns below into Excel or Google Sheets, log every trade with them, and run the weekly review at the bottom; that’s the whole system. No download wall, no email required, nothing held back.
A journal is the only honest feedback loop you have. Your broker statement tells you what you made; it doesn’t tell you that your gap-and-go entries print money while your midday fades quietly bleed it back. The journal does. Most day traders lose money, and a large share of them never find out exactly where, because they never wrote anything down.
The template
Fifteen columns. Ten record what happened; five record why. Each round-trip trade gets one row. If you scale out in pieces, give each exit its own row with the same entry data so the math stays clean.
| # | Column | What goes in it |
|---|---|---|
| 1 | Date | Trade date |
| 2 | Ticker | The symbol |
| 3 | Direction | Long or short |
| 4 | Setup | One tag from a fixed list you define (gap-and-go, breakout, VWAP reclaim, etc.) |
| 5 | Entry time | Exact time of the fill, not “around 9:45” |
| 6 | Entry price | Your actual average fill |
| 7 | Shares | Position size |
| 8 | Stop price | Where the trade was wrong, set before entry |
| 9 | Planned risk $ | Shares × (entry minus stop). This is 1R for the trade |
| 10 | Target price | Your planned exit when you entered |
| 11 | Exit time | When you got out |
| 12 | Exit price | Actual average exit fill |
| 13 | P&L $ | Net of commissions and fees |
| 14 | R-multiple | P&L ÷ planned risk $. The most important number on the row |
| 15 | Notes | Plan followed yes/no, your state of mind, one lesson. Two sentences max |
Three rules make these columns work:
Setup tags come from a fixed list, not free text. “Gap-and-go” and “gapper long” and “morning gap” are the same trade, but a spreadsheet can’t group them unless you spell them identically. Pick 4–6 setup names, write them down, and never improvise a new one mid-session. If you need setup ideas with defined entry criteria, the strategy library is built around exactly this kind of tagging.
The stop column is filled in before the entry, never after. A stop you decide on once you’re already losing isn’t a stop; it’s a negotiation. Your planned risk in column 9 is also the number your position size should come from. The position size calculator does that math: account size, risk percentage, entry, stop, out comes the share count.
Column 14 is why this template exists. Dollar P&L lies to you, because a $300 winner on triple size is a worse trade than a $150 winner at normal risk. The R-multiple normalizes every trade to the risk you planned: a trade that made twice what it risked is +2.0R whether you risked $50 or $500. Once every row speaks in R, your trades become comparable, and patterns appear. (R-multiples, RVOL, and the rest of the vocabulary are defined in the day trading glossary if any column label is unfamiliar.)
The daily row
Above your trade log, keep one short row per session with four cells: the date, your bias going in (“CPI at 8:30, expecting chop until 10”), your daily max loss, and whether you stopped trading when you hit it. The trades tell you about your setups. The daily row tells you about your discipline, which is usually the bigger leak.
How to use it: three steps
Step 1: set it up once. Open a blank sheet, paste the 15 column headers, and add two formulas. P&L: =(exit price - entry price) * shares for longs, reversed for shorts, minus fees. R-multiple: =P&L / planned risk $. Add a summary block at the top with the four formulas from the metrics section below. Ten minutes, done forever.
Step 2: log the numbers at the close of each trade, the words at the close of each day. Fills, times, and sizes go in immediately, while they’re exact. The notes column waits until after the close, when you’ve cooled off; the lesson you write at 4:15 pm is honest in a way the one written 40 seconds after a stop-out never is.
Step 3: review weekly, fifteen minutes, no exceptions. Sort by setup tag, sort by time of day, read the notes on your five worst trades. The exact questions to ask are in the weekly review section below. A journal that’s written but never read is a diary, and diaries don’t fix your win rate.
A worked entry
Here’s what a real row looks like. A $10,000 account risking 1% per trade has $100 of risk to spend. The trader is long a low-float gapper on a gap-and-go setup: entry $8.42, stop at $8.18 below the premarket pivot. Risk per share is $0.24, so $100 of risk buys 416 shares; round down to 400, which makes planned risk $96. The 2R target sits at $8.90.
The stock works, stalls at $8.88, and the trader sells into strength at $8.86 rather than hoping through the pullback.
| Date | Ticker | Dir | Setup | In | Entry | Shares | Stop | Risk $ | Target | Out | Exit | P&L $ | R | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 06/08/26 | ABCD | Long | Gap-and-go | 9:34 | 8.42 | 400 | 8.18 | 96 | 8.90 | 9:51 | 8.86 | +176 | +1.83 | Plan followed. Sold the stall instead of wishing. |
| 06/08/26 | WXYZ | Short | VWAP fade | 11:42 | 14.05 | 200 | 14.40 | 70 | 13.35 | 11:58 | 14.31 | -52 | -0.74 | Plan broken: bored, forced a midday entry in chop. Bailed before the stop. |
Two rows, and the story is already visible. The morning trade was the playbook executed. The midday trade was boredom wearing a setup’s name tag. Multiply by 20 trades and the spreadsheet will say it louder than any mentor.
The formulas: turning rows into a verdict
Once you have rows, four formulas grade them. Put these in the summary block at the top of the sheet.
Win rate = winning trades ÷ total trades. Useful, but overrated on its own; a 70% win rate with tiny winners and occasional giant losers still loses money.
Average winner and average loser, in R = mean R-multiple of the winning rows, mean R-multiple of the losing rows. This pair exposes whether you let winners work and cut losers, or the reverse.
Profit factor = gross R won ÷ gross R lost. Above 1.0 you’re profitable before slippage surprises; below 1.0 the strategy is paying the market for the privilege.
Expectancy = (win rate × average winner) − (loss rate × average loser). The expected R per trade, which is the single number that says whether your trading has an edge.
Here’s all four worked through a realistic 20-trade month. Nine winners averaging +1.6R, eleven losers averaging −0.9R (some cut early, like the WXYZ trade above):
- Win rate: 9 ÷ 20 = 45%
- Profit factor: (9 × 1.6) ÷ (11 × 0.9) = 14.4 ÷ 9.9 = 1.45
- Expectancy: (0.45 × 1.6) − (0.55 × 0.9) = 0.72 − 0.495 = +0.225R per trade
A 45% win rate sounds mediocre, and this trader is profitable: at $100 risked per trade, +0.225R is about $22 of expected value per trade, roughly $450 over the month before slippage. That’s the entire argument for journaling in R. Win rate alone called this trader a coin flip; expectancy shows the edge. Whether your planned reward justifies your risk on the next trade is the same arithmetic in reverse, and the risk-reward calculator runs it for you before you click buy.
Now sort those same 20 trades by setup tag and the picture sharpens further:
| Setup | Trades | Net R |
|---|---|---|
| Gap-and-go | 8 | +4.1R |
| Breakout | 5 | +1.6R |
| VWAP fade | 7 | -1.2R |
The whole month’s edge, +4.5R, came from two setups. The third one cost money in every week it was traded. No amount of screen time reveals that; thirty seconds with a sorted spreadsheet does.
The weekly review: three questions and a cut rule
Every weekend, same fifteen minutes, same three questions:
- Which setup tag made money, and which lost? Sort by column 4, sum column 14 per tag.
- When do I trade well? Sort by entry time. Most day traders’ results cluster in the first 90 minutes; if your 11:00–14:00 rows are a sea of red, the fix is free: stop trading those hours.
- What do my worst five trades have in common? Read their notes. The answer is usually one word: bored, spooked, revenge, FOMO. That word is your tell. When you feel it live, you now know what it costs.
One guard against overreacting: don’t cut a setup before you’ve logged at least 20 occurrences of it. Five trades of anything can lose; that’s variance, not verdict. At 20-plus trades a negative expectancy starts meaning something, and you can retire the setup with evidence instead of mood. The same threshold applies in reverse: don’t size up a “hot” setup off six trades either.
Who shouldn’t bother with a spreadsheet
Be honest about volume. If you’re taking 15–30 round trips a day, manually logging fills will eat 30–45 minutes daily and you will eventually stop doing it, which makes the whole exercise worthless. High-volume traders are better served by dedicated journal software that imports executions from a broker file automatically; the trading journal comparison ranks those options, free tiers included. Most brokers can export trade history as a CSV from the account or statements area, which also works as a halfway step: paste the fills into this template and hand-write only the notes column.
The spreadsheet is the right tool if you take one to five trades a day, you’re still in the sim, or you want to feel the numbers before paying for software. The act of typing each trade is itself part of the lesson early on.
And journal your simulator trades exactly like live ones, same columns, same review. Sim trading without a journal teaches button-clicking, not trading; the journal is the only part of practice that transfers.
FAQ
What should a trading journal include?
At minimum: date, ticker, direction, setup tag, entry and exit price and time, share size, stop price, planned risk, P&L net of fees, the R-multiple, and a one-line note on whether you followed your plan. That’s the 15-column structure on this page. Enough to find patterns, not so much that you quit filling it in by Thursday.
Is a free spreadsheet enough, or do I need journal software?
A spreadsheet is enough at one to five trades a day, and it’s the better teacher when you’re starting out because manual entry forces you to confront each trade. Past roughly ten trades a day, manual logging breaks down and software with automatic broker imports earns its subscription. The comparison of paid and free journal apps covers when each makes sense.
Should I journal simulated and paper trades?
Yes, with the identical template. In the sim there’s no pain of real losses to teach you anything, so the journal is the only feedback you get. If the habit isn’t built in practice, it won’t appear when money is on the line.
How many trades before the stats mean anything?
Treat 20 trades per setup as the floor before drawing conclusions, and 50–100 total trades before trusting your overall win rate and expectancy. Below that, you’re measuring luck. A trader who looks brilliant over 8 trades is just unaudited.
How often should I review the journal?
Log numbers as each trade closes, write notes after the market closes, and do a 15-minute review every weekend. Add a deeper monthly pass where you re-run expectancy and profit factor per setup and decide what gets cut or sized up. Daily logging is data collection; the weekend review is where the improvement actually happens.
Can I import my broker’s trade history into this template?
Generally yes. Most brokers offer a CSV export of executions in the account history or statements section. Paste the date, ticker, size, and fill prices into the matching columns, then add the setup tag, stop, and notes by hand. The hand-written part is the part that makes you better, so don’t skip it just because the numbers arrived automatically.