BDP - Historical Data Excel Workbook

Post Reply
User avatar
megarain
Posts: 2041
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: 2041
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.
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

brendan755 wrote:
Mon Jul 06, 2020 11:14 am
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.
Can you download the data and point the sheet to the data?
brendan755
Posts: 3
Joined: Sun Jul 05, 2020 2:24 pm

I have just tried & no it doesnt seem to recognise them. i wonder if there is some interaction with 7 zip when downloading...?
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

brendan755 wrote:
Tue Jul 07, 2020 6:06 am
I have just tried & no it doesnt seem to recognise them. i wonder if there is some interaction with 7 zip when downloading...?
Do you have 7zip installed? It may be trying to access it. Hard to say without seeing the code.
brendan755
Posts: 3
Joined: Sun Jul 05, 2020 2:24 pm

yes i did. i ran a fix on excel and have managed to get the download function working now. my next problem is that it wont take the downloaded files & merge them into a report.

when i try to run all different types of reports, it generates a new tab (with headings), but i get an error msg:

File not found in local database


But all the files have downloaded there. Have set the files to share so shouldnt be a permission issue, but running out of other ideas.

can anyone help ?

thanks
You do not have the required permissions to view the files attached to this post.
User avatar
GaryCook
Posts: 128
Joined: Sat Jan 27, 2018 6:35 pm

I got this working but the formats it uses are not very useful/intuitive.
For example the markets are just their IDs, not named, so one has to keep clicking through all of them and load them individually into the sheets to see what they are.

Anybody having luck improving it? I could potential write my own VBA with it but it's not a trivial project.

Or what other alternatives are you using for historic odds data, please?

Personally, I don't really need much right now. Just the main markets from about 100 EPL matches.

I've gotten good with using Betangel in combination with Excel/VBA/Python but that was more for future events not historical. Seems to make sense to generally use the data direct from Betfair for that but this workbook seems to need a lot of work to be useable.
Post Reply

Return to “Betfair Data”