Am I missing something or is the data incredibly hard to understand?
There's nothing to indicate what is a win market by the file name. It's just a jumble of different files named using random numbers.
Has anyone been able to make sense of them or import them into a database?
Free Betfair Exchange Historical Data Offer!
-
- Posts: 95
- Joined: Mon Jan 06, 2020 12:48 am
I second this, as I've been looking at historical data and having to go through a dozen random files just to find the one I want, say match odds, is infuriating.gunnerryan wrote: ↑Fri Mar 27, 2020 9:35 pmAm I missing something or is the data incredibly hard to understand?
There's nothing to indicate what is a win market by the file name. It's just a jumble of different files named using random numbers.
Has anyone been able to make sense of them or import them into a database?
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
They're not in a format you can just pull into excel. They're in JSON format and the schema doc is available to download from Betfair. You'll need to use a utility (several listed free and paid for via google) to convert them to Excel or csv format.. Also bear in mind that the data is probably delta values, ie the changes since he previous timestamp not absolute figures at given times. That would be the usual way in data like this, as it is for any time series data such as video, because it's more efficient than repeating values which haven't changed. I can't really help anymore because I don't use them.gunnerryan wrote: ↑Fri Mar 27, 2020 9:35 pmAm I missing something or is the data incredibly hard to understand?
There's nothing to indicate what is a win market by the file name. It's just a jumble of different files named using random numbers.
Has anyone been able to make sense of them or import them into a database?
-
- Posts: 95
- Joined: Mon Jan 06, 2020 12:48 am
Could you please clarify what you mean by "changes since previous timestamp"? So say match odds at 40 min are 1.21 and they are still 1.21 at 42 min, they they drop to 1.2 on 44 min...Does this mean the data shown will skip 42 min, and only shows the odds at 40 min and 44 min?ShaunWhite wrote: ↑Sat Mar 28, 2020 2:34 pmAlso bear in mind that the data is probably delta values, ie the changes since he previous timestamp not absolute figures at given times. That would be the usual way in data like this, as it is for any time series data such as video, because it's more efficient than repeating values which haven't changed. I can't really help anymore because I don't use them.gunnerryan wrote: ↑Fri Mar 27, 2020 9:35 pmAm I missing something or is the data incredibly hard to understand?
There's nothing to indicate what is a win market by the file name. It's just a jumble of different files named using random numbers.
Has anyone been able to make sense of them or import them into a database?
It’s the streaming data, details here:
https://historicdata.betfair.com/Betfai ... cation.pdf
https://docs.developer.betfair.com/disp ... Stream+API
As mentioned it’s not easy to use but can be very valuable.
https://historicdata.betfair.com/Betfai ... cation.pdf
https://docs.developer.betfair.com/disp ... Stream+API
As mentioned it’s not easy to use but can be very valuable.
-
- Posts: 24
- Joined: Sun Feb 23, 2014 5:09 pm
Noticed this under the promotions tab:
Free Betfair Exchange Historical Data Offer!
We are offering the following historical data free of charge:
January 2020– May 2020 – ADVANCED data - All Sports – (normally £2615)
April 2020 – May 2020 – PRO data – All Sports – (normally £2180)
All data can be ‘purchased’ in the usual way and will be shown as £0 cost when you complete the purchase process. No funds will be debited from your Betfair account for these free data packages.
Free Betfair Exchange Historical Data Offer!
We are offering the following historical data free of charge:
January 2020– May 2020 – ADVANCED data - All Sports – (normally £2615)
April 2020 – May 2020 – PRO data – All Sports – (normally £2180)
All data can be ‘purchased’ in the usual way and will be shown as £0 cost when you complete the purchase process. No funds will be debited from your Betfair account for these free data packages.
lol... i trust you read the OPRalfusDawes wrote: ↑Thu Apr 02, 2020 2:15 pmNoticed this under the promotions tab:
Free Betfair Exchange Historical Data Offer!
We are offering the following historical data free of charge:
January 2020– May 2020 – ADVANCED data - All Sports – (normally £2615)
April 2020 – May 2020 – PRO data – All Sports – (normally £2180)
All data can be ‘purchased’ in the usual way and will be shown as £0 cost when you complete the purchase process. No funds will be debited from your Betfair account for these free data packages.
- ruthlessimon
- Posts: 2094
- Joined: Wed Mar 23, 2016 3:54 pm
Data = 95% will moan, 5% will rejoice
Mentorship = 95% will moan, 5% will rejoice
Data + mentorship = 95% will rejoice, 5% will moan
- johnsheppard
- Posts: 284
- Joined: Mon Feb 04, 2019 6:00 am
- Location: Cairns Australia
These two comments go together ... I would say practice mode not in real time only helps you with mechanical testing of strategies....it won't help you learn why things are happening......unless you have all kinds of other data replaying back too...... but yeah, still it'd be super useful just for mechanical testing...
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Thanks