John’s Horse Trading Resources
-
A lot of stuff seems to go missing in the HRT, especially now it has livened up. I will post anything useful here. Links/files etc.
I will post the links etc in the first comment(this one. They will then be referenced in the relevant comment if applicable. Feel free to question away.
GENERAL RESOURCES
This calculation will work out your drawdown.
=MIN((Y2-MAX($Y$2:Y2))/MAX($Y$2:Y2),0)
You need to apply it to your running total column as I have done in the example below. Make your first row your starting bank. This then needs to be applied to the whole column.
This calculation will then show you your highest bank drawdown. It needs to be applied to the relevant column.
=MIN(AH:AH).
It will then give you a largest drawdown figure like this.
Courtesy of Martin Futter
Odds Probability Table to calculate odds against strike rate
https://www.isfa.com/odds-probability-chart.html
Courtesy of Matt Wood
If anyone uses google sheets and you have your filter S/R, then in the cell next to it put this:
=1/(E16/100)/100 (e16 being the cell with the % S/R)
Should auto calculate the odds required (not counting for commission)
Courtesy of Richard Latimer
Useful Trading Links
www.bettingtools.co.uk
www.aceodds.comEstimate Losing Runs
https://www.google.com/amp/s/thebetinvestor.com/guide/how-to-estimate-your-longest-losing-sequence/amp/HORSE SPECIFIC RESOURCES
Horse Software Tips
Always run two versions of your strategy. One called results with all your filters and one called qualifiers with variables like number of runners removed. You can then filter these manually or on your bot as they change a lot.The Original Maria Staking Thread from 2005.
Essential Horse Trading Links.
https://www.cheltenhambettingoffers.com/articles/glossary/
https://betfairtradingcommunity.com/en/blog/horse-racing-trading-ultimate-trading-start-guide
https://betfairtradingcommunity.com/en/trading-strategies
https://www.timeform.com/horse-racing (Information on the days racing and past results)
https://www.racingpost.com/non-runners/ (Going and non runners for the day)
Important Definitions for Inrunning trading
Dream maker 62’s LTB
My DOB/TROB rules
dr-dobs.json
dr-trobs.jsonBasically the same but the Dobs use a wider price range. Do either or both. They are both profitable.
-
@Martin said in John’s Horse Trading Resources:
@John-Folan my poor performing strategy this month bounced back in the rain which I don't think is a good thing!
This weather is driving me up the wall
-
@John-Folan my poor performing strategy this month bounced back in the rain which I don't think is a good thing!
-
@Martin said in John’s Horse Trading Resources:
@John-Folan said in John’s Horse Trading Resources:
Rain having its usual effect. -3 points
Soaked through this morning will you avoid it today?
Wish I had . Was -2 points. No selections yesterday. Gave back 5 points overall from both exit points the last few days.
Let’s see how the next few days roll
-
@John-Folan said in John’s Horse Trading Resources:
Rain having its usual effect. -3 points
Soaked through this morning will you avoid it today?
-
@John-Folan Had a good day yesterday....did I pick the sunny races to DOB in??
-
Rain having its usual effect. -3 points
-
@John-Folan we talked that up!
-
One point lost today. Crap strategy anyway
-
@John-Folan unreal matey nearly 20% ROI cannot get anywhere near that anywhere else!
-
@John-Folan yeah it's amazing to see the literal impact on strategies from Covid in the graphs, puts a lot more weight into it
-
@Martin said in John’s Horse Trading Resources:
@John-Folan the graph on that is unreal in the software! Great work
I’m over the moon tbh. These were great pre Covid and I was gutted they didn’t recover quickly. Guess I just needed to make like Gary Barlow and “Have a little patience”
Which coincidentally is one of my recommended trading songs
-
@John-Folan the graph on that is unreal in the software! Great work
-
@John-Folan A scratch day for my DOBs today. My big win was discipline. I spent the morning narrowing down the L2Bs to 10 possibles...and only traded 10 races, rather than trying to do all of them
-
Utterly ridiculous.
-
7 points to the good today. I think it’s time I dusted this photo off. It’s been a while but I think it’s deserved.
-
@Tony-Hastie said in John’s Horse Trading Resources:
@John-Folan out of interest, how many L2Bs would you normally get on in a day....if you had nothing else happening in life. I think Im trying to do to many and am making silly mistakes(yeah, following the wrong horse again!)
Varies to be honest but usually 5/6
-
@John-Folan out of interest, how many L2Bs would you normally get on in a day....if you had nothing else happening in life. I think Im trying to do to many and am making silly mistakes(yeah, following the wrong horse again!)
-
3/6 dobs and 2/3 trobs for 3 points profit
-
1/2 dobs and 1/1 trobs. Two points to the good