Raw Betfair Data

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Charon
Posts: 70
Joined: Tue May 25, 2010 1:09 pm

I want to use the old data that Betfair provides every week. It's a load of data, but with the help of the programm SPSS I can arrange it, filter it etc. Once that is done I want to check the specific odds movement of certain markets towards the scheduled off.

Is it correct that the column 'Odds' need to be the Y-axis and the column 'Latest Taken' the X-axis?
User avatar
to75ne
Posts: 2416
Joined: Wed Apr 22, 2009 5:37 pm

time is usually plotted on the x axis - variables on the y
Charon
Posts: 70
Joined: Tue May 25, 2010 1:09 pm

Is 'Latest Taken' correct for my purpose? Betfair also uses 'First Taken'.

Edit: Betfair use 3 types of values in the column 'In-Play'. PI/NI/PE. What does PE mean?
User avatar
BJGardner
Posts: 312
Joined: Thu Jan 31, 2013 11:09 am

The data given is as follows...



EVENT_ID
COUNTRY (horseracing only)
FULL_DESCRIPTION
COURSE (horseracing only)
SCHEDULED_OFF
EVENT
ACTUAL_OFF
SELECTION
SETTLED_DATE
ODDS
LATEST_TAKEN (when these odds were last matched on the selection)
FIRST_TAKEN (when these odds were first matched on the selection)
IN_PLAY (IP - In-Play, PE - Pre-Event, NI - Event did not go in-play)
NUMBER_BETS (number of individual bets placed)
VOLUME_MATCHED (sums the stakes of both back and lay bets)
SPORTS_ID
SELECTION_ID
WIN_FLAG (1 if the selection was paid out as a full or partial winner, 0 otherwise)
Charon
Posts: 70
Joined: Tue May 25, 2010 1:09 pm

Thanks. Question remains partially: what is the useful data for my goal? 'First Taken' or 'Last Taken'?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”