Data-capture spreadsheet

Post Reply
sa7med
Posts: 790
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: 6245
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: 6245
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: 1820
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
Post Reply

Return to “Betfair Data”