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?
Raw Betfair Data
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)
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)