could I filter these parameters? look for an opportunity to find runners in the daily UK horse racing cards

0 votes
here are my parameters:

Tracks: Wolverhampton, Newcastle

Going: All Weather

Race Distance: All Distances

Field Size 2 to 7 runners

Months: January February September October November December

Race Class: Class 4 Class 5 Class 6 Class 7

Years: 2014 to 2018

For horses aged 4yo to 6yo

For horses carrying 8-08 to 10-00

For horses priced between 0,00/1 to 4,00/1

Fourth Run+

For horses priced between 0,00/1 to 10,00/1 Last Time Out

Pos LTO: Won  Second Third

RaceGrade LTO: Claimer Maiden Seller Handicap
asked Jan 25 in Horseracing research by pjbrennan Plater (120 points)

1 Answer

0 votes
Yes - all those parameters are in the database and available within the daily_races and daily_runners tables, so filtering for horses that qualify is a matter of writing a simple SQL query.

The only part that is slightly more complex is for the last time out data - e.g. position last time out, or "4th run plus" - you will need to write a sub query or create a temporary table for each runner's historic runs, then join the daily parameters on that.
answered Jan 26 by colin Guru (13,100 points)