Could database be updated to include BSP prices for win and place markets?

+2 votes
It would be a great addition if the database could be updated to include the following fields:

1. BSP (win market)

2. BSP (place market)

3. Position in betting (BSP win) - i.e. rank of horse using BSP odds for the win market

4. Position in betting (BSP place) - i.e. rank of horse using BSP odds for the place market
asked Feb 23, 2013 in Smartform by phrenetic Plater (140 points)

1 Answer

+1 vote

Colin can answer the question about including this as part of the standard Smartform database offer.

However, Betfair make the data available for free download in CSV format each night. You can see the full hitsoric file listing (going back to early 2008) at the link below:

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

All file URLs have the same root, and each individual day's file follows a standard format with only the date varying. For example, SP data files for British racing win markets have the name "dwbfpricesukwinDDMMYYYY.dsv", where DDMMYYYY is the date.

If you've a reasonable grasp of programming it's possible to write a standard daily script to download the relevant SP datafiles and parse them to insert whatever variables you want from them in your database.

answered Mar 3, 2013 by SlightReturn Listed class (2,850 points)
I do have the betfair bsp data downloaded and inserted to database. However mapping this data to betwise data is no easy task. Do you want to comment how do you do that?

(and yes, I do have a reasonable grasp of programming so be as technical as you can if possible)
Hi - we'll be adding this data as an additional download and daily update file before the Turf Flat season, stay tuned for an email update.
...