Gauging the strength of a race from future wins/places out of the race

Question

Is their a quicker way to achieve this rather than querying the runner_ids in a race, and then looping through each runner_id to count subsequent wins and places?

Answer 1

Yes - you can use the fields that we created for this type of analysis in the historic_runners_insights tables, table schema here:

https://www.betwise.co.uk/smartform/historic_runners_insights

These are the data from that table to look at in particular:

prev_race_runners_NTO	integer	From the horse's last race, what is the total number of horses that have already had one run next time out (that ran in that original race)
pct_race_winners_LTO	numeric	From the horse's last race, what percentage of the horses that have run next time out have won
pct_races_run_LTO	numeric	From the horse's last race, what percentage of the horses that ran in the race have run at least once in another race
race_winners_LTO	integer	From the horse's last race, what number of horses have won when racing next time out

Comments

Many thanks for your response.