Horse Racing Betting Angles: Part 3a, Query Tool Examples
This series of articles and videos has been designed to help inquisitive racing fans to understand more about the sport they love. Whether for betting or another, perhaps breeding research, purpose, there is much intelligence to be gained from looking beyond headline numbers; and Query Tool is a feature of Geegeez Gold which facilitates just such digging.
In the first part of this third part - part 3a - it is time to get into some examples. The angles highlighted have been selected in such a way that they provide a small amount of statistical 'nutrition' in and of themselves; but I hope their real value is in leading the viewer to conduct his or her own research along similar - or very different - lines.
I very much hope you enjoy it.
Matt
p.s. I strongly encourage you to take a look at the first two parts before diving into this one.
p.p.s. the subtitles took a very long time to add, but that doesn't mean they're useful. Please do leave a comment and let me know if they enhanced your enjoyment or were irrelevant. I'll not be offended - far from it, if I don't have to spend another nearly six hours of my life doing that again, I'll be delighted!
Full video transcript
So before you start pressing or clicking any buttons in anger the first thing to think about is a scenario.
What we essentially want to do is test hypotheses or theories or ideas that we have.
Using the Query Tool
So what kind of scenarios can you see?
A few examples would be trainers in certain situations like maybe early season trainer form or trainers.
Maybe trainers by jockey, maybe big trainers
Not their number one.
What about the impacts of wind surgery? We can look at that, we can look at first time after a wind op.
Any number of times after wind op. We could look into the sires or jockeys or racecourses from a draw pace perspective. There really are any number of possible scenarios to dig into.
In the remainder of this video what I'd like to do is highlight some
examples of a given scenario. So for instance,
I will evidence one trainer and we'll find a jockey to go with that.
But you of course you go away and look at...
With trainers there are any number of UK and Irish trainers who have had
400-500 runners per year so they have big sample sizes to work with and you won't always find
valuable angles. Sometimes, very often, you'll come up dry but the whole point is if you if they were all profitable then everybody would be at it and the fact that we have to work a little bit harder not a lot as you'll see but a little bit harder represents a barrier to entry for a lot of people as well of course as not having
ccess to a tool like Query Tool
Ok.
One other thing that I want to say before I start I've been asked a couple of times about parameters how should I set things up Matt? What sort of win strike rate should I look for? Where should I be with A/E and IV? What kind of return on investment should I be looking for?
The answer to this question is it's up to.
The key thing to think about win and to a lesser degree place strike rate they basically tell you how long you'll
go between drinks. A lower strike rate will mean you need a bigger bank and more discipline: if you can't handle losing runs you need a high strike rate to keep you
in the game as it were, and so there's no point researching an angle with a 10% hit rate because you could very easily go 35
qualifiers without a winner, and that's not going to work for you.If you normally bet quite short and you need lots of winners to keep you engaged then you're going to be looking you need to be.
The win percentage maybe 25 or 33%, you need to set it high
to suit your tastes.
Likewise if you want something that wins often you can use IV and say one and a half on IV and that's going to give you certainly relative to the peer group it'll give you
those qualifiers who win
one-and-a-half times or more than average. The point I'm trying to make, and it is a really important point,
worth taking time with upfront, is that
the angles that I show you,
and the angles that you research,
they might be exciting in terms of their profit or their ROI...
But if they don't fundamentally suit the way you bet,
you're going to give up on them.
This applies to any system or service you might be interested in trying as well: if the fundamental metrics of that
angle or system or service are not aligned with the way you see the betting world, with how you want to...
you appetite for risk,
the number of bets you want to place, another one is your tolerance for losing runs.
If the metrics don't match up against
those things which are personal to you
the angle is going to fail for you. Not necessarily because it's a bad angle or a bad system or service, but because it doesn't meet your personal requirements.
I hope that makes sense. It's a really, really important point and, actually, if you take nothing else away from this video, please take that away because that will stand you in good stead going forward. You need to find something that suits you. Not everything will.
Ok good right now let's crack on the first thing I want to look at then I'm recording this on the last day of March we are in a lockdown this year 2020 you might be in 3 years time content will remain valid in its conceptual form the data will obviously move on I hope I hope we have some racing in the next few years so for the 31st of March is traditionally,
in any normal year we would have just had
Doncaster and the Lincoln.
And we'd be started in the flat turf season.
I'm going to kind of pretend that the flat turf season has started and I want to look at early season trainer form.
So to do that I'm going to
MONTH and I'm going to choose March, April, May.
That's my early season.
I'm going to go to the RACE
box, just going to look at UK for now but obviously we could do this in Ireland as well.
RACE CODE, Flat Turf and Flat AW.
That kind of gives us a look at those trainers who in the month of March have been in good form on the all-weather which
gives us hope that they will take that early season form into the turf, but it also doesn't preclude those who don't bother with AW and go straight to the grass. So that's that, race code, so I'm going to change it two years as well.
I'll just click GENERATE REPORT and see where we're at.
And we've got 27,000 runners there.
Just a reminder of the filters so far we got lost two years March April May flat races in the UK.
Ok.
Now look at this data by
Trainer. I'm going to now look at RUNNER
I'll click the
TRAINER radio button, now this is the order by button. I'm sure I referenced it in part 2 but just as a reminder: the left-hand radio grey disc, if you select one of those in this case, TRAINER
And then hit GENERATE REPORT which I'll do in a second.
Summary box instead of just having this overview row
will have a breakdown by whatever you chosen to order by: in this case trainer. But it could be jockey, gender, it could be headgear, whatever, so let's hit the Generate
Report button and see what happens. It might take a few seconds to come back.
Because it's quite a big dataset.
And there we are.
All sorts of guys and girls in this list sorted alphabetically by surname we've got these with, like,.
two runs and three runs and they're not really any use to us so I'm going to apply some filters in this.
Anyway, these boxes here. Hopefully my cursor
is making a nice yellow circle where I'm clicking.
I'm going to say.
At least 20 runs, although that feels like not enough probably.
I'm going to set my win percentage at 15 which is roughly 1-in 7 and again you know that might be to low for some people; I'll set my each way to 33%.
And I'm going to do 1.25.for
A/E and IV which will all be familiar now because you checked out the information from parts 1 and 2 in this three-parter.
Ok so I'm going to click update and as you remember this is a list alphabetically ordered and it's alternate row shaded. When I click update it's simply going to
hide those rows of data that don't match my parameters here. It's not going to look as pretty as it's not re-ordering, it's just hiding them so I'll click update.
And you can see that we've now got a much
smaller subset of data
for the last 2 years.
What I'm going to do is I'm going to
extend that out maybe to the
last five years
And obviously this is
150 percent
bigger data set than the previous one. We've got a few more entries in here, now what I like to do as a starting point is I sort
Actual over
Expected, high-to-low, like this.
I can see something else that I haven't done.
Oh I have, yes, Paul Nicholls has had a few runs on the flat.
Hmm, interesting.
I am interested in
Karen McLintock.
I'm not sure Garry Moss is training anymore, his sample size is much smaller as well.
Philip Hide not training any more.
I think we'll just go with those for the minute.
I'd better make these 1, I'm not sure I got enough data in the set.
Obviously what I'm doing here is I'm
mucking about with the parameters
to get a bigger, slightly more to look at in the first instance.
I'm kind of interested in
most of those. I'll just stick with these top...
He's definitely not training any more, I don't think he is.
These are quite small sample sizes.
I'm going to leave it at that just with those three there.
What I'm going to do if I just go back to TRAINER on RUNNER and if I open this box up,
by clicking not on the radio, not this side just clicking anywhere in here.
You will see that
those +'s that I selected
have... those trainers have appeared
within the trainer selection box. So if I now click generate report it's just going to bring back those three rows.
It's really important to remember to clear these because all of a sudden you will be wondering where the data is and it is there but it's hidden because it's not satisfying these parameters at the top.
I've done that now.
So I've got 3 trainers that I'm
potentially interested in early season.
Now I'm looking at Paul Henderson,
it's a smaller sample, just 22 runners.
And there's basically no profit there.
For all that the A/E is strong, it's just not going to give enough action I don't think.
So I'll remove him and you can see that the tick's gone there and Generate Report to get rid, so I've got two trainers of interest and just to remind us of our filters.
We got the last 5 years.
UK flat races March, April and May.
And you could actually just set that up
as as an angle as is.
And when Karen McLintock and Adrian Keatley have runners in the UK on the flat
in the early part of the season you would get notified on your...
within the race cards and on the report, that's actually something else I wanted to touch on so let's quickly do that. In the previous video I told you about
how to check your QT
Angles qualifiers.
And I told you about the report.
Which I now can't find, of course.
I didn't mention and I wanted to touch on here.
Is how they show up in the race card. As you remember there's no racing at the moment, so I can't show you how they show up in the race card but this is what happens.
You will see something like.
You would see a number that isn't 0 in the blue number column.
In this case it's a 1.
When you click on that, it will show you the angle in question.
and the Profit/Loss. Basically the data/metrics from that angle.
Now if you can't remember what the parameters were for the angle, if you just hover over it as I am now.
This will happen:
It will bring up your parameters.
Just over it and it will show you, in this case I did the last five years up to 24th July 2018.
5 Furlong flat handicaps.
With these five sires. So I quite like sprint sires.
Obviously the title 'Turf Sprint Sires' is very helpful. I could have put 'Turf Sprint Handicap Sires' or whatever, but this is a little angle that I have saved.
I wouldn't necessarily be backing this horse; it would just be another piece of data that I would throw into the mix when I was looking at this race.
So that's something that I wanted to bring out: the QT Angles
displays on the race card with the
blue numbers. Clicking on them shows the angle in question, hovering over the angle shows the parameters that you set up for that angle.
OK, good.
Right, let's go back to it.
So what I'm going to do I'm actually just going to save that as it is. Now, some people...
Good discipline really is to say right that's my...
That is my five year data...
But why don't we have a look at that, before we save it, let me have a look at it by year.
And make sure that, for instance,
all of the winners didn't come in one season.
You just quickly...
I've selected year here.
Clicked Generate Report and I'm going to sort it by year.
And we can see that...
2015.
Very few qualifiers.
In the full years 2016 through 2019 we can see that there was an approximately, well, there was a 20 plus percent win strike rate.
The each way strike rate was promising as well.
The win P/L has been a bit variable and last year was lower.
Quite a bit lower.
This year.
Two of them have placed so it's in the same bracket.
On a meaningless sample size of four.
It's too early this season obviously we lost the racing now.
I wouldn't be worrying about this year.
So I'm interested in this but I can see a
general degradation of the profit and the A/E figure reflects that as well.
I would be happy to save this Angle and as I say use it advisedly rather than backing these horses blind: it would just be an aide memoire to me that McLintock and Keatley
are trainers to keep on side in the early part of the season.
So then I'd add that to
my QT Angles.
"Early Season Trainers", Add Angle,
And then that's done.
And, of course, like everything else they're all zeros, but that is one angle and you could have an early National Hunt season trainers one, a summer jumps trainers one.
You could have a
sa Summer jumps by track angle. So there are lots of different... this is one example, but there are lots of different other ways that you could cut this data.
So that's the first one. Right let's look at trainers and jockeys now so I'm going to hit my reset.
I'm actually going to refresh the page entirely.
Now this time I'm
going to look at
two years of data
I'm going to go to.
Ireland, just for fun, just to change things up a bit.
I'm going to sort by trainer.
Just do that because I want to see who's got the most
runners.
There probably is some merit in looking at trainers who maybe only have 30 or 50 runners a year.
But really I think the value is looking at the big
Big datasets.
And looking at things that
are maybe less obvious
to the man or woman
in the street.
I'm just going to change this to FLAT (TURF/AW) again
And now we've got a small subset, well, we've got a large number of trainers but a small subset of
essentially volume trainers.
The trainers I'm going to be interested in
I want 100+ wins
And that's going to quickly sort things out.
And then I'm going to sort
High to low.
And let's have a look at Aiden O'Brien. Let's select Aiden.
Generate Report, and that's going to bring just him up. I've got to remember to clear
my filters data here.
Now, I'm gping to say, show me Aiden O'Brien's runners in the last 2 years on the flat.
Sorry Aidan O'Brien Irish runners in the last 2 years on the flat
by jockey.
Click the JOCKEY radio button, click generate reports and then in my summary box.
I got all the different jockeys that Aiden has used in the last two years. Now again we've got these ones and bits and pieces, they're not really meaningful so let's sort by
wins and we'll say, "right well we're just get rid of
anybody with
less than
20 runs", let's say.
Small subset here, again sort by A/E.
And we've got.
Messrs Hussey, Moore Donnacha O'Brien,
Emmet McNamara, Seamie Heffernan,
Paidraig Beggy,
and Wayne Lordan.
Wayne Lordan
is an immediate chuck out and if you're a layer that might be interesting: an A/E of 0.53.
on 150ish.
runners is terrible.
In fairness to him, he's almost always on a second, third or fourth string but nevertheless...
And again you'd need to check
Betfair SP because he might be riding some massive priced horses, but on the face of it these are eminently avoidable.
19 out of 20 get beaten.
5 out of 6 are not even in the frame.
These are not horses to go to war with generally.
At the other end Ryan Moore is quite interesting: 34% strike rate and a small profit, in fact a reasonable profit
at SP. So we'll have a look at Ryan.
Let's take Ryan Moore and Hussey and O'Brien is now training so he's stopped; we'll have McNamara and Seamie Heffernan as well.
The reason I've done that is I've got them here now so what I can do is I can look at them individually and I still got these names here to come back to. I'm going to have a look at
Ryan Moore first.
I want to look at
a bigger data period.
So I'm going to go back 5 years.
And I'm going to sort by year.
And order this by group.
You can see here...
that essentially
what happened
in the last 2 years.
Is not replicated in any of the previous three.
This is kind of precarious territory now because we're not seeing
a replication of the Actual
over Expected, we're not seeing a replication of the profit and loss.
We are seeing that in the last couple of years Ryan's IV has risen.
Now, our job as researchers
is, if you remember the point from part 1, of logic logic logic...
If we can come up with a reason
for this, if we can explain why
in 2017
It was not good, and in 2018 it was good,.
then we've got a bit of a chance.
And there is one credible reason, and it is this.
If I go back to RUNNER
and JOCKEY. And I'm just going to look for
this guy, Joseph O'Brien.
So if I do that and then sort by
JOCKEY
Right now what I want to do is I'm ging to go to my dates and sort that by year.
And what we can see is that
Joseph stopped riding in 2015.
So that would partially explain
these data here. So 2015
Joseph had
plenty of the good Aiden horses.
It doesn't explain 2016 and 2017.
Notwithstanding that the A/E figures for those years are kind of more acceptable than
this one here.
When Ryan was competing in Ireland with
Joseph for the Aiden
rides (apologies for
first name terms).
So where do I get to with this? And again these are the kind of situations that you'll find yourself in when you're doing this.
You've got some kind of make value judgements.
Actually I should have cleared that I don't think it's going to make and difference.
I should have cleared that before.
So we've got a situation here where recent history is promising.
Longer-term history less so.
We've got kind of a partial explanation.
We've got a full explanation for the year 2015.
You can see that as Joseph stopped riding - in 2015 Ryan Moore only rode 27 of Aiden's horses in Ireland.
And in subsequent years he's ridden more, as you can see; and that is probably a factor in these numbers I think on balance it's definitely something worth
keeping in mind because it's the kind of thing...
It's one of these 'Hidden in Plain Sight' angles, it's the sort of thing that everybody thinks must be overexposed.
And it's potentially not.
Now what you might do this in the last 2 years there's kind of 200 runners there you might look at whether it's 2 year olds or Group races only you might look at
which particular
race types
O'Brien and Ryan Moore have combined with for the most success.
And that might be your angle.
This is a trainer / jockey combination and, you know, who would have thunk that
O'Brien, the best trainer in the world or certainly in Britain and Ireland, and Ryan Moore, the best jockey in Britain and Ireland, I think both of them have only got one peer and they're a partnership as well.
Gosden nd Dettori
Who would have thought that those highest of high-profile trainers and jockeys would be
borderline profitable to follow blind.
It really is quite remarkable and it's and it's worth knowing.
Saving it to your angles if that's something that you want.
Let's.
Let's do a slightly less obvious one.
This time I'm going to look at
UK trainers on the flat.
The last 2 years here, you see that there.
And from my RACE conditions I'm going to say UK.
Race code.FLAT (TURF/AW)
And then I'm going to look by trainer.
This is quite big dataset, so it will take a minute for the data to filter in. The query is complete and then it takes a second for your browser to order the data my browser is being told what to do.
And it's got to create this very big table.
And that takes a minute or a few seconds to do.
Right again we've got very small numbers in here so I'm going to sort by number of winners.
So I can see where a sensible cut-off point is.
And 150 wins
gives us plenty
to go at.
Sort by win strike right, now we can see that we've got David Evans who has
volume but low strike rate. I don't really want these
super low strike rate trainers so I'm going to put 10% in.
which actually doesn't get rid of many.
I just leave it like that I think.
So we've got quite a bit of data to go at.
Some trainers,
like Mark Johnson uses Joe Fanning and Franny Norton
extensively and there actually aren't that many left around that. Other trainers like John Gosden will.
use Frankie and Rab Havlin for the vast majority of his. Let's have a look at Johnny G actually.
And Karl Burke
And maybe Roger Varian
So what we've got here are
three trainers who all perform better than average, one of them is a standout and that is Gosden.
We're going to look at Gosden first and again if you remember we can just deselect the other trainers.
That's Johnny G's - again forgive familiarity - that's his overall 2-year
record on the flat. I want to look by jockey.
Select the JOCKEY radio button and generate report and here are the data.
Robert Havlin has had the most rides and winners in the last two years Frankie is quite selective.
Let's sort by A/E.
And again we want to get rid of the small sample sizes.
Let's say at least 15 wins,
Now we've got a much smaller
more meaningful dataset. The first thing to look at is Frankie (Dettori).
See he wins 30% of the time
Slightly.
So let's have a look at that actually overl the last 5 years, I think it might be a profit over the last five.
Break-even, but at exchange prices that will be a profit. We'll go back to two years.
So we got Oisin Murphy, Jim Crowley, Frankie Dettori, Rab Havlin, Nicky Mackay and Kieran O'Neill.
The strike rate for Nicky and Kieran is 20% or lower which in the context of the group
is not really at the level I would like to be, so we'll look at just these four guys.
So we've got four here now.
What we can do is
Rob Havlin.
It's going to be hard, I mean there might be some situations where he's
profitable to follow.
Potentially when he's on a second string so when
he's riding
a horse at
a bigger price to Frankie.
That might be something worth looking at, you can do that with odds by selecting him but I'm going to
deselect him for now.
Generate report and I've got three in here.
I want to look at these guys over the longer term, we could just quickly look at Frankie but I want to look at.
Oisin and Jim as well.
And we can see that
Oisin Murphy
When he rides for John Gosden
I mean 40%.is ridiculous...
It is a small sample size.
And these 30% numbers
certainly Frankie's, on
a bigger sample size are remarkable.
If you're betting in a race where Gosden
has got one of these jockeys up and you're not betting it
You've only got 70% of the winners to go at. Now that might be absolutely fine.
It's kind of a meaningless or misleading start in and of itself but you need to know that these guys are winning a lot of the time. Whether they're profitable or not is another question: in the case of Oisin Murphy who is
the retained jockey for Qatar Racing and it may very well be the case that
a lot of those 50 horses that he's ridden for Gosden in the last five years were for his retained owner.
That's by the by, what we need to know is that this is a guy worth following. So you might save this angle as...
Gosden and Oisin.
And add it to your setup and then when they have a qualifier you get your Gosden and Oisin...
You get your blue number here and it will tell you the numbers and you'll be able to factor that into your overall consideration of that race. It might be you might want to bet those blind or you might want to bet them more selectively as I do. But either way you have that data right in the card there and also on the QT Angles Report.
So those are jockeys and trainers. Maybe we'll just look at one more. Let's go back to
RUNNER and we'll look at the trainers.Let's have a look at Karl Burke
So I've selected TRAINER Karl Burke and I've still got this by JOCKEY.
I want to look at Burke's
rider selections in the last 2 years.
.
Again I'm going to sort it. I want to get rid of the small numbers so let's
cut that off at 50, that's fine.
Sort by A/E.
Ben Curtis is the guy that kind of immediately
jumps off the page.
Let's have a look at Ben.
Now what I want to do is I want to look I want to look by year.
How's things.
Let's go 5 years and extend it out a bit.
That year actually if we look at
the win strike rate in recent years,
2017 and onwards, you can see that the strike rate is around
16%-plus.
But last year was down.
This is one, again it's another value judgement, you've got to kind of say,
"Right, obviously if I got a year like
2017 or 2018 I'd be thrilled to be following these but if I got a year like 2019 where the strike rate was down
and I might be in the hole a fair bit at some.point,
would I be able to stomach that?"
The answer for most people is NO
Only you know the answer for you.
I'd be absolutely fine with this because, again, I'm not backing them religiously anyway. I'm missing winners but I'm missing plenty of losers as well by being selective.
What I want to do with Karl and Ben.
is I want to
look by MONTH...
I want to see, because most trainers have seasonal ups and downs, and looking at trainers by month is a valid thing to do, and often it is
quite instructive.
So I've selected order by MONTH and Generate Report. .
Now we've got some interesting
.
Remember our filters, specifically Karl Burke when Ben Curtis is riding
On the flat in Britain in the last 5 years.
See that there are some ups and downs here and the easiest way to
visualise this is with the CHART.
This is something else I wanted to show you: when you've got a...
When you've got a number of
variables in your parameter, so I've got 'by month' here and I've obviously got 12 months - 12 variables in my parameter.
Or 12 parameters in my variable, I'm not even sure which of those is right! Anyway,
what our charting software does is it takes half the dataset, or sometimes a smaller percentage. But if you click .
in the top chart,
it will show you everything. Now sometimes, if you've got like a 1000 trainers in here that's going to be not going to be able to make sense of this so what you can also do is if you click and drag
you can select
a section.
of the chart to look at in more detail. And when you've got 1000 in here that selection I've made there which is, what?, about a quarter, that's still going to be 250-odd so I might actually be only wanting to
look at a smaller subset like that.
A single click and you'll get the full dataset. Right, so here we've got Burke and Curtis.
It's sorted by Win PL I'm going to sort it by A/E, which is a good friend of mine and again clicking in the chart [to view all data].
What we need to note here.
1.0 is the line of interest in A/E (and to a lesser degree IV).
And what we can see here.
In the early part of the year.
Certainly January-February March.
And the late part of the year - October November December - this is a period that obviously aligns with the all-weather.
Karl Burke and Ben Curtis have had a good time of it.
In the summer months,
less so and particularly less so between
July, August
and September
I mean that's perfectly legitimate in my opinion.
To accept that seasonality I mean if you look at strike rate.
The average for the year, you can see this at the bottom, it's 16% overall.
And in July it's 10% or 9% in August it's 5%.
And in September it's
12%. It's much lower
than the overall averages in
April May are much lower as well so I wouldn't be including June and excluding April and May.
I'd be either including April and May as well as June, or excluding April through June, if you see what I mean. You've got to put logic behind the theory: now in this case the logic is probably these guys are
mustard on the all-weather and we can very easily check that. If we just
select the ON button here it's going to put all the months on I'm going to take out
May to September.
Is a little bit convenient maybe.
I'm going to do that, and then life looks more rosy obviously but what I want to do now.
Is I want to look at
by RACE CODE
There actually isn't a huge amount of difference.
So the theory about
most of their winners being on the all-weather is debunked.
They look absolutely fine on the flat turf as well so that's interesting that's good. One other thing that I might look at is by handicap or non-handicap.
And again.
Much better in handicap so might though it is profitable in
win profit and loss
terms in non-handicaps but if you look at the A/E that would give you cause for a slight reservation. Certainly
all of the metrics are better in handicaps.
I might change that to handicap and I might revisit my dates and see if that makes
any difference in the summer months.
And actually what it does
is it kind of reinforces
the previous date range
that we selected, which
was October through to April.
So if we delselect the summer months
We've now got...
We've essentially combined the two scenarios we've looked at so far which are kind of a sub-season.
It's sub-season trainer form with trainer by jockey.
Generate the report and we've got a nice little angle here which has been extremely profitable. It's worth looking at by year.
And we can see again that there was a
losing year in 2016.
So, again, are you comfortable with that? The answer might be no.
Generally speaking this is an approach that in the last few years has been a really
good one to have onside, so I'd always be mindful of Burke and Curtis
teaming up in handicaps in in the trainer's good times, which are October through to April.
That's an angle that I think it's worth saving.
So that's saved to my Angles now..
I want to show you one more. I am conscious of the length of this video and I might break it up into two recordings.
I will do that so I'll do this last one on trainers.
Actually I have got one more on trainers, so I'll do that in a part
3b if you like, and some people will obviously have got the general idea by now and choose not to look at
the angles highlighted in Part 3b, others will want to look at those as well.
I mean I would encourage you to look because I think,
not so much for the specific angle, but there are some more scenarios I'm going to highlight which might give you ideas to go and research on your own.
And I think there's plenty of value in that.
Let's go we're going to do another trainer jockey combo.
I do loves me a trainer jockey combo as long term
subscribers will know.
This time we're going to look at Red Raif, as I
somewhat unflatteringly call him.
Mr Beckett, who is an excellent trainer.
And a passionate man.
Somewhat political and not fully aligned with my own view of
the world. But that doesn't make him right or wrong, it just makes us different.
Anyway it is his ability to condition horses that we're interested in here so let's retain focus on that.
Beckett as you can see has a 16% strike rate in the
last two years. If we extend that out to five years, we can see he retains a very consistent strike rate.
And if we look by year,
we can see that he's...
...ignore this part year which is unrepresentative, as you can see by the number of runs, but in the main he
is consistently around 14% to
20%, average 16.5%, very solid overall figures from which to work. So what I want to do is I want to look at...
As you can see down the bottom here we've got two and a half thousand runs
So we've got a bit of data to work with..
So let's see if there are some sensible subsets within that.
We might look at
RACE CODE for flat turf and flat all-weather.
We can see that his strike rate again is consistent.
Nothing really
of interest there.
Distance.
Is he better with sprinters or middle distance horses? He doesn't have a huge amount of runners
at sprint trips.
The ones he does are largely
consistent in strike rate terms, so
nothing really going on there.
Handicap or non-handicap?
Hmm, now that's interesting.
The strike rate is not
massively different, but it is notably different, kind of 10%.
16 + 10% of 1.6 - 17.6 and it is 17.43, let's call it 9% better in handicaps.
And we've got a bit of a chance looking at the A/E figures here and Win PL on a big sample size so I'm going to look at
'Red Raif' in handicaps.
And then we've got this summary number. Now let's look by
RACE CODE
That's interesting.
Distance.
Longer-distance races look
potentially more interesting.
But what I really want to look at is by jockey.
So let's open up the JOCKEY radio button.
Generate report
And get rid of some of these meaningless .
samples, so let's say we want.
we'll start with 20+ and work up from there.
Sort by Actual / Expected
And we've actually got some really interesting players here.
Now Fran Berry has retired and he and Pat Dobbs used to ride a lot for Ralph Beckett, as did
Richard Kingscote as you can see. They had the least good data in terms
of A/E and indeed
in terms of Impact Value which is a reference to strike rate as well so they are easily excluded.
Higher up the list we've got
the likes of Sylvestre De Sousa, Josephine Gordon
I think if we put a
win strike rate of at least 15%
Get rid of some of these so we can focus more clearly and an each-way strikerate of 33%.
Now we're getting to the juice of it. And a problem with Sylvestre is that he's a fantastic jockey - that's not a problem - the problem is that everybody knows he's a fantastic jockey.
Even in this loaded situation, Beckett in handicaps, where
he places his horses very well clearly.
The strike rate is high but we're never going to be able to get rich with this guy.
I think I'm going to look at the other four
You could do more with this but really, it might be worth looking at gender - Beckett is extremely good with training fillies and mares. He's won the Oaks a number of times.
There's not really much difference.
Male horses tend to win more often the female horses.
That's just a function of
genetics I suppose; age is worth having a look.
I just want to sort this by group, so I can get a feel for the linearity of it, if you like.
Rather than cherry-picking
based on A/E
or profit.
Most of his runners are in the 2 to 4 year old age group, it might be worth focusing only on the the younger horses: 2 and 3 year olds.
I think that's probably a legitimate thing to do.
In this example I'm going to leave them all in but you might choose to focus only on those that small group you can see that they're the sort of 5, 6 and 7 year olds have very few runners. They've had 34 runs between them whereas 2-year olds alone in handicaps have had 45 runners in the period so I'm just going to leave it as is and
I think we've got a nice little trainer jockey angle here so Ralph Beckett in flat handicaps.
When he uses Oisin Murphy, Rob Hornby, Louis Steward or Harry Bentley. Now this is a five year view and again it's definitely worth looking at the year by year breakdown.
We can see that there's a
gorgeous consistency here that is an angle researcher's dream such is its
annual profit and its strike rate of
20+% (again, ignore this year because.that's
a small number of runs in the year so far). I mean that's really quite interesting.
We might look by month as well just to see if he has any seasonality to his form.
The easiest way to do this in a chart.
The 1.0 line is here and we see
again in June and July
High summer when trainers are running horses left, right and centre,
firing a lot of bullets,
it's quite difficult to retain
the higher strike rate.
And that has an impact on profitability and therefore A/E.
You might choose to leave
June and July out; I'm not seeing enough there to justify it for me so I'm going
to leave them all in.
Notwithstanding that June and July are
slightly less appealing.
I think it's a really solid angle and I'm going to save it to my QT Angles.
Added.
Alright and that's another angle.
And that is enough for this video I think. I hope
you've seen some interesting angles there. More importantly, I hope you see
some of the considerations that we need to work within when we're considering what might be an approach that suits us and when we're considering
the legitimacy of
data in terms of
it's long-term or future profitability potential.
And I hope this may have inspired you or encouraged you to maybe have a crack at researching some angles yourself. If it has and you've watched this video from the blog...
Please do leave a comment with anything that you'd be happy to share. You might want to keep some of them for yourself, and that's fine, but if you're happy to share that would be fantastic as well. Even if it's
a generic approach.
So, again, like a scenario that people could go away and look at their own
"sub-scenarios".
OK, enough already, this is Matt Bisogno saying thank you very much for watching this part 3a
of the Query Tool series. I hope you got some value from it, I'll be back the part 3b very soon.
But, for this one, byee for now.