BDP - Historical Data Excel Workbook

Post Reply
LinusP
Posts: 1871
Joined: Mon Jul 02, 2012 10:45 pm

Just seen that Betfair have released an excel to parse historical data, I haven’t used it but looks very handy as this seems to get asked a lot.

https://forum.developer.betfair.com/for ... l-workbook

https://github.com/betfair/historic-data-workbook
chessfoss
Posts: 5
Joined: Mon Nov 20, 2017 8:58 am

Thanks Linus for this info. Probably stupid question as you say you haven;t used it , but, can you search for player names in the data. I have installed and downloaded database but there are just a list of event ids. Would be great if you could search for a specific tennis match by player name but perhaps this isn't possible.

Thanks again for the information. it's really useful
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

Am waiting for the historic webste to be fixed, so, may as well see if this works, and do some pics.

If u download the Zip, u get these files :
Files in archive betfair free excel tool.jpg
The word doc is pretty good. here is a pic of the first 2 pages. 9i cant see to be able to upload a word doc)

histoic word page 1.jpg
historic word page 2.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

Looking further, once u have logged on to the historic site, u can view remote data etc.

I cant get it to load into a sheet .. but, maybe thats becos the site is 'under water'
view of tool showing local data.jpg
view of tool showing remote purchases.jpg
Will try later .. does look promising.
You do not have the required permissions to view the files attached to this post.
Last edited by megarain on Sun Oct 14, 2018 12:46 pm, edited 1 time in total.
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

I trying this briefly a few days ago after LinusP posted the link and it worked for me, Not had a chance to look in depth yet but did have a play and chart our a few markets etc
weemac
Posts: 1216
Joined: Mon Sep 16, 2013 8:16 pm

I tried it too but couldn't open the CSV file because of various error messages e.g. "Couldn't load.....", "Not available on this machine" etc.

Think I'll go onto Freelancer and pay someone to send me a CSV file.
spreadbetting
Posts: 3140
Joined: Sun Jan 31, 2010 8:06 pm

Image

Is this logging into the API or just the historic data server, has anyone investigated the login code. Would be good to have a login routine for the API soley via excel. I haven't had time to download or look at it but probaby wouldn't be able to decode it if I did.
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

This isnt the easiest.

Anyway, managed to get it to download some basioc golf data.

the unziped that data, but, then what ?

Shouldnt it have a csv file format ?
finished download of ecel stuff.jpg
opened basic golf files from zip.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 22671
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

If you click on the 'View Local Data' button another navigation tree should appear from there you should be able to select a market and generate a 'graphic report' etc
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

Thx .. i dunno, maybe I just break things.

I get this :
runtime error 91.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

As a general note :

I do think programmers assume a level of knowledge, which is a reach.

Most non-techies find it v hard to follow basic text. Pictures are a big help.

We stupid, and we know it.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

megarain wrote:
Sun Oct 14, 2018 3:58 pm
As a general note :

I do think programmers assume a level of knowledge, which is a reach.

Most non-techies find it v hard to follow basic text. Pictures are a big help.

We stupid, and we know it.
Nobody (?) is stupid, we all just know different stuff.
I get it Mega, and from someone on the other side of the fence I feel the same when you talk about sport which I know f'all about compared to you, and I don't especially have the desire to spend months and years studying it. We're Jack Spratt and his wife.
User avatar
megarain
Posts: 2040
Joined: Thu May 16, 2013 1:26 pm
Contact:

To be absolutely fair, the word doc does have a lot of pics.

I will maybe re-try later .. but, its time consuming, and my heart isnt really in it.

But, maybe people can get an insight etc, into whats required and what u should get out.
Rob51852
Posts: 42
Joined: Mon May 30, 2016 7:28 am

Did anyone ever get this working? I’ve tried but just get errors.

Thanks
brendan755
Posts: 3
Joined: Sun Jul 05, 2020 2:24 pm

hello all,

having issues my side too... am able to login, and see the data i've requested, but when i try to select the remote data via the filter button i get an error in the bottom left hand corner:

[readcollections error: Object required] <image attached>

seems there is some connection error and am unable to link into the options - market type / country / file type are all blank dropdowns so unable to select anything to download.

is anyone else getting this error or any ideas on how to fix ?

seems to be working via the BF front end so not sure this is a BF issue.
You do not have the required permissions to view the files attached to this post.
Post Reply

Return to “Betfair Data”