Data-capture spreadsheet

Emmson
Posts: 3363
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: 93
Joined: Tue Jul 09, 2013 1:43 pm

Hi,

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

Thanks

Craig
User avatar
katieee
Posts: 21
Joined: Fri Jul 24, 2020 10:59 am
Location: Chichester

HI, I can see that this spreadsheet is no longer available, can anyone point me in the direction of an alterative which can collect similar data, or volumes traded at which odds please?
alexanderm1989
Posts: 3
Joined: Mon May 22, 2023 5:23 pm

Hi all.

It seems i'm only 9 years late to the party!

Unfortunately the Google Drive link doesn't work :-(

I don't suppose anyone is able to share this spreadsheet with me?

Thanks
Mark
thepressure
Posts: 160
Joined: Thu Aug 19, 2021 11:01 am

I have also been pointed here today, anyone care to share ?
Emmson
Posts: 3363
Joined: Mon Feb 29, 2016 6:47 pm

4 people here asking for the link to Switesh's much-vaunted data capture sheet, all ignored by Bet Angel Forumites with a variation of *Bystander Effect* clearly at play. :evil: :evil: :evil: :roll:

I'm Not Going To Help, Someone Else Can Help!

They were right

https://drive.google.com/file/d/1GcYbtA ... share_link

https://www.youtube.com/watch?v=AGnX7-Wtp54&t=13s
User avatar
wearthefoxhat
Posts: 3205
Joined: Sun Feb 18, 2018 9:55 am

I think I missed the initial post and never actually saw the excel sheet. Thanks for the re-download, will take a look at some time.

Down the rabbit hole with Chat GPT and speed ratings/PRB's...etc and other excel stuff at the moment. Might need to plug my brain into the internet directly, although that didn't work out too well in the following movie...

Transcendence

https://www.youtube.com/watch?v=es_KJ1jPDi0
Emmson
Posts: 3363
Joined: Mon Feb 29, 2016 6:47 pm

I have not altered the worksheet in any way.
You do not have the required permissions to view the files attached to this post.
DanTheMan1
Posts: 43
Joined: Sun Feb 28, 2021 11:12 am

Morning guys, having downloaded the file I get this error. Is there quick fix to solve this as I do not have any vba skills as such. Any help to get the sheet to work would be much appreciated. Cheers.
You do not have the required permissions to view the files attached to this post.
DanTheMan1
Posts: 43
Joined: Sun Feb 28, 2021 11:12 am

Further to the above, has anyone managed to run this file on a 64 bit system? Just so I don`t waste my time if it isn`t possible. Cheers Dan
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

This is by no stretch of the imagination a patch on the recorder produced by Switesh but it works and is easier to modify to capture the data you are looking for. The output looks like this.
Recorder Lite.png
This was just done and the sheet was connected via the Excel tab and not via Guardian


https://drive.google.com/file/d/1ReQH7F ... sp=sharing

It`s not my intention to leave it accessible for an extended period.
You do not have the required permissions to view the files attached to this post.
DanTheMan1
Posts: 43
Joined: Sun Feb 28, 2021 11:12 am

Thank you Atho55, much appreciated. I will check this out. Cheers for taking the time to reply.
Atho55
Posts: 637
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Did a few sample recordings yesterday and although not the best format to have it is possible to create a series of Pivots driven by a single slicer using the race name to pick out details of the runners. This is Back odds on 2 races.

Sample 1.png


Sample 2.png
Having the ability to export SV`s to the Excel template means you can massively expand what you can record.
You do not have the required permissions to view the files attached to this post.
DanTheMan1
Posts: 43
Joined: Sun Feb 28, 2021 11:12 am

Cheers Atho55 this looks exactly what I am looking for. Can this sheet not be assigned in guardian Excel at all? Either way thank you so much for taking time to answer my question. Dan..
Post Reply

Return to “Betfair Data”