Thought Process For new bot

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
MemphisFlash
Posts: 2128
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Thought i would share an image of my thought process for a new bot.
what i am hoping for this to present to me is a guardian bot, that will dutch the fav and 2nd fav in horses races
but only if the predicted profit of the 2 runners is greater than the stake i place.
I have the bot running and testing at the minute.
I am only using excel for my calcs. they have been transferred to the guarding bot.

Capture.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
MemphisFlash
Posts: 2128
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Not a bad day with this

Capture.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

MemphisFlash wrote:
Sun Apr 03, 2022 12:38 pm
what i am hoping for this to present to me is a guardian bot, that will dutch the fav and 2nd fav in horses races
but only if the predicted profit of the 2 runners is greater than the stake i place.
Image

I might be wrong here as it's been a while, but when dutching, you have to tally up the odds and represent as book% to calculate your return, you can't average out the odds by simply summing and dividing by number of members - just isn't correct.

so for example, the 1st entry in your spreadsheet (3.25, 4.3) comes out to a book% of approx 54.01% => ([100/3.25 = 30.76] + [100/4.3 = 23.25]).
The dutched odds (average odds in your sheet) is actually 1.85 (100/54.01). This would mean that your £10 stake would return a p&l of £8.50.
So, in order to return a profit that is >= stake, the combined book% must be <= 50.

here are the values for a few of the others from your sheet:
(1st fav odds, 2nd fav odds, dutched odds, book%, return on £10)

2.58, 4.7, 1.66, 60.03, 6.65
3.25, 3.3, 1.64, 61.07, 6.37
....
2.78, 5.0, 1.78, 55.97, 7.86
2.48, 3.8, 1.50, 66.63, 5.00

Hope this helps with thinking about the viability of profit based on staking - it still looks not too bad ;).
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

jimibt wrote:
Wed Apr 06, 2022 3:35 pm
Hope this helps with thinking about the viability of profit based on staking - it still looks not too bad ;).
I never take anything at face value...and it seems you're right. ;)
Screenshot_9.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

ShaunWhite wrote:
Thu Apr 07, 2022 9:54 pm
jimibt wrote:
Wed Apr 06, 2022 3:35 pm
Hope this helps with thinking about the viability of profit based on staking - it still looks not too bad ;).
I never take anything at face value...and it seems you're right. ;)
Screenshot_9.jpg
belt 'n braces :D

it is definitely a well misunderstood calculation (dutching) and one that can make you think you've found your strategy nirvana until you step back and reassess the calcs... story of my life when doing BF!!

hope all well with you - have ditched straight spot crypto and am now doing leveraged futures on crypto. all makes sense now. when doing spot crypto i always seemed to reabsorb any profits back into my bank. with clearly defined strategies on leverage, it's pretty much the same ball game as here (sports trading) with the ability to hedge in either direction. the beauty tho is that you don't have the overhead imposed of having to seed the market in the same way that laying does. will catch up proper soon!!
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Crypto is a step too far to me, I've got too many interests and not enough years so it hasn't made the edit.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

ShaunWhite wrote:
Fri Apr 08, 2022 2:05 pm
Crypto is a step too far to me, I've got too many interests and not enough years so it hasn't made the edit.
i get what you're saying. i guess i just got pulled in by the clamour[sic] of it all. tbh, i find it on par with BF, maybe on occassion, actually easier. that said, the market will mature and industialised bots (even tho present in the space already), will make it more difficult to score. for now tho, we're fine.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

jimibt wrote:
Fri Apr 08, 2022 3:01 pm
ShaunWhite wrote:
Fri Apr 08, 2022 2:05 pm
Crypto is a step too far to me, I've got too many interests and not enough years so it hasn't made the edit.
i get what you're saying. i guess i just got pulled in by the clamour[sic] of it all. tbh, i find it on par with BF, maybe on occassion, actually easier. that said, the market will mature and industialised bots (even tho present in the space already), will make it more difficult to score. for now tho, we're fine.
My son's been trying to convert me but I'll leave that playground to him. S'funny cos I've not talked to him about trading much at all but he's already been saying a lot of sensible things about backfitting and the long view....but I'm glad he's got a good job on the spanners rather than getting carried away with pipedreams. Basic Maslow hierarchy init, nail the essentials and then work on the rest of the pyramid.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

..... Sorry Memphis, me and Jim should probably just shoot the breeze somewhere else.
User avatar
Crazyskier
Posts: 1157
Joined: Sat Feb 06, 2016 6:36 pm

ShaunWhite wrote:
Fri Apr 08, 2022 3:12 pm
jimibt wrote:
Fri Apr 08, 2022 3:01 pm
ShaunWhite wrote:
Fri Apr 08, 2022 2:05 pm
Crypto is a step too far to me, I've got too many interests and not enough years so it hasn't made the edit.
i get what you're saying. i guess i just got pulled in by the clamour[sic] of it all. tbh, i find it on par with BF, maybe on occassion, actually easier. that said, the market will mature and industialised bots (even tho present in the space already), will make it more difficult to score. for now tho, we're fine.
My son's been trying to convert me but I'll leave that playground to him. S'funny cos I've not talked to him about trading much at all but he's already been saying a lot of sensible things about backfitting and the long view....but I'm glad he's got a good job on the spanners rather than getting carried away with pipedreams. Basic Maslow hierarchy init, nail the essentials and then work on the rest of the pyramid.
The Maslow's bit took me back 30 years to my Psych combined-honours degree at Uni. The principle is still as true as ever though.

CS
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”