Betfair data

Discuss anything related to using the program (eg. triggered betting tactics)

Moderator: 2020vision

Betfair data

Postby GeorgeUK » Thu Jul 20, 2006 10:45 am

I know that betfair supply huge csv files, but don't think what i need is in them.

Does anyone know where i can get data of betfair prices say 2 min before the off for horse racing win and place markets?
I have a system which seems to be in profit based on the adrian massey site data, but was hoping to verify with the actual betfair odds.

thanks
George
previously known as Gaseous (on the betfair forum)
User avatar
GeorgeUK
 
Posts: 315
Joined: Sat Nov 19, 2005 10:18 pm
Location: Scotland

Postby The Gambling Monkey » Thu Jul 20, 2006 11:40 am

I've done something similar. It's not 100% accurate but you can get a rough guide to test ideas with.
The Gambling Monkey
 
Posts: 39
Joined: Fri Nov 18, 2005 9:22 pm
Location: St. Albans

Postby Captain Sensible » Thu Jul 20, 2006 5:05 pm

Betfair data has the following headers

SPORTS_ID EVENT_ID SETTLED_DATE COUNTRY FULL_DESCRIPTION COURSE SCHEDULED_OFF EVENT ACTUAL_OFF SELECTION_ID SELECTION ODDS NUMBER_BETS VOLUME_MATCHED LATEST_TAKEN FIRST_TAKEN WIN_FLAG IN_PLAY


It does lump amounts together so I doubt you be able to get a true figure of the odds two minutes before the off time. Easy enough to find the off time I guess and the cells you'd be interested in would be LATEST_TAKEN & FIRST_TAKEN you cannot simply take off 2 minutes from the off time as the last taken odds could be at off time and two minutes prior to the off but you'd only ever see the off time. You may find some unique odds that were last taken two mins before the off if a horse continually shortened but as we all know most go in peaks and troughs and are nlikely to peak or trough on your two minute deadline
User avatar
Captain Sensible
 
Posts: 2911
Joined: Sat Nov 19, 2005 2:29 pm

Postby GeorgeUK » Thu Jul 20, 2006 6:39 pm

Thanks Captain.

Looks like i'll need to start learning some Access.
Hopefully i'm on to a winner - most of my systems are (before they start losing :roll: )
previously known as Gaseous (on the betfair forum)
User avatar
GeorgeUK
 
Posts: 315
Joined: Sat Nov 19, 2005 10:18 pm
Location: Scotland

Postby mabell » Tue Aug 15, 2006 2:01 pm

Hi George,

I have actually spent a fair amount of time slicing and dicing the Betfair data, so I may be of some assistance.

I have been using the otherdata files (everything except horse racing) but I think the format is the same. The two fields you will be interested in with regard to time is the ACTUAL_OFF field. The SCHEDULED OFF is the time the race was due to start but it is never the same, the ACTUAL_OFF is the time, I think, where the market is suspended and then turned in play if applicable.

In analysing the data, I think the odds field you want to use is FIRST_TAKEN as opposed to LATEST_TAKEN. In other other sports especially, if a large order is placed, it takes some time for that order to be matched at those specific odds, so really it is more accurate to know when those odds were first made available rather than the last chunk of that order was matched.

Whilst access is the easiest way of importing the data, not that quick to query so you may want to restrict the data set to just a few races, you can do this by using the EVENT_ID field.
mabell
 
Posts: 1
Joined: Sat Aug 05, 2006 1:08 pm


Return to Discussion

Who is online

Users browsing this forum: No registered users and 41 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.