Posts Tagged ‘Sandown’
Trainers with runners at Sandown
Saturday, April 28th, 2012Sandown today represents one of the more unusual meetings on the racing calendar, with its combination of top class jump racing mixed with top class flat racing. As such, we see Flat training giants of the like of Henry Cecil rubbing shoulders with their jumps equivalents, such as Paul Nicholls.
Using Smartform we can identify exactly which trainers have runners at Sandown and produce various statistics off the back of this. This sort of query is often a useful prerequisite to working out the relative strike rate of each trainer with runners, for example.
Here, however, we will get the trainer names and show a simple count of the number of runners for each by using the group function. We’re interested in a count from those trainers fielding the largest team to those trainers fielding only one runner.
This can be done as follows:
mysql> select count(trainer_id) AS ‘#Runners’, trainer_name AS “Trainer” from daily_runners join daily_races using (race_id) where meeting_date=CURDATE() and course=”Sandown” group by trainer_name order by count(trainer_id) DESC;
#Runners | Trainer |
---|---|
6 | P F Nicholls |
5 | N J Henderson |
5 | D Pipe |
4 | P J Hobbs |
3 | J H M Gosden |
3 | Sir H R A Cecil |
3 | S bin Suroor |
3 | Miss V Williams |
2 | W Greatrex |
2 | D T Hughes |
2 | N A Twiston-Davies |
2 | A M Balding |
2 | M J Attwater |
2 | G L Moore |
2 | D McCain Jnr |
2 | Evan Williams |
1 | C G Cox |
1 | N Quinlan |
1 | Ian Williams |
1 | R C Guest |
1 | S Gollings |
1 | John Berry |
1 | M H Tompkins |
1 | B G Powell |
1 | C J Mann |
1 | T T Clement |
1 | A W Carroll |
1 | R Hannon |
1 | W S Kittow |
1 | Simon Earle |
1 | E F Vaughan |
1 | Miss H C Knight |
1 | D K Ivory |
1 | A King |
1 | M Keighley |
1 | Mrs L Wadham |
1 | J P Ferguson |
1 | Dr R D P Newland |
1 | E J Alston |
1 | Nick Williams |
1 | George Baker |
1 | R Lee |
1 | S Kirk |
1 | N J Gifford |
1 | M Appleby |
1 | A P O’Brien |
1 | W Jarvis |
1 | J W Mullins |
1 | P Phelan |
1 | Jamie Snowden |
1 | Dr J D Scargill |
1 | Mrs Mary Hambro |
1 | Jonjo O’Neill |
1 | R Varian |
1 | B Ellison |
1 | R Charlton |
1 | J R Jenkins |
1 | G McPherson |
1 | E De Giles |
1 | M Scudamore |
1 | Miss E C Lavelle |
1 | M R Hoad |
1 | R H Buckler |
63 rows in set (0.09 sec)
So no surprise that the top stables in both flat and jumps are best represented today, and some testament to what a classy day’s racing Whitbread day is (though now appears to be bet365 day?).
As for the trainers mentioned, on the Flat Henry Cecil weighs in with an impressive 14 day strike rate (according to Smartform calculations) of 24%, whilst John Gosden and Saeed Bin Suroor are languishing on 8% and 7% respectively.
Over the jumps, Paul Nicholls’ strike rate is 18% in the last 14 days and Nicky Henderson’s is an impressive 26% from 38 runners.
Draw analysis at Sandown today
Saturday, July 3rd, 2010As per last Saturday’s post we shift our attention in July to assessing the effect of the draw in upcoming races. To do this we are using an automated model created with Smartform, applying the principles laid out in the Betwise article in this month’s Racing Ahead.
Focus today is on the first race at Sandown, which requires analysis of the 5 furlong straight course in the middle of the track. As with front runners, draw bias tends to show up in results most strongly at races under a mile. Although there are notable exceptions to this rule (as with the case of the Ebor draw bias over 1 mile 6 furlongs at York), it usually pays to concentrate on sprint distances.
Sandown exposes a weakness in some draw analysis you can find, which is to concentrate on strike rate per stall, without factoring in stall positions. You can read a lot more about this in our article, but sticking with the case of Sandown, as any regular Sandown racegoer knows, the stalls are usually positioned with the highest number against the far rail and represent a position – though not necessarily a stall! – that has held a continuing advantage over the years. The actual stall number drawn against the far rail varies according to the size of the field, making strike rate per stall statistics more or less redundant. The way to overcome this is to use historic data to map the advantage of the position on the track which each stall occupied (though even here, there are always problems presented by rail movements).
Our Smartform model above maps the previous advantage of each course position onto all today’s stall numbers, as if you are looking overhead at the race about to start – stall 7 is drawn against the far rail. The height of the bar represents stall advantage, with anything over 1 indicating higher than expected winners and under 1 a negative expectation. (Stall 5 should be empty today due to the withdrawal of Wi Dud – draw 4 may be shifted one up as a result).
What conclusions to draw from this? Though we can see immediately that the draw advantage in small fields does not exclude the possibility of any runner winning, there is a distinct negative from being drawn in stalls 1, 2 and 3. Combined with front runner analysis, we can also see which, if any, of these contenders are able to break early to secure a better position (front runner analysis for this race is posted in the Betwise Members’ area and freely available). Going back to the commonly held belief that the highest stall is the place to be at Sandown, we can see that whilst this is born out by our Smartform model, it is very marginal for small fields, and there is, for example, almost as big an advantage being drawn in stall 4 today. So is Bould Mover, in stall 4, better value than Triple Aspect, the hot favourite drawn on the far rail in stall 7? Does Reignier, in stall 3, represent value at 14/1, given that stall 3 still produces a reasonable number of winners in small fields? Of course, answering these questions relies on far more than knowing the runners’ stall position – we need to know more about the ability of the horses concerned, but at least we can now put the effect of the draw in its place.