How can I add historical Betfair SPs to DB

0 votes
Is there an easy way to add the Betfair SPs, for the past 4 years, to the DB?

If this can be done, can the DB then automatically import the Betfair SPs each day?
asked Aug 27, 2013 by flanna Novice (220 points)

1 Answer

0 votes
To add Betfair SP for historic races you need to webscrape or manually download the Betfair SPs listed in files here:

http://www.betfairpromo.com/betfairsp/prices/

This is a somewhat tedious process.  We have existing scripts to make this easier, and we plan to make these available in the /smartform_resources section before the end of the year.  Then you can run the scripts to update when you choose.  However, since Betfair control this site and the updating of it is down to them, the scripts will have to be run by the user on a caveat emptor basis.  Once you have names, dates, IDs and prices by running the script, a new table can be added in your smartform database that you can use to access the BSP of any horse as needed.  Again, we'll show how to do this in the resources section.

You can also use the Betfair API to programatically gather BSPs live - though all of the above requires some programming knowledge.
answered Sep 15, 2013 by colin Frankel (19,280 points)
...