Data-capture spreadsheet
-
- Posts: 443
- Joined: Wed May 18, 2016 1:24 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
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
-
- Posts: 12
- Joined: Sat Jul 29, 2017 2:24 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?
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?
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
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
-
- Posts: 10
- Joined: Fri Oct 21, 2011 10:45 am
data.betfair.com is not working anymore and I do not understand how I can change the data format from .tar or .bz2 files to CSV etc to work on excel. Do you guys know how to work with data from https://historicdata.betfair.com/#/home?
Thanks!
Thanks!
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
There's a link to the data in csv format somewhere in this thread....
viewtopic.php?f=54&t=13157&p=141407&hilit=Data
viewtopic.php?f=54&t=13157&p=141407&hilit=Data
-
- Posts: 8
- Joined: Tue Dec 18, 2018 9:31 am
Hi all,
Is there a way to scrape data from the daily sky sports racecards into excel and then run a macro that allocates points to a specific entry?
In my head it seems possible but I have a limited knowledge of excel.
For my assessment of each horse/race I consider 5 factors (class of race vs last race, wins, placed runs, weight and form against class). For each factor I allocate points and then total them up, any horse with less than 11 points warrants a second look. I then consider these horses performance over course, distance and going (using the Stats section on RP).
Eg
Class if a horse if up in class then it scores 3 points, same class 2 points and down in class 1 point
Wins If a horse has won less than 20% of its last (6) races then it would score 4 points, 21-40% score 3, 41-70% score 2 and 71%+ score 1 point. The same scoring applies for placed runs which includes wins.
Weight Top weight (when taking into account allowance) would be 3 points, within 5lbs of top weight scores 2 points and everything else 1 point
Form/Class If the horse finishes in the top 3 LTO in the same class or higher then it scores 1 point. Top 3 in the grade below scores 2 points and everything else
The process is largely based on Robert Dowst
https://practicalpunting.com.au/pp-onli ... 1-20020720
Any thoughts or views?
Is there a way to scrape data from the daily sky sports racecards into excel and then run a macro that allocates points to a specific entry?
In my head it seems possible but I have a limited knowledge of excel.
For my assessment of each horse/race I consider 5 factors (class of race vs last race, wins, placed runs, weight and form against class). For each factor I allocate points and then total them up, any horse with less than 11 points warrants a second look. I then consider these horses performance over course, distance and going (using the Stats section on RP).
Eg
Class if a horse if up in class then it scores 3 points, same class 2 points and down in class 1 point
Wins If a horse has won less than 20% of its last (6) races then it would score 4 points, 21-40% score 3, 41-70% score 2 and 71%+ score 1 point. The same scoring applies for placed runs which includes wins.
Weight Top weight (when taking into account allowance) would be 3 points, within 5lbs of top weight scores 2 points and everything else 1 point
Form/Class If the horse finishes in the top 3 LTO in the same class or higher then it scores 1 point. Top 3 in the grade below scores 2 points and everything else
The process is largely based on Robert Dowst
https://practicalpunting.com.au/pp-onli ... 1-20020720
Any thoughts or views?
Hi Guys as Switesh seems to have left the forum can anyone help, the spreadsheet doesn't seem to work correctly for me, I keep getting run time errors when I try and switch between races in the graph tab, I'm running excel 2016? Most appreciated..
I have the same error code , but im not that tech savvy , can you give me any advice please , thankyou.chris_ri wrote: ↑Thu Mar 06, 2014 1:08 pmThanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.
Replaced
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
with
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
note the PtrSafe modifier.
Thanks again for the great spreadsheet.
Chris
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.chris_ri wrote: ↑Thu Mar 06, 2014 1:08 pmThanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.
Replaced
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
with
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
note the PtrSafe modifier.
Thanks again for the great spreadsheet.
Chris
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.scoobie wrote: ↑Sat May 02, 2020 7:30 pmWhat do i need to go on to do the same please ? I am not that tech savvy , so any pointers would be great , thankyou.chris_ri wrote: ↑Thu Mar 06, 2014 1:08 pmThanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.
Replaced
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
with
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
note the PtrSafe modifier.
Thanks again for the great spreadsheet.
Chris
sa7med wrote: ↑Sun May 03, 2020 6:32 pmopen 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.scoobie wrote: ↑Sat May 02, 2020 7:30 pmWhat do i need to go on to do the same please ? I am not that tech savvy , so any pointers would be great , thankyou.chris_ri wrote: ↑Thu Mar 06, 2014 1:08 pmThanks for looking switesh, I think I've got to the bottom of it. Im running 64 bit Office 2010, by default Office 2010 installs the 32bit version on 64 bit Windows and I suspect most people are running 32 bit Office on 64bit Windows. After a bit of research the following change to Module1 VBA code resolved the problem.
Replaced
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
with
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
note the PtrSafe modifier.
Thanks again for the great spreadsheet.
Chris
Many many thanks for the help. Where is the modules ?