Free trading journal template for Excel

A ready-to-use spreadsheet for logging your trades and reviewing your performance. Download it, fill in your trades, and the key numbers calculate themselves.

Free download · No sign-up required · Excel & Google Sheets

What's inside the template

The .xlsx download contains three sheets: Trade Journal, Summary and How to use. The journal includes three illustrative example trades and 100 rows with calculation formulas; the summary reads those 100 rows.

  • A trade log with date, symbol, direction, setup, entry, stop loss, take profit, size and exit
  • Automatic P&L, R multiple and risk % calculations
  • A summary sheet with win rate, profit factor and average R
  • A notes column for the lessons behind every trade
  • Example rows so you can see exactly how to fill it in
  • Works in Excel and Google Sheets — no macros, nothing to install

Every column, explained

A trading journal is only as useful as what you put in it. Here's what each column in the template is for — and what it can tell you after a few weeks of honest logging.

Date & symbol

When and what you traded. Grouping by symbol later shows which markets actually make you money — many traders discover their losses concentrate in one or two instruments.

Direction (long / short)

Lets you compare long vs. short performance. A common finding: a strategy that works on longs quietly loses on shorts, or the other way around.

Setup / strategy

A short label for the pattern you traded — 'breakout', 'pullback', 'news fade'. This is the column that turns a log into a journal: it lets you measure each setup separately instead of judging your trading as one blur.

Entry price

The price you actually got filled at, not the price you planned. Comparing planned vs. actual entries over time reveals slippage and hesitation.

Stop loss

The price where your idea is wrong. Writing it down before or at entry — not after — is what makes the risk calculations in the template honest.

Take profit / target

Your planned exit. Logging it upfront lets you check whether you actually follow your plan, or whether you cut winners early and let losers run.

Position size

How many shares, contracts or lots you traded. Combined with entry and stop, this determines your risk per trade — the number that matters most for survival.

Exit price

Where you actually closed. The difference between exit and entry, times size, is your profit or loss for the trade.

Result (Win / Loss / BE)

Enter Win, Loss or BE for each closed trade. This is a manual input: the summary counts the Win and Loss labels to calculate win rate, so keep the spelling consistent.

Notes

The most underrated column. Why you took the trade, how you felt, what you'd do differently. Numbers show what happened; notes explain why.

The formulas behind the numbers

The template calculates these automatically, but understanding them is what turns a spreadsheet into a trading edge. All examples are fictional and for illustration only — not market data or trade recommendations.

Risk per share (or contract)

Risk = |Entry − Stop loss|

The distance between your entry and your stop. If you buy a stock at 102 with a stop at 100, your risk is 2 per share. Everything else builds on this number.

Planned risk (before costs)

Planned risk = |Entry − Stop| × Position size

What you stand to lose if the stop is hit exactly. 50 shares at 2 risk per share = 100 planned risk. Note this is planned, not guaranteed: gaps, slippage and fees can make the actual loss larger.

P&L per trade

P&L = (Exit − Entry) × Size × Direction

Direction is +1 for longs and −1 for shorts, so a winning short still comes out positive. The template handles this automatically.

R multiple

R = P&L ÷ Planned risk

Expresses every trade in units of what you risked. A +2R trade made twice what you risked; a −1R trade hit its stop. R multiples make trades of different sizes comparable.

Stop distance % (the template’s Risk % column)

Stop distance % = |Entry − Stop| ÷ Entry × 100

The workbook’s Risk % column measures stop distance as a percentage of entry price, not the percentage of your account at risk. Account risk requires a separate calculation: planned risk ÷ account balance × 100. Use the position size calculator below to plan account risk.

Win rate

Win rate = Winning trades ÷ Total trades × 100

Useful, but never on its own. A 40% win rate is profitable if your winners are much bigger than your losers — which is exactly what profit factor and average R tell you.

Profit factor

Profit factor = Gross profits ÷ Gross losses

Total winnings divided by total losses. Above 1.0 you're net profitable over the sample; 1.5 means you made 1.50 for every 1.00 lost. Below 1.0, the strategy is losing money overall.

How to use the template

1. Log every trade

One row per trade, right after you close it. Entry, stop loss, exit and position size are all the template needs — the example rows show you exactly how.

2. Review the summary

Win rate, profit factor and average R multiple update automatically, so you can see whether your edge is actually working. Review weekly, not after every trade.

3. Write down the lesson

The notes column is the real value. The patterns in your own words are what make you a better trader.

Using it in Excel or Google Sheets

Excel: open the downloaded .xlsx file directly. Everything works offline — no macros, no add-ins, nothing to enable.

Google Sheets: go to File → Import → Upload, choose the .xlsx file, and select "Replace spreadsheet". All formulas and the summary sheet carry over.

Keep it clean: only type in the input columns (date, symbol, direction, setup, entry, stop, target, size, exit, result, notes). The calculated columns and the summary sheet update themselves — overwriting a formula is the most common way these templates break.

Be consistent: use the same setup labels every time ("breakout", not sometimes "Breakout" and sometimes "BO"). Consistent labels are what make per-setup stats meaningful later.

When a spreadsheet stops being enough

A spreadsheet journal is the right starting point — it's free, flexible and forces you to understand your own numbers. But as your trade count grows, the manual work grows with it: every trade typed in by hand, every chart screenshot pasted somewhere else, every review built from raw rows.

That's the point where a dedicated journal earns its place. Norviq logs trades in seconds, calculates the same stats automatically, and adds a performance calendar, per-setup breakdowns and a community of retail traders to compare notes with. The free trading journal plan covers everything this template does — and you can keep the spreadsheet as long as you like.

Sizing your positions correctly matters more than logging them. Our free position size calculator turns your account size, risk % and stop distance into an estimated position size to enter in this template. Read its instrument-by-instrument examples to convert price gaps into pips or points, then check the currency and broker assumptions before using the result.

Outgrow the spreadsheet?

Norviq does everything this template does — automatically. Log trades in seconds, get a full performance calendar and stats, and grow alongside a community of retail traders. Free forever, no credit card required.