Thanks for the info.
Anyone here can build this? I will pay of course!
Anyone here can build this? I will pay of course!
I know for a fact. As I have done work.
Horses that run every 25-35 days regulars have a lower strike rate than normal. I believe this because they way they are trained.
The following is over the last 3 years. You will see that the BFSP A/E remains around 1.0 irrespective of the DSLR. This is indicating that the horses are winning as often their odds are indicating they should.
View attachment 65933
You’d have to have your bands predefined as say
B1 = 1-7
B2 = 8-14
B3 = 15-21
B4 = 22-28
B5 = 29-36
B6 = 37-44
B7 = 45+
Otherwise you’re likely to end up with a practically infinite number of possibilities.
So if Horse H1 has the profile in last 5 runs of B1,B4,B5,B2,B7
Are you then wanting to find all instances over the last x years where other horses have had the same days off profile and then how they've performed? Or just the horses with the same trainer?
Like ArkRoyal I can’t see what value the former would give for unconnected horses.
However the latter would seem to mean you’re looking for the days off profile for it’s trainer?
Yep expected wins 15 actual wins 14. Only a small number of horses have actually had 3 consecutive runs with between 25-35 days between them over the last 10 or so years15 does that say?
Not sure in what context you mean by "all results"?
Not sure about others by my DB goes back to the start of 2000.
So for every run of every horse over the last x years you want to look at the days off bands for it's last 5 runs and find out whether that is winning days off profile for it's trainer?
Sorry my DB is SQL Server, too big for Excel or Access and isn't for sale as it's my own bespoke design/build etc over a period of years.