Each Way Betting Spreadsheet

In response to growing questions about Each Way Betting and requests for spreadsheet assistance or templates, I will walk you through my own personal approach to this and you are free to take a copy of my personal spreadsheet and tailor it to your own needs 🙂

OddsMonkey

Now, before we get started, spreadsheets are somewhat of a personal thing and I am very conscious that what works for one individual may not work for another and vice versa. So, having spent a bit of time trying to accommodate all scenarios and spreadsheet abilities into a very generic spreadsheet which ultimately would require much more explanation, I’ve decided to just throw my personal one up here as it stands today (Nov 23rd).

I’m not overly precious, so attached is my bet-for-bet record in all its glory since I started back in July. Take from it what you need 😉

These are the exact results that have fed my blog to date – it became too time-consuming trying to populate it with dummy data. By showing you it with real-data you can hopefully follow along with its logic and take it where you wish.

This is just how I DO IT…If you learn something from it then great, if not then no bother. I think it should, at the very least, provide a solid template from which you can build, amend, chop or stick things too – there are no right or wrong ways. Spreadsheet skills are useful in many endeavours in life, so taking the time to build your own finished version will usually result in the best results for YOU!

Download Copy

 

Pursue FIRE | Each Way Betting Template 1.0

“Note: You’ll need to make a copy of this spreadsheet in order to make it editable and make it your own. Please don’t request access to edit. I will not maintain my own records in this version from today”

Recall that you can read more about my results via my in-depth monthly reports, and if you need a recap on methods used, then there is the Full Guide to Each Way Betting Guide. Thank you by the way to those that have taken the time to send me personal gratitude for the guide. It’s awesome to hear you are benefitting from it, the blog in general and its a great motivation to keep going!

Spreadsheet Orientation

Ok, my personal spreadsheet is comprised of 5 tabs as follows:

  • Bank
  • Race Tracker
  • Daily Snapshot
  • Monthly Snapshot
  • Stats

A high percentage of this spreadsheet is automated – that being said, it will need periodic maintenance – namely when you start adding rows and new dates.

I’ve tried to limit the human involvement as much as necessary. This is a continual endeavour, but just be mindful not to interfere with formulas etc. I did consider locking cells but figured it would aid the understanding of the mechanics to see the formulas. Where necessary, you’ll find explanatory notes in the column headers, which reveal when you hover over them with your cursor. Here is an example:

Pursue Fire Each Way Betting Spreadsheet

Let’s now walk through each tab in a little more details

Bank

Pursue Fire Each Way Betting Spreadsheet

The first tab is the Bank Tab – home to all things bankroll, broken down by exposure to each bookmaker. A big component of measuring the results that will follow will be anchoring everything to your bankroll – your committed capital to each way betting; how much your overall bank is growing; which bookmakers are proving most profitable; and what your return on equity (ROI) is.

“Note Return on Equity is different to percentage growth in bank. it measures how much profit has been yielded for the amount of money actually staked. Essentially what return for what risk taken.”

The main objective here is to break out your total committed capital based on the money you deposit with the bookmakers and any money you choose to hold back.

The secondary benefit of this tab is that it provides a useful sense-check at the end of every day to ensure that your bookmaker balances tally with your results. If there is a discrepancy here, you have probably had a typo when posting your net results.

As and when you make withdrawals or deposits into the bookmakers you can record these here to maintain balance.

Race Tracker

Pursue FIRE Each Way Betting Spreadsheet

The Race Tracker tab is the engine room of the Each Way Betting spreadsheet and where I spend 90% of my time when betting. This is where bets are recorded as and when taken as advised by the OddsMonkey Each Way Matcher tool. I record the main bits of information that are useful to me:

Each of the column headers has some explanatory notes so I won’t repeat myself here. There are drop-down menus where appropriate to avoid those typos which will throw your numbers out if not detected.

Daily Snapshot

Pursue FIRE Each Way Betting Spreadsheet

From here, things are highly automated with some simple and more complex formulas. On the Daily Snapshot tab, all the results are aggregated into a daily summary, compromising a breakdown of the ratio of winners, losers, placed horses etc.

You’ll also see your profits for the day overall and cumulative as time evolves, as well as another view on your total bank, how much that has grown cumulative, as well as those return on equity figures, again for the day in question and cumulative over time.

The only column that requires your input is the date. With each day you make bets, enter the date in Column A underneath the previous day (ensuring you do so in the =DATE format). Everything else (Columns B to O) should populate once a date has been added.

Monthly Snapshot

Pursue FIRE Each Way Betting Spreadsheet

In much the same vein as the Daily Snapshot Tab, the Monthly Snapshot tab rolls things up to .. yes you guessed it, the monthly view. Focusing too much on the daily gyrations of results will drive you crazy, but a month period is a more realistic period over which to judge your relative success.

As before, the only column that requires your input is the date. With each day you make bets, enter the date in Column A underneath the previous month (ensuring you do so in the =DATE format). Everything else (Columns B to O) should populate once a date has been added.

Note: Due to the way other formulas looking between start and end dates for a given month, we actually need to make sure each month is entered as the 1st of the month

Stats

Pursue FIRE Each Way Betting Spreadsheet

The Stats tab is taking the monthly view a step further and creating some helpful statistics to help guide you. These may look familiar as I reference these in my monthly reports and are just some of the data points that I find useful, such as average daily profit in each month, return on equity and what the high watermark for my bank has been and how close to it I finished that month.

Further Analysis

Essentially that is it! If you are comfortable with spreadsheets, formulas you should be comfortable navigating the overall document and interpreting the formulas, where they look for data and how it all hangs together.

If you are a spreadsheet newbie, it may be a step too far, but let me know I’m happy to help out.

Depending on your level of geekiness – from here you can analyse any data point of your choosing. Chief among these will likely be your total profits or running ROI – some basic chart examples are included. I do most of my analysis via Google Data Studio – a much more powerful data visualisation solution (free by the way) that connects directly to your Google Sheets, not to mention many other sources of data.

Pursue FIRE Each Way Betting Spreadsheet

Next Steps

Here is the link again for the spreadsheet:

Pursue FIRE | Each Way Betting Template 1.0

I appreciate this is the first attempt to do this and there may be areas that are illogical or appear to have errors.

Please leave a comment either way and let me know if you spot any errors. Feedback is always welcome, and so if you have any recommendations or suggestions for future version let me know and I will consider them. I will make periodic updates to this document template as and when a material change is required.

As this file has all of my results to date (almost 1,600 bets) I recommend you save two copies of this file; one that retains my data so that you can refer to any formula questions you may have down the line; and a second version in which you can delete all my data to start your own records.

You’ll soon get the hang of it 😉 If there is the demand, I may try and do a few short videos on YouTube should people still need help.

All the best and I look forward to your comments and questions as always.

Dan

p.s. Here is the Full Guide again if needed

The Full Guide to Each Way Betting:

The Full Guide To Each Way Betting

OddsMonkey

This Post Has 10 Comments

  1. Nice spreadsheet Dan, thank you. This is really the level of detail i would like but i dont get from the Oddsmonkey log. Really quick to log and track profit on oddsmonkey (press of a button)but the data extract isn’t great for monitoring. I dont have a lot of time during the day and so manually entering all of this data might be too slow for me but i might give it a go. Thanks again

    1. Thanks, Alan – once you are set-up it’s really as simple as popping the selections into the RaceTracker and noting the result. I often just write my bets down in my notepad and then update it all at the end of the day when I get time. Thanks for commenting!

      Dan

  2. Some very comprehensive speadsheets there. The ones I use are a lot simpler but not really ones I wish to share, only because I know what’s going on but not sure anyone else will, haha! Had a better day today but overall, it’s no been such a great month for MB.

    1. Yeah, November has been tough. It makes me think December may be a write-off and start again in the New Year!

  3. Same for me, weenie. Small amount of profit today but nothing to write home about. Here’s hoping we can just tread water by more or less breaking even until the next trend of positive variance.

  4. Thank you Dan! From your excellent guide to matched betting, and the rest of your blog, I knew this would be worth waiting for.

    I have spent the last few weeks building up a starting bank using the Oddsmonkey new account offers, and an ready to get started with each way being. Your spreadsheet couldn’t have come at a better time.

    Keep up the great work, I’m really liking everything you have done with Pursue Fire so far 🙂

    1. Thanks, Steve – good luck and steady as she goes. Things are certainly slowing down a bit in these winter months

  5. Hi there, thanks for providing this spreadsheet, I’m trying to increase the number of bookies on the bank tab from 7 to 10 but its not working, can you tell me what I am doing wrong please?

    1. Hi Sean – its a relatively easy if you are savvy with spreadsheets. I’ll send you a private email and I can help you get this sorted. Thanks, Dan

      1. Hi Dan thanks for the response, any help will be really appreciated mate.

Leave a Reply to Rob Cancel reply

about

Hello and welcome to Pursue FIRE. My name is Dan and I am the owner and author of all content on this site. I am passionate about personal finance and look forward to engaging with you.
Read More

subscribe

We keep your data private and share your data only with third parties that make this service possible. See our Privacy Policy for more information.

Must read

recent posts

OddsMonkey

follow me on twitter

what i'm reading

‘Moneyland’ examines how corrupt politicians and oligarchs move vast sums through shell companies in offshore tax havens before spending it in the world’s playgrounds for the mega-wealthy. This book is highly compelling.

Close Menu