Betfair Data : Data-capture spreadsheet

Post Reply
Kev123in
Posts: 42
Joined: Sat Apr 23, 2016 1:13 pm

Mon Aug 29, 2016 5:44 pm

I am able to download this spreadsheet but it wont open? any help would be much appreciated.

Ralphyboy
Posts: 28
Joined: Wed Sep 14, 2016 12:55 pm

Mon Oct 03, 2016 12:48 pm

I have a problem with the spread sheet. It is running on a 64bit machine, so I had to include the Ptrsafe keyword into the code, which I did. But now, upon trying to save the workbook after it has been collecting data I get the following error message 'We found a problem with one or more formula references in this worksheet' and it non of the names of the runners have been recorded. Has anyone else experienced this , or can anyone supply an answer as to how to resolve this error. The only change that I have made, other than the Ptrsafe, is to alter the start timings on the worksheets as per the video. Hope someone can help. Many thanks.

I have exactly the same issue as the gent above but noticed he didn't get a reply is this as the problem isn't easily fixed . Obviously this spread sheet is two years old now is this still our best options for tracking our results or is there something else everyone is using now.

User avatar
mcgoo
Posts: 136
Joined: Thu Jul 18, 2013 12:30 pm

Thu Oct 06, 2016 11:49 am

Awesome work mate.Thank you :D

uruz555
Posts: 3
Joined: Fri Feb 26, 2016 7:40 pm

Tue Nov 22, 2016 4:21 pm

@RalphyBoy I have the same problem.

I have noticed after launching a recorded data sheet to change to different markets it asks to enable editing. After that I can never open it again or when I can open it on the chartview sheet there is no data available all with ###### on the trading ladder.

Is there no solution to this ? OP help please

User avatar
bennyboy351
Posts: 153
Joined: Sat Jun 07, 2014 6:01 pm
Location: West Midlands, England.

Thu Feb 16, 2017 12:10 pm

What can I say that hasn't been said before!

As someone who is just starting out using Spreadsheets, I found this invaluable. The instructional video is superb.

Many thanks for sharing. :-)

JPK65
Posts: 41
Joined: Fri Jan 27, 2017 6:09 pm

Thu Apr 20, 2017 3:18 am

This looks like a great spreadsheet. Its just what I need, but I am getting a compile error when I open it with Excel 2010 on a 64 bit laptop. Any Ideas of how to fix this. Note I have no experience with macros.

iambic_pentameter
Posts: 231
Joined: Wed May 18, 2016 1:24 pm

Sun Aug 27, 2017 4:05 pm

After some research, I downloaded this and have to say, a brilliant resource - along with the excellent video.

I'm not sure whether he will see this, but thank you, Switesh.

One issue I'm having, is that I tried to capture the in running prices on the first few races today but nothing happened.

I had it connected to Guardian and on the main tab, ticked the IR part - didn't tick Pre-Off and Start Price though.

If anyone can assist or give other advice on how to grab the IR prices that would be great.

Thank you,

Iambic

calvinkbee
Posts: 11
Joined: Sat Jul 29, 2017 2:24 am

Sat Jan 13, 2018 12:33 am

I've just seen this and my goodness this is awesome work, and so generous of Switesh to share!

Thank you so much Switesh, are you still about and trading?

I'll give this a go but even before trying I have to take my hat of to the guru who posted this in such a humble way.

Thanks Switesh

p.s Iambic, did you have any joy with the In Play market?

Ryan7724
Posts: 9
Joined: Sat Apr 08, 2017 9:13 am

Tue Feb 20, 2018 5:35 pm

switesh was last active one here in 2014 from what i can see.
A great piece of work fair play to him!
As he cant be contacted im wondering if anyone else had issues updating the Dashboard as mine is not showing any info, everything else works great?
Cheers

Ryan7724
Posts: 9
Joined: Sat Apr 08, 2017 9:13 am

Tue Feb 20, 2018 5:42 pm

Disregard my last post found the problem,
for anyone having an issue refreshing Dashboard just use the Refresh All button in Excel and it will work.

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest