Average traded volume per course

The sport of kings.
Post Reply
tar1234
Posts: 15
Joined: Mon May 24, 2021 8:51 pm

Is there any data out there for newbies such as myself that shows the average traded volume for different UK racecourses?

I have a general idea about what courses would be classed as lower and higher tier in terms of quality/volume but there's a lot in between that I'm unsure about!
User avatar
Dallas
Posts: 23553
Joined: Sun Aug 09, 2015 10:57 pm

You are probably better off looking at race types rather than courses, but you can get both sets of data from the Betfair SP files
https://promo.betfair.com/betfairsp/prices

There's a tool here which will download them in batches, have a look towards the end of the thread as I think the original file has been updated to point a the latest directory
viewtopic.php?f=54&t=14395
User avatar
paspuggie48
Posts: 738
Joined: Thu Jun 20, 2013 9:22 am

Dallas wrote:
Sun Jun 27, 2021 4:37 pm
You are probably better off looking at race types rather than courses, but you can get both sets of data from the Betfair SP files
https://promo.betfair.com/betfairsp/prices

There's a tool here which will download them in batches, have a look towards the end of the thread as I think the original file has been updated to point a the latest directory
viewtopic.php?f=54&t=14395
Aye ODPaul82 did a replaced version and I added a couple of bits to it as the original file Nigelk did wasn't working for me (and some others I know). I use it daily now and it works a treat.
User avatar
ODPaul82
Posts: 808
Joined: Sun May 08, 2011 6:32 am

If at any point it needs tweaking ping me a PM on here as I don't log on all the time but will receive the PM notification in my email
User avatar
decomez6
Posts: 695
Joined: Mon Oct 07, 2019 5:26 pm

terryryan1234 wrote:
Sun Jun 27, 2021 3:41 pm
Is there any data out there for newbies such as myself that shows the average traded volume for different UK racecourses?

I have a general idea about what courses would be classed as lower and higher tier in terms of quality/volume but there's a lot in between that I'm unsure about!
i asked a similar question here ,

viewtopic.php?f=54&t=23726

just an estimate of expected( average) volume to be matched/ race . looking back at similar event in the past , right?
you would think such data is easily available. think again...excel it or screen record it or buy a betfair data package.
User avatar
paspuggie48
Posts: 738
Joined: Thu Jun 20, 2013 9:22 am

Couple of options, maybe?

a) Power Query or b) Python...both on this thread

viewtopic.php?f=19&t=22451

Caveat: I've not used this version for a long time but it should still work.
User avatar
ODPaul82
Posts: 808
Joined: Sun May 08, 2011 6:32 am

https://we.tl/t-ThhxIWiEuc

wetransfer link for a CSV of aggregates taken from my DB from 2018 up until last time I loaded data in.
Would full expect some selections to be missing

Not cleaning up the data but you can use the split function or LEFT, MID & RIGHTS to remove any bits you dont need
Post Reply

Return to “Trading Horse racing”