Betfair Data : Data-capture spreadsheet


gazuty
Posts: 1022
Joined: Sun Jun 26, 2011 11:03 am

Fri Oct 03, 2014 12:59 pm

Welcome back Switesh.

bilko
Posts: 147
Joined: Thu Oct 29, 2009 8:56 pm

Thu Nov 06, 2014 1:14 am

Hi Switesh

Thanks for the spreadsheet.
Read your post on Steve's site glad to see you back.
Your a highly intelligent guy.
Thanks again for sharing.

nickdelves
Posts: 11
Joined: Fri Oct 03, 2014 7:37 pm

Fri Feb 06, 2015 7:34 pm

Hi All

Looking for a data capture sheet to get similar results to PW as per here:-
http://www.betangel.com/blog_wp/2015/02 ... um=twitter

Is the sheet provided here my best option?

Thanks
Nick

cains
Posts: 28
Joined: Mon Aug 20, 2012 8:01 pm

Sun Jul 26, 2015 6:53 pm

Any macro experts that can help with this great excel sheet.
I cant trade horses, so im looking to use this sheet for soccer. I want to record odds both pre match and inplay, to see if i can sport some market trends. But where do i set the timer to do this ??
Im looking to get 15min prematch and inplay from 45min to 65min.

Dont think i can see it in the start timer macro sheet where to make the changes.

Hope someone can help.

/ Carsten

keith.wheeldon
Posts: 18
Joined: Sun Jan 04, 2015 12:01 pm

Sat Nov 28, 2015 1:43 pm

Hi

I am having trouble getting the sheet to work properly. its not displaying graphs correctly.
I get error message
' excel found a problem with ne or more formula references in this worksheet,check that all cell references , range names, defined names and links to other workbooks in your formulas are all correct.'

Does anyone have any ideas on what I may doing wrong?
Thanks

2leftfeet
Posts: 4
Joined: Mon Dec 07, 2015 9:47 am

Fri Jan 22, 2016 4:23 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.

Playbyte
Posts: 19
Joined: Thu Mar 17, 2016 6:09 am

Fri May 27, 2016 3:21 pm

As a newbie I am desperately trying to understand how all these things go together.

I very much like this spreadsheet and just know it will help me to understand trading better.

A question, am I supposed to run a bot at the same time or will the spreadsheet capture everything as it occurs,

Thanks for your help.

Roger

User avatar
Dallas
Posts: 7713
Joined: Sun Aug 09, 2015 10:57 pm

Fri May 27, 2016 4:47 pm

Playbyte wrote:As a newbie I am desperately trying to understand how all these things go together.

I very much like this spreadsheet and just know it will help me to understand trading better.

A question, am I supposed to run a bot at the same time or will the spreadsheet capture everything as it occurs,

Thanks for your help.

Roger
This sheet is set up to capture data from the horse race pre-race markets, it does nt requie your to run any other bot at the same time, once connected the sheet will just collect all the market data in the final 5 mins before each race.
If you where running some automation or trading/betting manually during this time it will record this activity as well so you can see at the end of the day which markets you made and lost any money on and therefore possible areas for improvement etc

Playbyte
Posts: 19
Joined: Thu Mar 17, 2016 6:09 am

Fri May 27, 2016 5:29 pm

Brilliant, thanks Dallas

Post Reply

Return to “Betfair Data”

  • Information
  • Who is online

    Users browsing this forum: Major Skint and 1 guest