Example Excel Downloads
For the purpose of the example files, the data used is taken from all Irish and GB races in January 2018. This is just a random sample of data and there is no particular reason to use this other than for information display purposes. These files are intended to show you how Betfair can be used to manipulate data and calculate system opportunity. These files are not intended to serve as betting systems in themselves.
File: RBD IP odds
Explanation of example: This download shows how you can calculate a percentage markup in the odds. Column AE shows the Betfair SP odds with a 50% increase applied. In Column AF we have applied an odds filter to show "OK" where the Betfair SP odds are 5.00 or below (this is just a random odd selected for display purposes) and could be anything you chose. Stake has been set as 10 units in Column AG, and in Column AH a confirmation is given if the in play odds meet or exceed our target required.
So this example file is designed to show potential profit where the horses odds drift by 50% more in play, a lay bet is placed in running at the inflated odds. If the horse wins, our liability is paid out (as shown in row, 2, 9, 33 etc), if it loses (as expected when the odds have drifted) our stake is returned with commission deducted (5% commission is used in the formula). The total for each day is shown in the pivot table in Columns AK:AL.
In reality, not all lay bets will be matched in running - if a horse falls for example the odds will shoot past the 50% trigger point. The file is intended to show how the data can be used to start generating ideas.
File: RBD Pace
Explanation of example: This file shows a simple pivot table with filters applied. First of all the pace filter is used to select horses with a high pace rating (Speed out of the stalls / from the off), the amount of runners is then applied to show a maximum of 14, and then finally only races with a distance of less than 1 mile are included. This is just an example of how you can apply specific filters to display the potential of a system.
File: RBD Time
Explanation of example: The way Excel displays time and date can cause some issues. This file shows how to display the correct time on a 24 hour clock that will allow you to sort in chronological order if required. Column AE displays the race hour, column AF then applies a conversion to the hour to remove any non numeric characters. Column AG shows the minute and then AH shows the actual race time.
File: RBD Tissue vs Actual
Explanation of example: this file shows how you can quickly identify where the industry SP was lower than the predicted SP (Tissue price) and perhaps indicate market steamers. Column AE shows where a horse has lower SP than Predicted with an "OK". In AF a % stake is calculated based on the horses Betfair odds. AG shows the stake level in units based on 10 being the max. AH shows the profit / loss using Betfair odds and assumed commission of 5%.
The pivot table in AJ shows the daily returns. Again, this is just an example of how you can start using data and filters to create systems and strategies.
File: Daily Download (Horses history)
Explanation of example: This download shows a cut down example of our daily download file which allows you to quickly analyse, filter, or create rules using Excel formula for horses running today. This is a direct download available to all advanced members and can be found from the top menu or direct link here.
Example here is a snippet of 2 horses running on 5th July 2021
File: RBD Betfair Odds Favourite / Ranking
Explanation of example: This download has a formula applied to column AJ that will enable you to rank horses by their BSP (Betfair starting price). In the unlikely event that 2 horses have exactly the same Betfair SP they will both be given the same rank of the higher option. (So for instance if the lowest two horses are both at BSP of 2.22 - they will share a rank of 2 as there is no clear favorite to allocate a 1 too).
In column AK the formula is similar but will show both horses as a 1 (Joint Favourite) in the example given above. In the downloadable file you will see lines 2 and 3 the odds of the horses are the same, you can then see how these similar formulae give the different ranking. Please note, the odds in the file are for demonstration purposes only and are not actual or true historic odds.
File: Green up calculator
Explanation of example: This file will allow you to easily work out the profitability of backing at one odd and laying at another in either order. Simply enter the odds, the tick change and the amount to stake. This will show the profit regardless of outcome. You can further analyse by applying the % likelihood of the outcome to understand the long term profitability. Negative values shown in red.