Trading Journal in Excel: The Template That Actually Works

Most traders start journaling in a spreadsheet, and that is the right place to start. It costs nothing, it opens on any laptop, and you can change it whenever your process changes. The problem is never the first week. The problem is week nine, when the file has four half-finished tabs, three trades you forgot to log, and a win-rate formula that silently counts your open positions.

This post gives you the structure of a trading journal in Excel or Google Sheets — the exact columns, the three formulas that matter, and the weekly routine that turns the file into feedback. It also tells you honestly where a spreadsheet stops working, so you are not the trader still fighting formulas at 11pm on a Friday.

The columns that actually matter

A journal fails when it asks for too much. Every extra field is one more reason to skip an entry, and a journal with gaps tells you nothing. Start with these and add only what you will genuinely fill in.

Date and time — lets you see whether your mornings beat your afternoons.
Instrument — NIFTY, BANKNIFTY, XAUUSD, RELIANCE, whatever you actually trade.
Direction — long or short. Many traders are far better at one than the other.
Entry price — the average, if you scaled in.
Exit price — the average, if you scaled out.
Quantity or lots — needed for any honest P&L.
Stop loss — written before entry, not after.
Target — same rule. This is what makes R multiples possible.
Fees and charges — brokerage, STT, GST, slippage. Ignore these and your edge is fiction.
Net P&L — after costs, never before.
Setup name — opening range break, VWAP reclaim, whatever you call it.
Emotion before and after — one word each is enough: calm, rushed, revenge, bored.
Rules followed — yes or no. The single most valuable column in the file.
Notes — two lines maximum. What you saw, and what you would repeat.

Fourteen columns feels like a lot until you realise eleven of them take four seconds to type. The two that traders skip most — fees and rules followed — are the two that decide whether the journal ever teaches you anything.

Three formulas, and nothing else

Spreadsheet journals collapse under their own cleverness. You need three numbers, and all three come from the columns above.

R multiple. Your risk on a trade is the distance from entry to stop, times quantity. Your R multiple is net P&L divided by that risk. In Excel, with entry in D, stop in G, quantity in F and net P&L in J:

=J2/(ABS(D2-G2)*F2)

This is the number that makes trades comparable. A 900 rupee win on a 300 rupee risk is a 3R trade whether you traded one lot or ten.

Win rate. Count the trades with positive net P&L, divide by total closed trades:

=COUNTIF(J2:J500,">0")/COUNT(J2:J500)

Win rate alone means nothing. A 35% win rate with 3R winners beats a 70% win rate with 0.3R winners, every time.

Expectancy. The average net P&L per trade:

=AVERAGE(J2:J500)

This is the honest one. It answers a single question: across everything you did, did the process make money? Track it monthly and you will stop judging yourself by your last trade.

The weekly review that makes it worth it

A journal is not a filing cabinet, it is a mirror. Block twenty minutes at the weekend and ask four questions of the file:

Which setup made the money? Sort by setup name, sum the net P&L. Most traders discover that one setup carries the account and two others quietly bleed it.
Which day or hour hurt? Group by weekday. Monday mornings and Friday afternoons have ended more accounts than any indicator.
What happened when I broke my rules? Filter "rules followed" to No. Add up the P&L of that filter. This is usually the moment the journal pays for itself.
What was I feeling? Compare the emotion column against the losses. Revenge trades have a signature: bigger size, worse entry, shorter hold.

Write one sentence of conclusion at the bottom of the sheet each week. Not a paragraph. One sentence you can act on next Monday.

Where the spreadsheet stops working

Be clear-eyed about this, because pushing through the wall costs more than the wall does.

Manual entry decays. The trades you most need to study — the emotional ones — are exactly the ones you do not feel like typing.
Costs get estimated. Brokerage, STT and slippage are fiddly, so they get rounded, and your expectancy quietly drifts away from your bank statement.
Formulas rot. A row inserted in the wrong place breaks a range, and nothing warns you. You only find out when a number looks suspicious.
It does not travel. Editing a 14-column sheet on your phone after the close is miserable, so entries wait until evening, and by evening you have forgotten what you actually felt.
There is no review, only storage. A spreadsheet holds your history. It will never tell you that your Wednesday breakouts carry the account, or that you hold losers three times longer than winners.

When to switch to a journal app

The honest test is time. If you spend more minutes maintaining the file than reading it, the file is now the job.

That is the point where Tradkraft does the typing for you. Connect your broker once and closed trades arrive by themselves — Zerodha, Dhan, Groww and Fyers in India, plus MetaTrader 5, cTrader, TradeLocker and Tradovate for forex, prop-firm and futures accounts (full list here). Fees come in from the broker rather than your memory, so net P&L matches your statement.

From there the review is done for you: profit and loss broken down by setup, by hour of day, by weekday and by emotion, a strategy playbook with the stats of each setup beside it, and an AI coach that reads your own trades in English, Hindi or Hinglish and tells you what the pattern is.

Cost to start — spreadsheet: free. Tradkraft: free for your first 30 trades.
Getting trades in — spreadsheet: you type every one. Tradkraft: broker sync, or type them.
Fees and charges — spreadsheet: estimated by hand. Tradkraft: taken from the broker.
Breakdowns by setup, hour and emotion — spreadsheet: build them yourself. Tradkraft: built in.
Review — spreadsheet: entirely on you. Tradkraft: the AI coach does a first pass.
On your phone — spreadsheet: painful. Tradkraft: made for it.

Start with the sheet, keep the habit

Build the fourteen columns this week. Log every trade for ten sessions, fees included, and run the weekend review twice. If the habit sticks, you have already done the hard part — most traders never get that far.

When the typing starts costing you more than it teaches, create a free Tradkraft account and bring the habit with you. The free plan covers your first 30 trades with the dashboard, journal and calendar; Pro is ₹999 a month, or ₹499 a month when billed yearly, and adds unlimited trades, broker sync, full analytics and the AI coach (see pricing).

Frequently asked questions

Is Excel good enough for a trading journal? For your first few months, yes. It teaches you which fields you actually use. It stops being enough when manual entry causes you to skip trades, or when you want breakdowns by setup, hour and emotion without building them by hand.

What should a trading journal include? Date, instrument, direction, entry, exit, quantity, stop, target, fees, net P&L, setup name, emotion, whether you followed your rules, and two lines of notes. Everything else is optional.

How often should I review my journal? Weekly, for about twenty minutes, plus a longer monthly look at expectancy. Daily reviews tend to turn into score-watching rather than analysis.

Can I move my spreadsheet into Tradkraft later? Yes. You can keep logging manually, import a CSV where your broker supports it, or connect the broker and let closed trades arrive on their own.