The Tools You Need
To follow this lesson properly, you need a few practical tools in place before you begin recording and reviewing races. However, you do not need to have everything perfectly set up from the start. If you have them already then that's great. But if you don't you can still make progress with what you have and maybe treat yourself later with your winnings!
-
Excel 365 from Microsoft
Excel 365 is recommended for tracking and analysing race data because it makes filtering, sorting, and reviewing results far easier over a large sample.
Get Excel 365Here -
Betfair and Betdaq accounts
Having exchange accounts gives you access to realistic market prices and makes it easier to compare value rather than relying only on traditional bookmaker prices.
Get your Betfair and Betdaq accounts Here -
A decent laptop or desktop computer, ideally with two screens
A reliable computer setup helps you work efficiently, and a second screen makes it much easier to view race information and your spreadsheet at the same time.
Microsoft Surface works for me! Get one here
Once these basics are in place, patterns become much easier to spot and much easier to trust.
Start with an Understanding of Excel
If you have never used Excel before, the simplest way to think about it is as a digital notebook made of boxes.
Each box is called a cell, and each cell can hold a piece of information such as a date, a horse's name, the number of runners, the starting price, or the result of the race. When you place that information into rows and columns, Excel helps you keep everything neat, searchable, and easy to review later.
That matters because betting records quickly become too large to manage properly in your head or on scraps of paper. Excel allows you to sort races, filter results, compare groups of bets, and spot patterns that would otherwise be easy to miss.
You do not need to be an expert. For this course, Excel is simply a practical tool for recording what happened and helping you see whether a betting idea is genuinely working.
Open the Spreadsheet that You Received from Me
When you open the spreadsheet, the first thing you should notice is that it is not trying to impress you with excitement. It is trying to show you the truth.
The sheet records a long run of race meetings stretching over about 6 months in early 2026 and shows what would have happened if you had followed them using Betfair prices or ordinary bookmaker starting prices. It is built to measure results properly.
At the top of the sheet, you will see a summary area. This gives you the headline picture straight away: how many winners there were, how many losers there were, how many races were non-runners or no-bets, and what the overall return looked like.
That matters because many people talk about winners in isolation. A spreadsheet forces everything into one honest picture. Long losing runs, small winning spells, missed races, and the final profit or loss all sit in front of you at the same time.
Below that summary, the main table lists each selection one row at a time. Each row records the date, the race time, the track, the horse that was selected, the Betfair starting price, the bookmaker SP, the result, and the running balance after the race.
Once you understand that layout, the value of the spreadsheet becomes obvious. It is not just a list of bets. It is a record of evidence. It lets you see whether the advice being followed would actually have made money, how large the drawdowns were, and whether exchange prices improved the outcome.
That is the real lesson here. A spreadsheet helps strip emotion out of betting. Instead of relying on memory, noise, or selective stories, you can look at the numbers and judge performance on facts.
Keep Each Variable in Context
No single factor should be treated as a guarantee.
A useful variable becomes more powerful when it is understood alongside the others. A favourite may look solid because of the draw, but the pace setup may work against it. A race may fit your preferred field size, but the price may already be too short.
This is why structured thinking matters: each variable contributes to the picture, but none should replace the picture itself.
Use Your Records to Test Assumptions
Every punter has opinions. Very few have evidence.
The point of your spreadsheet is to tell you whether a variable actually improves results, not whether it sounds convincing in theory. Once enough races have been recorded, the data will begin to show which conditions are worth following and which ones only create noise.
- Record the same details every time.
- Review the results honestly.
- Keep the useful variables.
- Discard the ones that do not add value.
A Simple Framework For This Chapter
You can use this page as a template for the main variables you want to explain in more detail.
- Define the variable clearly.
- Explain why it might matter.
- Show how it fits with the rest of the strategy.
- Support it with results or examples where possible.
That keeps the lesson practical and consistent with the rest of the course.
Where This Leads Next
Once the variables are understood, the next step is to show how they can be combined into a routine that is easy to follow.
The goal is always the same: fewer guesses, fewer emotional decisions, and more confidence in the bets that do qualify.
This template keeps the structure in place so you can expand Lesson 7 without needing to change the design.