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. Column AE shows the Betfair SP odds with a 50% increase applied. Both the Archie Score and P Value have explanatory text within the file explaining what they do, and you can check out our YouTube channel here to find a walk through video example HERE File: RBD IP oddsĮxplanation of example: This download shows how you can calculate a percentage markup in the odds. There is a graphical display showing the P Value plotted over 2,500 simulated selections following the same win rate and yield as you have to date. You simply have to enter 4 elements into the file 1) Number of bets or selections, 2) Number of winners, 3) Yield or ROI, 4) Average odds across your selections.

File: Statistical RelevanceĮxplanation of example: This file automatically calculates your P value and Archie score for any data you want to back test. To do this, when your file has downloaded, right click on the file, select properties and general to get the options as shown below. If you receive a security warning regarding macros being enabled when opening or using our files please see the Microsoft link here advising why you might get this, and how to allow the files to work: Internet macros blockedĮssentially you need to tick the unblock box as shown below. These files are not intended to serve as betting systems in themselves.

These files are intended to show you how Betfair can be used to manipulate data and calculate system opportunity. This is just a random sample of data and there is no particular reason to use this other than for information display purposes.

For the purpose of the example files, the data used is taken from all Irish and GB races in January 2018.

Betfair downloading