The three spreadsheets worth building are a trade journal (P&L, market, strategy, notes), a commission/Premium Charge tracker, and a staking + hedging calculator. Build them in Excel or Google Sheets; the value is the discipline of logging every trade, not the formatting. The columns that matter are strategy tag, planned vs actual entry, P&L net of commission, and a one-line note on what you did right or wrong.
This page contains affiliate links — if you open an account through them we may earn a commission at no cost to you. It never changes our verdict.
- Why a spreadsheet beats software stats
- The trade journal: the only essential one
- The columns that actually matter
- A commission and Premium Charge tracker
- Staking and hedging calculators
- From the desk: what my journal caught
- How to actually use it (the weekly review)
- Spreadsheet vs dedicated software
- Turning the journal into insight
- Logging on the go
- The metrics worth tracking
- The verdict
This is a sub of our Betfair trading tools and calculators pillar, and it pairs with our list of the best free Betfair tools. A spreadsheet won't place trades for you, but it's the tool that tells you which of your trades are actually making money — and that's the question most losing traders can't answer about themselves.
Why a spreadsheet beats software stats
Trading software shows your P&L, but it doesn't tell you why you're up or down, and it lumps your good strategies in with your bad ones. A spreadsheet you control lets you tag every trade by strategy, market, sport and time of day, then slice the results to find the truth: that your pre-race racing scalps are profitable but your impulsive in-play football lays are quietly bleeding the gains away. Software gives you a number; a journal gives you a diagnosis. The whole point of our trading journal guide is that you can't improve what you don't measure, and the spreadsheet is how you measure.
The trade journal: the only essential one
If you build one spreadsheet, build the journal. It's a single sheet, one row per trade, that you fill in as you go. The discipline is the value: the act of writing down what you did and why, immediately after, kills the self-deception that lets losing patterns survive. Most people skip it because logging trades is boring and admitting a stupid trade in writing stings — which is exactly why it works. Set it up so a trade takes ten seconds to log and you'll actually do it. Build it in Excel or Google Sheets; Sheets has the edge if you want it on your phone, Excel if you like pivot tables. Either is fine — the formatting is irrelevant, the consistency is everything.
The columns that actually matter
After years of tweaking, this is the column set I'd recommend, in order:
| Column | Why it earns its place |
|---|---|
| Date / time | Lets you spot time-of-day patterns (e.g. tired evening trading) |
| Sport / market | Slice profit by where it actually comes from |
| Strategy tag | The single most valuable column — which method makes money |
| Planned entry | The price your plan said to enter |
| Actual entry | What you got — the gap reveals slippage and impulse |
| Exit / green price | Where you closed |
| Stake / liability | Risk taken, for sizing discipline |
| Gross P&L | Before commission |
| Commission | Calculated, not guessed (see next section) |
| Net P&L | Gross minus commission — the only number that's real |
| Note (one line) | What you did right or wrong — the learning lives here |
The two columns people leave out and shouldn't are planned vs actual entry (the gap is your discipline leak) and the one-line note (where the actual learning happens). Net P&L is just =GrossPL-Commission, and your running bank is a cumulative sum down the Net column.
A commission and Premium Charge tracker
Commission is your biggest fixed cost and most traders estimate it wrong. A simple tracker columns your weekly net winnings per market and applies your actual rate, so your journal's Net P&L is real rather than optimistic. The formula is just =MAX(0, market_profit) * rate applied per market (commission is charged on net winning markets, and your effective rate is reduced by the discount allowance if you're active). If you trade serious volume, add a Premium Charge monitor: a running 60-week tally of gross profits, total commission paid, and the implied charge threshold, so you see it coming rather than getting blindsided. The mechanics of both are in commission explained and the Premium Charge guide — the spreadsheet just makes them visible week by week.
Staking and hedging calculators
Two small calculators save you doing maths under pressure. A hedging / green-up calculator takes your back stake and odds plus the current lay price and outputs the lay stake that locks equal profit across all outcomes — the core formula is lay stake = (back stake × back odds) ÷ lay odds. A staking calculator sizes your bet from your bank and your defined risk-per-trade, so you stake consistently rather than by feel. You can build both in a few cells, or use our ready-made trading calculator, the hedging calculator and the dutching calculator walkthroughs. The point of having them in your own sheet is that the numbers flow straight into your journal.
The setup: over one month I logged 84 trades across pre-race racing scalps and in-play football. The software dashboard said I was up +£146 net for the month and I felt fine about it.
What the strategy tag revealed: when I filtered by my strategy column, the racing scalps were +£263 net across 61 trades — small, consistent, boring. The in-play football was −£117 net across 23 trades, almost all of it from impulsive lays I'd entered with no plan (the planned-entry column was blank on 19 of them).
The discipline leak: the planned-vs-actual gap on the football trades averaged 3.2 ticks of slippage — I was chasing prices, not waiting for my level. The one-line notes were brutal in hindsight: “no reason, bored” appeared four times.
The fix and the result: I stopped trading in-play football on impulse and routed that time into more racing. The next month, same effort, the football drag was gone and the net jumped to +£291 — not from a new edge, just from cutting the leak the spreadsheet exposed.
The honest caveat: one month isn't proof, and the racing edge itself varies. But the journal didn't need to predict anything — it just told me, in my own numbers, that one bucket of trades was funding another's losses. No software dashboard had shown me that, because it lumped everything together. That diagnosis is the whole value.
How to actually use it (the weekly review)
A journal you fill in but never read is just data entry. The value is the weekly review: once a week, pivot or filter by strategy tag and answer three questions. Which strategy made or lost the most? Where is the planned-vs-actual gap widest (your biggest discipline leak)? And what do the one-line notes on your losing trades have in common? Then make one change for the next week and check whether it worked. This loop — log, review, adjust — is the entire mechanism by which the spreadsheet improves your results. It pairs directly with the discipline work in how to stop overtrading and the sizing rules in bankroll management.
Spreadsheet vs dedicated software
Dedicated trading platforms log your trades automatically and some offer analytics, so why keep a manual sheet? Because the manual act of logging is itself the discipline, and because your own sheet can tag and slice in ways generic software won't. The honest middle ground: let your software capture the raw P&L automatically, then maintain a lighter manual journal for the qualitative columns — strategy tag, planned entry, and the one-line note — that software can't infer. You get accurate numbers from the platform and the self-honest diagnosis from your sheet. Don't let “the software already tracks it” talk you out of the one column (the note) that actually changes behaviour.
Turning the journal into insight: pivots and tags
A list of trades is just data; the insight comes from slicing it, and that's where a couple of simple spreadsheet features earn their keep without you needing to be an analyst. The single most powerful move is a pivot table (Excel) or pivot/QUERY (Google Sheets) that groups your Net P&L by your strategy tag, so one click tells you exactly which method is carrying you and which is bleeding. Add a second dimension — strategy by sport, or strategy by time-of-day — and patterns jump out that you'd never spot scrolling rows: that your scalping works on racing but not football, or that everything you trade after 9pm loses. The key to making this work is disciplined, consistent tags: pick a short fixed list of strategy names ("pre-race scalp", "LTD", "in-play swing") and a fixed list of sports, and always use the exact same spelling, because a pivot treats "scalp" and "Scalp" as two different things and your analysis fragments. A few helper columns make the slicing richer: a win/loss flag (=IF(NetPL>0,"W","L")) lets you compute strike rate per strategy; a day-of-week column (=TEXT(date,"ddd")) surfaces weekend-versus-weekday patterns; and a running bank column (=previous+NetPL) gives you an equity curve you can chart in two clicks. None of this is advanced — it's the same handful of features a beginner can learn in an afternoon — but it's the difference between a journal that's a chore and a journal that actually tells you what to change. The work is in the consistent logging; the insight is nearly free once the data is clean.
Logging on the go and keeping the habit alive
The best spreadsheet is the one you actually keep up to date, and the single biggest reason journals die is friction at the moment of logging — if recording a trade is a hassle, you'll skip it, and a journal with gaps lies to you. So the design priority is making a log entry take ten seconds. A few practical habits keep the discipline alive. Use Google Sheets if you trade on the move, because you can log a trade from your phone the instant you close it rather than trying to reconstruct it from memory hours later — and reconstructed-from-memory entries are exactly the ones where self-deception creeps back in. Set up data-validation dropdowns for your strategy and sport columns so you're picking from a list rather than typing (which also keeps your tags consistent for the pivots above). Pre-fill the date with a formula or shortcut. And accept "good enough": a fast, slightly rough entry you actually make beats a perfect one you skip. The deeper point is that the journal is a behaviour-change tool, not an accounting exercise — its job is to make you confront your own trading honestly and regularly, which is why the weekly review habit matters as much as the logging itself. Pair it with the discipline work in how to stop overtrading, because the journal is often where you first see, in black and white, that you're trading too much. A spreadsheet you maintain for a month will teach you more about your own trading than any course; one you abandon after a week teaches you nothing. Build for the habit first, the analysis second.
The handful of metrics actually worth tracking
It's easy to drown a trading spreadsheet in columns and charts and end up tracking everything while understanding nothing, so it's worth being ruthless about the few numbers that actually change decisions. Net P&L by strategy is the headline — which method makes money — and if you track only one thing, track this, because it tells you what to do more of and what to stop. Strike rate and average win versus average loss per strategy together tell you how a method makes money: a scalping approach might win 70% of trades with small wins and occasional larger losses, which is fine as long as the maths nets positive, whereas the same strike rate with average losses bigger than average wins is a slow bleed dressed up as success. The planned-versus-actual entry gap is your discipline metric — a widening gap means you're chasing prices and impulse-trading, often the first sign of trouble before it shows in P&L. Commission as a share of gross profit keeps your costs visible and flags when over-trading thin markets is eating your edge. And maximum drawdown — the biggest peak-to-trough fall in your running bank — tells you whether your staking is sane relative to your bankroll, which feeds straight back into bankroll management. Notice what's not on this list: total number of trades (more isn't better), daily P&L swings (noise), and anything that flatters your ego without informing a decision. The test for any metric is simple — "if this number changed, would I do something differently?" If not, stop tracking it. A spreadsheet with five decision-changing metrics beats one with thirty vanity ones, because the point isn't to admire your trading, it's to fix it. Build the five that matter, review them weekly as covered above, and let the rest go — the discipline of tracking less, but acting on it, is itself part of the edge.
The verdict
Skip the elaborate downloadable templates and build three simple things: a trade journal you can fill in ten seconds per trade, a commission tracker so your Net P&L is real, and a hedging/staking calculator so you're not doing maths under pressure. The journal is the one that matters — its strategy tag and one-line note will tell you, in your own numbers, which trades make money and which quietly bleed it. The spreadsheet costs nothing and most traders won't keep it, which is exactly why the ones who do pull ahead. Start from the tools pillar, grab the free tools list, and commit to the weekly review.
FAQ
What should a Betfair trading spreadsheet include?
At minimum: date, sport/market, a strategy tag, planned vs actual entry price, exit price, stake/liability, gross P&L, commission, net P&L, and a one-line note on what you did right or wrong. The strategy tag and the note are the most valuable columns because they reveal which methods make money and where your discipline leaks.
Excel or Google Sheets for trading?
Either works — the consistency of logging matters far more than the tool. Google Sheets is better if you want to log from your phone and sync everywhere; Excel is better if you like pivot tables for analysis. Build whichever you'll actually keep up to date.
Do I need a spreadsheet if my software tracks P&L?
Yes, for the qualitative columns software can't infer — your strategy tag, planned entry and the one-line note. Let the software capture raw P&L automatically, then keep a lighter manual journal for the self-honest diagnosis that actually changes your behaviour.
What's the green-up formula for a spreadsheet?
Lay stake = (back stake × back odds) ÷ lay odds gives the lay stake that locks equal profit across outcomes. Net P&L is gross P&L minus commission, where commission applies to net winning markets at your effective rate after any discount allowance.
Related reading
Start with the tools and calculators pillar and the free tools list, turn data into improvement with the trading journal guide, and use the ready-made hedging and dutching calculators. Size every trade with bankroll management and get your costs right via commission explained.
A spreadsheet improves discipline and diagnosis but does not create an edge — logging losing trades neatly still loses money. Most Betfair traders lose overall and past results don't guarantee future returns. 18+ only; help at BeGambleAware.org.
Build the journal, run the weekly review, cut the leak it exposes. The cheapest edge in trading.
Open the Calculator Open Betfair Account →