pawras
Stallion
I had some spare time so I had a wee ponder about DSLR profiles by trainer following the discussion in the thread.
Coder/scraper needed
So as an initial stab :-
I looked at all runners and since 2000 and 50% have 24 or less days between runs and 75% have a run within 71 days of their last run
Next in my own horse racing query system, going along the lines of what was talked about on the thread, I defined 10 categories and applied them to the last 5 runs of every horse to come up with a DSLR profile code
A = 1 to 7 days since last run
B = 8 to 14 days since last run
C = 15 to 21 days since last run
D = 22 to 28 days since last run
E = 29 to 35 days since last run
F = 36 to 42 days since last run
G = 43 to 49 days since last run
H = 50 to 56 days since last run
I = 57 to 84 days since last run
J = 85 or greater days since last run
Therefore for example if for the last 5 runs the days since their last run for each race was :-
Prevrun1 = 5 days
Prevrun2 = 30 days
Prevrun3 = 14 days
Prevrun4 = 42 days
Prevrun5 = 100 days
This would give a code of JFBEA , I decided to order it like you see the formline i.e. latest on the right.
However I considered some trainers might like to use 5 prep runs some 2 or some 1. Plus one trainer might use different prep runs for different types of horses.
So I broke the 5 letter code for each runner into 5 separate codes for easier processing/experimentation, therefore JFBEA would become
JFBEA
UFBEA
UUBEA
UUUEA
UUUUA
U signifying that run to be ignored.
Also you the encounter horses switching trainers so made the query only count runs at the current trainer.
Once I had that info I reported on descending profitability by race type and trainer and dslr profile code.
I’ve done so for just for a dozen or so trainers initially because working out all the stuff on the fly is a 'bit' resource intensive. Plus I limited to 1 to 5 prep runs for that reason
Thoughts on this top end of the list for Mark Johnston to £1 level stakes ISP since 2001?

Oh yeah for clarity if you look at the top two rows UUJDC is a subset of UUUDC
Coder/scraper needed
So as an initial stab :-
I looked at all runners and since 2000 and 50% have 24 or less days between runs and 75% have a run within 71 days of their last run
Next in my own horse racing query system, going along the lines of what was talked about on the thread, I defined 10 categories and applied them to the last 5 runs of every horse to come up with a DSLR profile code
A = 1 to 7 days since last run
B = 8 to 14 days since last run
C = 15 to 21 days since last run
D = 22 to 28 days since last run
E = 29 to 35 days since last run
F = 36 to 42 days since last run
G = 43 to 49 days since last run
H = 50 to 56 days since last run
I = 57 to 84 days since last run
J = 85 or greater days since last run
Therefore for example if for the last 5 runs the days since their last run for each race was :-
Prevrun1 = 5 days
Prevrun2 = 30 days
Prevrun3 = 14 days
Prevrun4 = 42 days
Prevrun5 = 100 days
This would give a code of JFBEA , I decided to order it like you see the formline i.e. latest on the right.
However I considered some trainers might like to use 5 prep runs some 2 or some 1. Plus one trainer might use different prep runs for different types of horses.
So I broke the 5 letter code for each runner into 5 separate codes for easier processing/experimentation, therefore JFBEA would become
JFBEA
UFBEA
UUBEA
UUUEA
UUUUA
U signifying that run to be ignored.
Also you the encounter horses switching trainers so made the query only count runs at the current trainer.
Once I had that info I reported on descending profitability by race type and trainer and dslr profile code.
I’ve done so for just for a dozen or so trainers initially because working out all the stuff on the fly is a 'bit' resource intensive. Plus I limited to 1 to 5 prep runs for that reason
Thoughts on this top end of the list for Mark Johnston to £1 level stakes ISP since 2001?
Oh yeah for clarity if you look at the top two rows UUJDC is a subset of UUUDC
Last edited: