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 what you getting done in Turkey?
Teeth, hair transplant, tummy tuck and a face lift
-
@John-Folan what you getting done in Turkey?
-
@Joseph-Henderson said in John’s Horse Trading Resources:
@John-Folan how are the overall results looking for the dobs and trobs? Think I started testing the dobs at an unfortunate time last couple of months!! Trobs still well up thanks to April and May.
June was the month that did me although not as much as the software for some reason. Probably fine lines on the odds range.
Sorry I've not been around much. Loads of stuff going on personally and I'm off to Turkey for two weeks now. Back on it properly from September
-
@John-Folan how are the overall results looking for the dobs and trobs? Think I started testing the dobs at an unfortunate time last couple of months!! Trobs still well up thanks to April and May.
-
@Martin Yeah, youd think. Having looked into it further now it seems as though you need to transfer a file from your old computer to new one to retain settings and automations. Tough ask when you cant turn it on! Luckily nothing too complex and I think Ive remembered most set ups but Ill be saving the bots to cloud next time...Next challenge...stopping gaming on my new set up and re focusing on paying for my flash purchase
-
@Tony-Hastie that really sucks! You think they would be saved to your profile
-
Gutted. My bots were coming along nicely....then the laptop died. Apart from suffering massive withdrawls while waiting 4 days for the new one I think Ive lost ALL my bots after installing the bet angel software
-
@Joseph-Henderson said in John’s Horse Trading Resources:
@John-Folan hi John. Would you be able to share you latest results table for the DOBS and TROBS that is included at the top of this thread? Cheers
Will do at the end of the month matey. Sorry been busy for a few days.
-
@John-Folan hi John. Would you be able to share you latest results table for the DOBS and TROBS that is included at the top of this thread? Cheers
-
@Tony-Hastie said in John’s Horse Trading Resources:
@John-Folan How are those L2B bots going?
Ive set mine up to take the 12 ticks...as well as a time green up acting as a kind of stop loss. My 7f bot is currently performing well, greening up at 70 seconds. Most of these are hitting the 12 ticks so probably down to selection(good thing right!)
My 1m3f to 1m6f bot is also performing well, greening up a 2min 15 seconds
Everything else under 2m1f is going ok but probably needs adjustment. 2m1f+ is struggling big time so a lot of work to do there. Which is taking ages as I find my self being home, turning the bots off and going full stakes on the selections. Just cant resist
Alright actually. I’m tweaking exit times. Will do a full breakdown in a couple of weeks
-
-
@John-Folan How are those L2B bots going?
Ive set mine up to take the 12 ticks...as well as a time green up acting as a kind of stop loss. My 7f bot is currently performing well, greening up at 70 seconds. Most of these are hitting the 12 ticks so probably down to selection(good thing right!)
My 1m3f to 1m6f bot is also performing well, greening up a 2min 15 seconds
Everything else under 2m1f is going ok but probably needs adjustment. 2m1f+ is struggling big time so a lot of work to do there. Which is taking ages as I find my self being home, turning the bots off and going full stakes on the selections. Just cant resist
-
Not bad yesterday either
-
@Tony-Hastie said in John’s Horse Trading Resources:
@John-Folan Good winner with Law of Average yesterday to kick off this month though
Was a cracker
-
@John-Folan Good winner with Law of Average yesterday to kick off this month though
-
Losing month. Not a disaster as gave back profit.
-
Break even the last few days
-
@John-Folan Gotta love the horse racing variance! Been a bit of a pants 3 or 4 days. Then yesterday... 3 trades, 3 winners. Win point making the week a good one after just 1 day...
-
Better today