Data-capture spreadsheet

Post Reply
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

scoobie wrote:
Sun May 03, 2020 8:19 pm
sa7med wrote:
Sun May 03, 2020 6:32 pm
scoobie wrote:
Sat May 02, 2020 7:30 pm
What do i need to go on to do the same please ? I am not that tech savvy , so any pointers would be great , thankyou.
open the VBA editor in the developer tab on excel, and open the modules and add PtrSafe where appropriate such as above. If you don't have the developer tab then add it in the settings.

Many many thanks for the help. Where is the modules ?
https://www.ablebits.com/office-addins- ... cro-excel/

you want to edit the code in the sheets and in the modules in the VBA editor
scoobie
Posts: 6
Joined: Wed Mar 04, 2020 10:04 am

Fantastic , thankyou for providing the link aswell so helpful , thankyou once again.
Mark-H
Posts: 57
Joined: Mon Oct 17, 2016 6:35 pm
Location: North West UK

Has anyone managed to adapt this spreadsheet to import the historical data that is currently on offer for free? It seems like a fantastic way to check out some new markets while we're in lockdown.

I've taken a look at the VBA but can't for the life of me figure out how to import the data from the Betfair JSON file. I'm guessing that it will probably require processing the JSON using Python to the right layout and then pasting into the relevant data sheet. Am I on the right track?

Would love to know your opinions!

Mark H.
User avatar
ShaunWhite
Posts: 8247
Joined: Sat Sep 03, 2016 3:42 am

Mark-H wrote:
Mon May 04, 2020 10:10 am
I've taken a look at the VBA but can't for the life of me figure out how to import the data from the Betfair JSON file. I'm guessing that it will probably require processing the JSON using Python to the right layout and then pasting into the relevant data sheet. Am I on the right track?
If you google "JSON to CSV converters" you should find what you need.
Mark-H
Posts: 57
Joined: Mon Oct 17, 2016 6:35 pm
Location: North West UK

ShaunWhite wrote:
Mon May 04, 2020 2:28 pm
If you google "JSON to CSV converters" you should find what you need.
Looks like a plan! I'll take a look, cheers.

Mark H.
User avatar
ShaunWhite
Posts: 8247
Joined: Sat Sep 03, 2016 3:42 am

Mark-H wrote:
Mon May 04, 2020 3:10 pm
ShaunWhite wrote:
Mon May 04, 2020 2:28 pm
If you google "JSON to CSV converters" you should find what you need.
Looks like a plan! I'll take a look, cheers.

Mark H.
I hoped my reply didn't sound facetious. But hopefully knowing it's easiest to go via a CSV rather than directly from json to xls will help.... And that's covered pretty well generally and in far more detail than can be explained here. Good luck.
Mark-H
Posts: 57
Joined: Mon Oct 17, 2016 6:35 pm
Location: North West UK

ShaunWhite wrote:
Mon May 04, 2020 6:10 pm
I hoped my reply didn't sound facetious. But hopefully knowing it's easiest to go via a CSV rather than directly from json to xls will help.... And that's covered pretty well generally and in far more detail than can be explained here. Good luck.
Not at all. I took a look at what you suggested and you're right. There's also a ton of video tutorials on Youtube covering pretty much everything I was stuck on so with any luck it'll all become clearer as I go along. I just needed pointing in the right direction. Thanks.
User avatar
murdok
Posts: 151
Joined: Sun Apr 02, 2017 7:10 pm

great spreadsheet switesh ;) and thx

I tried to add more than 50 spreadsheet because they are very few and it gave me this error :?

Image


if someone has a spreadsheet that has more than 50 good would be 200 you can share it ?
Emmson
Posts: 2855
Joined: Mon Feb 29, 2016 6:47 pm

I had my 1st experiment with the Switesh spreadsheet last night, could be a seminal moment for me. :D
DanTheMan1
Posts: 15
Joined: Sun Feb 28, 2021 11:12 am

Good morning all, just wondering if this file still works fine or not? Seems to be a mixed reaction on the thread. If it doesn`t, is there a similar file that captures the same information available anywhere to use? Cheers Dan
Emmson
Posts: 2855
Joined: Mon Feb 29, 2016 6:47 pm

The dashboard sheet doesn't work for me.
allanmctrader
Posts: 3
Joined: Thu Dec 02, 2010 4:07 pm

Dont know if this helps anyone. I was running the latest version of excel (2021). This spread sheet does not work on the later version of excel, so i am guessing a lot of functions have changed.

Rather than trying to alter the code. I got myself an x86 (32bit) version of excel 2010, not hard to get if you know where to look, set it up on my 2nd machine and it all works perfectly with no errors. So just try to recreate the environment it was made in and you should not encounter any problems, means stepping back a few gens but well worth the trouble.

I do have a 64bit version of windows, no issues with the 32 bit excel.
Diginet
Posts: 88
Joined: Tue Jul 09, 2013 1:43 pm

Hi,

Does anyone have a copy of this spreadsheet I could use please?

Thanks

Craig
Post Reply

Return to “Betfair Data”