I always start out with a single allowance for a meeting, and in my table of data (example below for yesterday) I have columns that show the difference between the OR and my rating based on the allowance, I hope you can see it okay - I removed some columns (date for example) to try to squeeze it in without removing anything you'd need to see....
View attachment 81084
OR-Rtg is the first thing I glance over after compiling ratings, they should all be (ideally) showing about 30 (OR is 30 higher than rating), in reality the best three runs of the day will average this while the rest get steadily higher (ie running lesser figures than they might). Here we see nothing past 57, which is okay - no alarm bells. If the hurdles and chases were running differently I'd see perhaps all the hurdles between 25 and 45 say and the chases would maybe be at 55-80 or whatever.... ie I'm looking for the hurdles to be a different range to the chases, with one or the other obviously better than the other - you do have to accept that it won't usually be completely straightforward, you might find one race that is notably higher or lower than the others of its type.
If I think there might be an issue then I look at the s/f values, which shows the time fast/slow per furlong for the race. As you see above they are all reasonably similar with no obvious split in the range covered - Hurdles are 1.23, 1.53. 1.64, 1.45, 1.75 while the chases are 1.25 and 1.38, which fit happily into the hurdle range towards the lower end. You might see 1.2 -1.6 for hurdles and 2.3 - 2.5 for the chases (as an example), to go along with seeing both chases are showing bigger OR-rtg scores, that would be a pointer that the chases were running in slower ground.
Additional help comes from the 'This runner' column (ratings the winner has previously earned) that allows me to see if the rating for today is a reasonable fit with previous ratings (ie not 50 lbs better than before, or 50 lbs worse) and the 'spd rtgs' column that shows me ratings of winners of similar races at the track, which helps show if the rating is unusual for this class/type/track. These two columns can help confirm an opinion formed by looking at the OR-rtg and s/f, I wouldn't base a decision on this last pair if I hadn't already spotted a potential issue from the s/f and OR-rtg,.
If I decide there's a problem I then split the results data I've already processed from the bare results file and treat chases and hurdles as two separate meetings, and see what comes out, checking to see if it likes a better fit.
There is a large degree of personal opinion involved in this, it's deciding if 'it looks right' - I might reprocess things several times, thinking each rerun still doesn't feel right, until I hit on something I can live with.
Dave
I'm currently trying to rate National Hunt using quadratic equations , done a few courses and my sheet calculates everything automatically.I always start out with a single allowance for a meeting, and in my table of data (example below for yesterday) I have columns that show the difference between the OR and my rating based on the allowance, I hope you can see it okay - I removed some columns (date for example) to try to squeeze it in without removing anything you'd need to see....
View attachment 81084
OR-Rtg is the first thing I glance over after compiling ratings, they should all be (ideally) showing about 30 (OR is 30 higher than rating), in reality the best three runs of the day will average this while the rest get steadily higher (ie running lesser figures than they might). Here we see nothing past 57, which is okay - no alarm bells. If the hurdles and chases were running differently I'd see perhaps all the hurdles between 25 and 45 say and the chases would maybe be at 55-80 or whatever.... ie I'm looking for the hurdles to be a different range to the chases, with one or the other obviously better than the other - you do have to accept that it won't usually be completely straightforward, you might find one race that is notably higher or lower than the others of its type.
If I think there might be an issue then I look at the s/f values, which shows the time fast/slow per furlong for the race. As you see above they are all reasonably similar with no obvious split in the range covered - Hurdles are 1.23, 1.53. 1.64, 1.45, 1.75 while the chases are 1.25 and 1.38, which fit happily into the hurdle range towards the lower end. You might see 1.2 -1.6 for hurdles and 2.3 - 2.5 for the chases (as an example), to go along with seeing both chases are showing bigger OR-rtg scores, that would be a pointer that the chases were running in slower ground.
Additional help comes from the 'This runner' column (ratings the winner has previously earned) that allows me to see if the rating for today is a reasonable fit with previous ratings (ie not 50 lbs better than before, or 50 lbs worse) and the 'spd rtgs' column that shows me ratings of winners of similar races at the track, which helps show if the rating is unusual for this class/type/track. These two columns can help confirm an opinion formed by looking at the OR-rtg and s/f, I wouldn't base a decision on this last pair if I hadn't already spotted a potential issue from the s/f and OR-rtg,.
If I decide there's a problem I then split the results data I've already processed from the bare results file and treat chases and hurdles as two separate meetings, and see what comes out, checking to see if it likes a better fit.
There is a large degree of personal opinion involved in this, it's deciding if 'it looks right' - I might reprocess things several times, thinking each rerun still doesn't feel right, until I hit on something I can live with.
Dave
Like Dave there is a column for each race that indicates a going allowance for that individual race (Horse GA) then it calculates a going allowance and ratings for the whole card and a going allowance and rating when the Hurdles and Chases have been split.
First looking at this meeting from Limerick 28/12/2018
| racetime | track | yards | Type | horse_name | STANDARD | Comp | Horse GA | GA | Rating | SplitGA | SplitRating |
13:40:00 | Limerick | 3520 | Hurdle | Espoir Dallen (FR) | 218.47 | 22.53 | 164 | 36 | 38 | 166 | 168 |
12:30:00 | Limerick | 3900 | Chase | Redhotfillypeppers (IRE) | 260.83 | 7.17 | 31 | 36 | 134 | 32 | 130 |
14:10:00 | Limerick | 3520 | Hurdle | Press Conference (IRE) | 218.47 | 32.13 | 181 | 36 | 0 | 166 | 104 |
13:05:00 | Limerick | 4960 | Chase | Lilshane (IRE) | 331.60 | 16.40 | 58 | 36 | 104 | 32 | 100 |
14:45:00 | Limerick | 4620 | Hurdle | Owl Creek Bridge (IRE) | 297.85 | 44.65 | 185 | 36 | 0 | 166 | 92 |
12:00:00 | Limerick | 4840 | Hurdle | Melly And Me (IRE) | 314.37 | 51.03 | 193 | 36 | 0 | 166 | 79 |
15:50:00 | Limerick | 3520 | H Flat | Cobblers Way (IRE) | 214.10 | 37.90 | 219 | 36 | 0 | 166 | 75 |
15:20:00 | Limerick | 4620 | Hurdle | Chosen Hour (IRE) | 297.85 | 50.85 | 213 | 36 | 0 | 166 | 59 |
This seems to be a no brainer if going on my data a clear split and if I did split Espoir Dallen (FR) would be rated 168( the highest hurdle rating I've seen so far in my sheets) and went on to win Champion Hurdle so that looks promising.
I looked at other Limerick meetings and the chase course is very often slower or on par with hurdles so i'm not concerned at this stage that it has returned lenient standards for the chase course.
Then there are the meetings where the chase and hurdle are very close to the point where it doesn't matter if you split them or not because they have roughly the same going allowances
Where i'm finding difficulty is meeting like Haydock 25/11/2017
| racetime | track | yards | Type | horse_name | STANDARD | Comp | Horse GA | GA | Rating | Split GA | SplitRating |
15:00:00 | Haydock | 5643 | Chase | Bristol De Mai (FR) | 398.83 | 21.47 | 120 | 104 | 162 | 120 | 179 |
14:25:00 | Haydock | 5017 | Hurdle | Sam Spinner | 330.05 | 17.55 | 109 | 104 | 157 | 103 | 156 |
12:40:00 | Haydock | 6275 | Chase | Hainan (FR) | 449.15 | 35.85 | 127 | 104 | 124 | 120 | 141 |
13:50:00 | Haydock | 4151 | Hurdle | Limited Reserve (IRE) | 270.06 | 16.94 | 103 | 104 | 137 | 103 | 136 |
13:15:00 | Haydock | 4756 | Chase | Clan Des Obeaux (FR) | 330.36 | 28.24 | 148 | 104 | 117 | 120 | 133 |
15:35:00 | Haydock | 5643 | Chase | Chase The Spud | 398.83 | 35.57 | 143 | 104 | 107 | 120 | 124 |
12:10:00 | Haydock | 3444 | Hurdle | Delire Destruval (FR) | 220.42 | 20.58 | 126 | 104 | 107 | 103 | 107 |
So trick to know what is the correct course of action and I imagine even harder to automate on a spreadsheet.
Last edited:
