• Hi Guest Just in case you were not aware I wanted to highlight that you can now get a free 7 day trial of Horseracebase here.
    We have a lot of members who are existing users of Horseracebase so help is always available if needed, as well as dedicated section of the fourm here.
    Best Wishes
    AR

Early days

Started almost 4yrs ago and now 153 pages further on - a lot of work gone in to this project davejb davejb - what would you say were the major or important changes along the way to your success’s.
 
I'm not sure successes describes the bumpy road covered!
To get to this point has involved a number of steps, I'll mention a few odd thoughts then but there are undoubtedly many other paths that can be followed, some of which will be quicker and more successful.

There are some things that haven't changed over time, that have been and I think are essential for taking the path I have. One has been programming. I've written programs for about 40 years, I've learned a good number of computer languages over that time and become competent in them, and I think it would be fair to say I am well and truly bored and fed up with them.... but without being able to program much of my daily work I'd never have got through anything like as much of it as I have. Throw in forcing myself to learn how to set up macros in Excel and suchlike. Every day I run a series of programs that strip results data, rejiggle it, save it as a set of databases (very simple csv's, nothing clever), then go through that data extracting information such as how each runner performed (not just winners). The odd Excel macro is used to sort the course winrate info along the way.

Those programs not only extract the basic data about the runners, races, and trainers/jockeys etc but also give me files I can load into Excel and use the data filtering on to find out win rates for different combinations of info - so I can check, for example, how all my 2nd or 3rd or 4th top rated runners yesterday did, and I can do that over any set of distances, courses, etc whilst also seeing what 'flags' were in play, what the market position was, all sorts of things. These allow me to do things like the 'picks'. where I use Excel to determine that 'top rated in a handicap, was in last three last time out' and similar are worth a bet. When I find things like that I make additions to the ratings program i run in the evening that will pick these runners out and list them in a csv for me to look at.

So not a change - the bedrock of it all is being able to use Excel and write programs. I program in Python 2, which is a very easy language to learn - like all programming languages a small start writing things that do simple things earns the experience needed to write more complex and useful code.

Originally I looked at a couple of books about betting systems, Larkspur method was one, class figures another, and I've since read a few more from the likes of Nick Mordin. I consider them to be distractions, from a betting viewpoint, at the very most I'd pick up a fraction of an idea that would in itself not be any use but perhaps kicked my mind off into another area that I did make some progress in. Once I'd got past reading them for betting and just enjoying the read as a story I got onto speed ratings, which I'd done years ago for greyhound racing, and trawled Youtube looking for clues. I'm pretty certain I found a video from TheBluesBrother TheBluesBrother that was, by then, maybe 8 years old or so. I picked up a basic method of compiling them from that, got some info on here from Mike about improving the old method, then got further info such as 'rail movements are important'.

After a few weeks of doing ratings in Excel, and storing them in the RP 'my ratings' bit (and cursing the inability to change the lbs/length values on a per meeting basis) I found I was putting in a couple of hours a day just rating horses manually, and that's when I decided I'd never want to work that hard every day just to rate results. You can't 'skip' days though, so if you don't do the ratings one day you have to go back and add them to the next day's workload. This taught me a bit more bloody mindedness perhaps, for the past 50 years or so I have tended to batter away at things until they are finished to what I consider an appropriate standard - I think that being stubborn is important too. That's what drove me to program it all up, to make as much of the job as easy as I could. It still takes an hour to two hours to process results, but I am also stripping all sorts of analysis out as well, all of which forms the foundation of my efforts.

From then on changes did kick in, because I found the raw ratings probably only give around 20% winners - this varies, as the ratings are always based on past runs of course so when the going changes, for one example, ratings can be quite poor until newer ratings start to appear. The variation in going coupled with the variations in track geometry combine to make consistency in assessing races a difficult business.

First big change was realising that the top rated runners represented a pool of potential winners, and would be the best place to look for horses to bet on. This is one of those simple ideas, 'don't bet on a horse doing something it hasn't managed to do before' as I'd phrase it. To win a race going faster is, I would argue, a significant bonus. A high past speed rating shows what a horse can do in the right circumstances. I see no reason to ignore the top rated runners... all I need to do is find the ones from that shortlist who are going to win! (Easy eh?)

This change led me to start looking into the data to try to identify patterns amongst the top rated - I did checks on how many ratings to look back over, and suchlike, and I spent a lot of time looking at the data with ideas like 'was placed last time out/ did/did not win last time out was in the first x in the betting, had previously won/placed at this class/going - all sorts. What I found was a bit annoying, very very few such ideas, when I checked the results, actually produced notably better win rates.

Perhaps 18 months back there was some emphasis on runners that were setting top ratings in the past week, and also fastest last time out. By focussing on these I began to see patterns I could use - the 'selections' were the result, and for about 3 months each winter, as the soft ground through December-Feb or so stayed relatively unchanged, the NH selections did okay. I never got the handicaps to work though, and a few good runs was all I ever got from them - the usual problem, find an idea that works really well, and as soon as you use it the idea starts to splutter.

I decided that I needed better data - back as this was all starting 4 years ago Mike had asked me to write a program to check race times from Timeform and RP against each other, I had to learn how to scrape websites via my programs (that had me stymied for several days) - and I check these against my HRB data each day. This highlights races I need to check videos for timing, I kind of assume that if all TF and RP (HRB is basically the same as RP) times agree then they're probably correct. Rail moves from the BHA sleepy weasel department, that only leaves standard times.

RP standards this time last year were bad, in my view. I spent months writing more programs, after about 2 months just collecting and editing the data (correcting as many errors as I could - plus trying to ensure I got things like 'outer/inner course' and suchlike correct). Then I compiled my own set of standards and spent another couple of months trying to find the errors in them, and apply corrections. Now I have standards I can work with, and that has boosted my results a little. I find that the 'picks' are working okay - a combination of top rated runners with extra filtering provided by their previous placing - this will always be a bit less than precise, coming third in a 20 runner handicap is probably rather a good pointer while third of three by 25 lengths is not - but such issues should be statistically trivial over a season.

Standards - O Outlander did a few courses, initially I added his standards in place of the relevant RP ones, but I decided this was too much of a bodge, and although I was very very loathe to do the work, I knew it would be months of slog, in the end I decided I had to do it.

So although not a change, interacting with people who have a clue is, and has been, important to the development.
I'd also say that interacting on here with other members is important, it helps avoid that 'working in isolation' feeling that can otherwise arise - I doubt mick mick and myself have exchanged much info that we subsequently made any use of, but the entertainment value of 'chatting' with him has been significant, I'm not going to do an acceptance speech but others like yourself markfinn markfinn , Chesham Chesham , pete pete and a good few more (enter blog member list here) have provided company over that journey.

Good records are essential, at least to me - with a record of everything I rated over the years I can test out 'what if' ideas, which I could not do otherwise. I can check back to see if what I did was any good - don't rely on how you think things are going, our minds play tricks, there is nothing like a simple spreadsheet to show you if an idea was profitable or not.

Learn your limits - know how much work you can sustain, there is no point working 6 hours a day at something for a month then giving it up as you find you cannot sustain that level of effort.

Not so much changes, there is a bit about evolution there though - program, learn to check how things went, check the data, improve the data, practise analysing the data until you can look, effectively, for patterns to inform future efforts.

Dave
 
I kind of assume that if all TF and RP (HRB is basically the same as RP) times agree then they're probably correct. Rail moves from the BHA sleepy weasel department, that only leaves standard times.
The data is the same for both Timeform and the Racing Post, the critical difference between the two, when the Timeform race readers work on each race they have a stopwatch in one hand, The Racing Post doesn't bother it just wishful thinking along with a big bag of salt.

Mike.
 
Well really davejb davejb did i not threaten to buy a stop watch. On a more serious note its always a pleasure to interact with you and i promise not to mention Wonky Rails for the next 58.70 secs. :eek:
 
a big bag of salt.
or a big bag of Sh----------- is the impression that I sometimes get from the posts about that publication

Good post davejb davejb - there are plenty of dead end and false trails that simply have to be personally explored and as you say sheer doggedness is required to see the project to any point of success. It is a trait of successful people that even when presented the solution we still need to dig under the bonnet to find out why it works and more importantly how can it be improved , unfortunately this process never ends , every success is just a staging point, but the desire to improve breeds continued success.
 
Report for : 26/04/2021
Flat Handicaps
Raw ratings: 6/33 Odds: 1.38 10.0 2.25 2.5 25.0 25.0 (Return: 72.13)
Mkt filter 3/18 Odds: 1.38 2.25 2.5 (Return: 9.13)

Flat Non - Handicaps
Raw ratings 4/15 Odds: 5.0 1.25 0.73 0.73 (Return: 11.71)
Mkt filter 4/6 Odds: 5.0 1.25 0.73 0.73 (Return: 11.71)

NH Handicaps
Raw ratings: 0/0 Odds: (Return: 0)
Mkt filter 0/0 Odds: (Return: 0)

NH Non - Handicaps
Raw ratings 0/0 Odds: (Return: 0)
Mkt filter 0/0 Odds: (Return: 0)

Total Out = 48 Total return (raw) = 83.84
Total wins: 10 / 48
List of winners:
Sou 14:20:00 Devious Angel (IRE) 6.0
Ayr 15:45:00 Dream With Me (IRE) 2.38
Win 16:50:00 Thegreyvtrain 11.0
Sou 17:05:00 Sociologist (FR) 3.25
Lin 17:15:00 Sayifyouwill 3.5
Win 17:20:00 Spring Is Sprung (FR) 2.25
Win 17:50:00 Stay Well 1.73
Thi 18:30:00 Manigordo (USA) 26.0
Thi 19:30:00 Malhoob (USA) 1.73
Thi 20:00:00 Key Look (IRE) 26.0

Amazing what a couple of 25/1 winners will do for the profit/loss figure, isn't it?

Today's picks went well, only two bets but the first of them won at 11/2. Monkfish was, I think, going to win as well - right up to the point where he rammed his way through the second last and knocked his stuffing out. He was a little behind the winner, Colreavy, at that point but going rather better and I was pretty confident..... Envoi Allen didn't manage to keep up over the last mile or so and was out of it when pulling up.

I'll take an 11/2 winner instead of an 11/10 one any day....Monkfish actually went off 10/11, but I had 11/10 which sounded better :))
Lottie Marie was the 89th winner since the picks started, from 241 selections, giving a win rate of a bit under 37% (as in 36.98 or so) which appears to be holding - the win rate has been 36-37% for the past month. Profit remains around the high teens, this does bounce around a bit but it's sitting at 18 or 19% and has done for some time.

Tomorrow is a busy day:
1619550010686.png
Dave
 

Attachments

  • 28_apr_full.xlsx
    76.8 KB · Views: 0
Report for : 27/04/2021
Flat Handicaps
Raw ratings: 6/25 Odds: 2.0 2.0 4.0 4.5 5.5 3.0 (Return: 27.0)
Mkt filter 3/11 Odds: 2.0 4.0 5.5 (Return: 14.5)

Flat Non - Handicaps
Raw ratings 5/9 Odds: 0.25 1.63 1.1 9.0 0.11 (Return: 17.09)
Mkt filter 4/6 Odds: 0.25 1.63 1.1 0.11 (Return: 7.09)

NH Handicaps
Raw ratings: 0/1 Odds: (Return: 0)
Mkt filter 0/1 Odds: (Return: 0)

NH Non - Handicaps
Raw ratings 1/5 Odds: 1.2 (Return: 2.2)
Mkt filter 1/2 Odds: 1.2 (Return: 2.2)

Total Out = 40 Total return (raw) = 46.29
Total wins: 12 / 40
List of winners:
Yar 13:00:00 Silver Gunn (IRE) 3.0
Yar 13:35:00 Restitution (FR) 1.25
Yar 14:10:00 Pactolus (IRE) 3.0
Not 14:20:00 Sir Rumi (IRE) 2.63
Yar 14:40:00 Moorbik 2.1
Not 14:50:00 Roman Mist (IRE) 5.0
Not 15:55:00 La Lune 10.0
Bri 16:40:00 Kendergarten Kop (IRE) 5.5
Lin 18:20:00 Lottie Marie 6.5
Lin 18:50:00 General Zoff 4.0
Ayr 19:15:00 Noman (IRE) 1.11
Pun 17:25:00 Chacun Pour Soi (FR) 2.2

Nice to be up again.

Today's picks - only one winner, at 2/1, so a loss of 3pts on the day sadly. A couple of them ran quite well, Bezza's Lad almost did the business, which would have edged us into profit by 2.5 points instead of 3 down, but he went down by 3/4 lengths.

Tomorrow is a real make or break looking day - unless some end up as NR's or well odds on there are 12 of them (yes, it is rather a lot, isn't it?) Personally I'm still betting only a small amount on each, I am very much waiting to see if things keep going okay as the flat starts producing selections, so I can handle a dozen but it's a good reason to bet well within a comfortable limit - if I had £100 on each one I'm not sure I'd be as philosophical about potentially losing £1200 on what is meant to be a hobby. I'm one of those folk who looks at the downside rather than praying for the upside. Here we go then:
1619642869695.png

There's no special thing about Mighty Power, I just had that cell highlighted as I took the screenshot.
There are 3 sprints at 6f, the sprints definitely owe us a winner now, and on previous 'form' there ought to be 4 winners there..... let's hope there are, and they aren't all even money.

Dave
 

Attachments

  • 29_apr_full.xlsx
    79.7 KB · Views: 1
Report for : 28/04/2021
Flat Handicaps
Raw ratings: 4/31 Odds: 1.25 1.75 5.5 2.0 (Return: 14.5)
Mkt filter 4/17 Odds: 1.25 1.75 5.5 2.0 (Return: 14.5)

Flat Non - Handicaps
Raw ratings 2/11 Odds: 0.8 1.0 (Return: 3.8)
Mkt filter 1/5 Odds: 0.8 (Return: 1.8)

NH Handicaps
Raw ratings: 0/3 Odds: (Return: 0)
Mkt filter 0/2 Odds: (Return: 0)

NH Non - Handicaps
Raw ratings 0/6 Odds: (Return: 0)
Mkt filter 0/0 Odds: (Return: 0)

Total Out = 51 Total return (raw) = 18.3
Total wins: 6 / 51
List of winners:
Pon 16:25:00 Bergerac (IRE) 2.25
Pon 17:00:00 King Frankel (IRE) 1.8
Pon 17:30:00 Soul Seeker (IRE) 2.75
Bri 18:20:00 Excel Power (IRE) 2.0
Che 18:40:00 Araifjan 6.5
Che 19:15:00 Glint Of An Eye (IRE) 3.0

Well, only three winners from the 12, and they came in at 11/4, 2/5, and 6/4 - I actually skipped the 2/5 shot as usual and got 11/4 and 9/4 but it's still a loss of knocking 4 pts, taken at SP it's more like 4.4 pts down. Still, into every life a little rain must fall, and we're still betting with bookies' money so onward and upward....

picks tomorrow - thank goodness not another dozen -

1619723474741.png

As can be seen, mostly NH bets.
Dave
 

Attachments

  • 30_apr_full.xlsx
    80.7 KB · Views: 6
Report for : 29/04/2021
Flat Handicaps
Raw ratings: 6/25 Odds: 2.75 3.5 12.0 4.5 6.5 1.5 (Return: 36.75)
Mkt filter 4/16 Odds: 2.75 3.5 4.5 1.5 (Return: 16.25)

Flat Non - Handicaps
Raw ratings 2/12 Odds: 4.0 1.38 (Return: 7.38)
Mkt filter 2/4 Odds: 4.0 1.38 (Return: 7.38)

NH Handicaps
Raw ratings: 0/3 Odds: (Return: 0)
Mkt filter 0/2 Odds: (Return: 0)

NH Non - Handicaps
Raw ratings 1/5 Odds: 0.4 (Return: 1.4)
Mkt filter 1/2 Odds: 0.4 (Return: 1.4)

Total Out = 45 Total return (raw) = 45.53
Total wins: 9 / 45
List of winners:
Red 13:40:00 Black Hill Storm (IRE) 5.0
Lin 14:00:00 Mighty Power (IRE) 3.75
Mus 14:50:00 Perfect Soldier (IRE) 4.5
Lin 15:00:00 Lethal Blast 13.0
Mus 15:25:00 Cool Spirit 5.5
Red 17:00:00 Greystoke 7.5
Sou 17:50:00 Moneykenny (IRE) 2.38
Che 19:45:00 The Bay Warrior (IRE) 2.5
Pun 18:35:00 Energumene (FR) 1.4

53p profit, crikey, pass the wine list and I'll order up the champers....

Picks had another lousy day - 1 NR, 1 winner at 4/7, I got 4/6 which, frankly, made little difference! 3 losers at Cheltenham, luckily I backed Splash of Verve each way - the horse came 4th at 20/1, which had me cursing until I checked my Betfair account and found 1/5 odds to 4 places (yippee!) - that gave me a 'sort of' 6/4 winner equivalent and reduced the loss to less than 1pt on the day. We still need a good day though.

I bet on Splash EW because at the time of betting the odds were 18/1, and I've noticed a few of the long odds picks managing to pick up a place, so while I might not back all of them EW in future it is something I will consider on a case by case basis.

Tomorrow -
Punchestown16:00:00StksNH H106111111Quilixios***8 of 9

That's it I'm afraid, just the one, probably no better than 6/4 fav at that.

I'll watch the 2000 gns without having a bet on it, to be honest nothing in the field strikes me as exciting and I think the one(s) I most fancy have a bit of an intertwined muddle of form around them = my ratings have picked Naval Crown, who I really don't think is a likely winner (famous last words etc) and I quite like Chindit for no good reason, while I wouldn't discount APO'B's runners even if they don't look all that likely either. Ho hum, it'll all look a lot clearer 24 hours from now no doubt! I am SO glad I don't do this for a living....

Dave
 

Attachments

  • 01_may_full.xlsx
    101.8 KB · Views: 4
'my ratings have picked Naval Crown, who I really don't think is a likely winner (famous last words etc)'

Would have been famous last words, but at 50/1 I thought - sod it, so I put a very small EW bet on... after all, I couldn't see any real standouts in the field. Betfair, 50/1, 1/5 odds to 4 places.... yippee, +4.5. That's two days on the trot I've had an EW bets that has been paid on getting 4th place, I'm starting to like it!

Now, if Quilixious can win (7/4 earlier) that'll make a nice finale for the afternoon.
Dave
 
Report for : 30/04/2021
Flat Handicaps
Raw ratings: 2/22 Odds: 4.5 3.33 (Return: 9.83)
Mkt filter 0/12 Odds: (Return: 0)

Flat Non - Handicaps
Raw ratings 2/8 Odds: 1.88 1.63 (Return: 5.51)
Mkt filter 1/5 Odds: 1.63 (Return: 2.63)

NH Handicaps
Raw ratings: 0/3 Odds: (Return: 0)
Mkt filter 0/2 Odds: (Return: 0)

NH Non - Handicaps
Raw ratings 3/13 Odds: 1.0 0.57 0.29 (Return: 4.86)
Mkt filter 3/5 Odds: 1.0 0.57 0.29 (Return: 4.86)

Total Out = 46 Total return (raw) = 20.2
Total wins: 7 / 46
List of winners:
Goo 13:35:00 Canonized 2.88
Che 13:50:00 Zillion (IRE) 5.5
Mus 14:30:00 Let Me Be (IRE) 4.33
Goo 14:45:00 Alpinista 2.63
Pun 15:40:00 Rewritetherules (IRE) 2.0
Pun 17:25:00 Honeysuckle 1.57
Che 19:15:00 Highway Jewel (IRE) 1.2

Nothing to write home about there.
Today's single pick lost - c'est la vie. This has ended a pretty poor week all round, barring Tuesday. No picks for tomorrow, let's hope things pick up - the end of jumping has been particularly poor, probably down to soft going ratings finding drier ground I imagine.

My ratings suggest Sacred for the 1000 gns tomorrow, depending on the odds I might conceivably try for the jammy dodger award, 2021, with another tiny tiny bet.

Dave
 

Attachments

  • 02_may.xlsx
    52.4 KB · Views: 4
Back
Top