Martingale Revisited

Example spreadsheets and comments on example spreadsheets.
Post Reply
Dr Ginhog
Posts: 260
Joined: Wed Nov 03, 2010 12:10 am
Location: Ballygarvan,Cork Ireland T12D2VR
Contact:

Il be looking at Kelly. Im not familiar with it but saving the bank is everything so ill have a look.
User avatar
Derek27
Posts: 23666
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

doovd wrote:
Sun Jun 21, 2020 4:24 pm
Wow, Kelly lumped in with Martingale, that's a first. Clearly someone doesn't know what it is.
Not quite!

viewtopic.php?p=171416#p171416
User avatar
Derek27
Posts: 23666
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

I can't really make the Martingale any simpler than this. If you sit at a roulette table with £1023 and do a £1 Martingale on red/black/odds/evens, the probability of doubling your bank is:-

(1 - (19/37) ^ 10) ^ 1023 = 0.2711

Probability of doubling your money if you put the flipping lot on the table and take your chances are 0.4865.

The simple laws of probability state:-

1) if you punt odds less than the true chance of winning you are guaranteed to lose long-term.

2) the more you gamble the more you lose!
Dr Ginhog
Posts: 260
Joined: Wed Nov 03, 2010 12:10 am
Location: Ballygarvan,Cork Ireland T12D2VR
Contact:

Ok Im convinced Martingale can work as Ive seen the figures and I am going to modify my strategy to do another strategy and supply the sheet for all with the workings to prove how it can work. Be back tomorrow with that.
User avatar
ruthlessimon
Posts: 2094
Joined: Wed Mar 23, 2016 3:54 pm

I dunno what it's called, but I like staking by tick (i.e. every tick move I'll win/lose roughly the same amount, no matter the price).
LeTiss wrote:
Mon Nov 30, 2015 9:25 am
I've asked Peter many times to include 'Tick size with greening' on the dropdown staking plan, but for some reason he thinks it's a shit idea
Baffles me that it isn't a BA feature. Peter why's it shit for trading??? :)

A £400 stake @ 1.8 is totally different to a £400 stake @ 6.8

Let's assume I go for a back swing, lose 5 ticks (& hedge)

£400 @ 1.8 -> 1.85 = -£10.53 (-£2 per tick)
£400 @ 6.8 -> 7.8 = -£51.28 (-£10 per tick; ouch!)
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

ruthlessimon wrote:
Sun Jun 21, 2020 5:31 pm
Baffles me that it isn't a BA feature. :)
One "tick" is just an arbitary movement. If you want the same effect all over the card then you'd want the same PL for the same size change in implied chance. One tick movement on an odds on shot isn't the same probability change as one tick at 200/1 so it shouldn't be the same profit or loss......presumably. There's no reason why Betfair couldn't change the tick sizes tomorrow, or a different exchange might have different tick sizes, then where would you be?
User avatar
MemphisFlash
Posts: 2161
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

The Benefits Of Using Kelly Staking
Progress and bank balance will not be a smooth upward slope, and will be interrupted by frequent drawbacks (losing runs) but by using the fractional Kelly approach, volatility is greatly reduced, yet returns 3/4 of the compound return. For many gamblers, that is a price worth paying.
Why is a more conservative approached better? Using the Full Kelly, an average punter has about a 33% chance of seeing their bankroll cut in half before that bankroll will be doubled. Applying a more conservative approach, such as the Half Kelly, the average punter has about an 11% chance of seeing their bankroll cut in half before it they see it doubled.
User avatar
MemphisFlash
Posts: 2161
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

How To Make Your Own Kelly Calculator In Excel
Creating your own Kelly staking calculator in an Excel spreadsheet is fairly simple. Here's how you do it.
Step 1
Open a new Excel spreadsheet and create the following headers: Betting Bankroll, Kelly Staking Fraction, 1 (outcome 1), 2 (outcome 2), Odds 1, Odds 2, Probability of 1, Probability of 2, Kelly Stake 1 and Kelly Stake 2
Then click the centre align button to ensure all data is displayed in the centre of their cells.


Step 2
Enter both your current betting bankroll and your preferred Kelly staking fraction into the cells accordingly.

Step 3
Next enter the two possible outcomes for this market and the odds on offer for each outcome. In this example we are betting on the Asian Handicap in a Premier League match between Manchester City and Swansea.

Step 4
Next enter your assessed probability for each outcome occurring.

Step 5
Now we get down to the serious business. In cell I2 add the following formula:
=((((E2*G2)-1)/(E2-1))*A2)*B2
In this case...
E2 = odds for outcome 1
G2 = your assessed probability for outcome 1
A2 = your current betting bankroll
B2 = your preferred Kelly staking fraction

And in cell j2 add the following formula:
=((((F2*H2)-1)/(F2-1))*A2)*B2
In this case...
F2 = odds for outcome 2
H2 = your assessed probability for outcome 2
A2 = your current betting bankroll
B2 = your preferred Kelly staking fraction

You're done. The spreadsheet will now tell you how much to bet on any given market. (When the suggested Kelly Stake is less than 0, it means no bet is advised.)

In our example, the calculator is recommending we bet £59.56 of our £1000 bankroll on Manchester City -1 goal at odds of 1.85.
User avatar
MemphisFlash
Posts: 2161
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

kelly1.JPG
kelly2.JPG
You do not have the required permissions to view the files attached to this post.
User avatar
Derek27
Posts: 23666
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

MemphisFlash wrote:
Sun Jun 21, 2020 6:55 pm
The Benefits Of Using Kelly Staking
Progress and bank balance will not be a smooth upward slope, and will be interrupted by frequent drawbacks (losing runs) but by using the fractional Kelly approach, volatility is greatly reduced, yet returns 3/4 of the compound return. For many gamblers, that is a price worth paying.
Why is a more conservative approached better? Using the Full Kelly, an average punter has about a 33% chance of seeing their bankroll cut in half before that bankroll will be doubled. Applying a more conservative approach, such as the Half Kelly, the average punter has about an 11% chance of seeing their bankroll cut in half before it they see it doubled.
I thought you said the Kelly criterium is a strategy that takes you to the poor house?
User avatar
jamesedwards
Posts: 2323
Joined: Wed Nov 21, 2018 6:16 pm

grindhog wrote:
Sun Jun 21, 2020 5:23 pm
Ok Im convinced Martingale can work as Ive seen the figures and I am going to modify my strategy to do another strategy and supply the sheet for all with the workings to prove how it can work. Be back tomorrow with that.
The trouble with Martingale is the system leads you into a massive sense of security as for a while (often a long time) it will look like it's working. Then one day, one horrible day, wham bam and your bank is gone.

Some of the brightest and most experienced minds in market trading on here. I highly recommend you listen to them.
Last edited by jamesedwards on Sun Jun 21, 2020 9:21 pm, edited 1 time in total.
Atho55
Posts: 638
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

So in theory, if I have a probability, odds and bank. If I bolted the Kelly calculation onto it is it then possible to pass that value to a SV back into Guardian and use that SV as the stake?

Kelly.jpg
You do not have the required permissions to view the files attached to this post.
User avatar
ruthlessimon
Posts: 2094
Joined: Wed Mar 23, 2016 3:54 pm

ShaunWhite wrote:
Sun Jun 21, 2020 5:55 pm
One tick movement on an odds on shot isn't the same probability change as one tick at 200/1
"Gentlemen, showdown please" :D

Data was GbIe 2020Q1. I chose a random entry time, then looked at the price 10secs later.

Xaxis is price range (i.e. 1-2 = 1.0 - 2.0).
Yaxis is the chance of a move

Image

The market looks slightly less volatile on the higher prices, but the odds of a tick move in either direction is still around 50/50. It's never gonna be dead on 50%, but it looks pretty close to me. Averaged across the entire price series, comes out as 0%.
User avatar
jimibt
Posts: 3674
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

doovd wrote:
Sun Jun 21, 2020 4:24 pm
Wow, Kelly lumped in with Martingale, that's a first. Clearly someone doesn't know what it is.
(s)he's called MemphisFlask!!

[edit] -in fairness tho, (s)he did a quick google after their initial blanket reply and realised that there's some serious sh!t to be had by using Kelly -lol. live, learn, earn!!
User avatar
Derek27
Posts: 23666
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

jimibt wrote:
Sun Jun 21, 2020 8:44 pm
doovd wrote:
Sun Jun 21, 2020 4:24 pm
Wow, Kelly lumped in with Martingale, that's a first. Clearly someone doesn't know what it is.
(s)he's called MemphisFlask!!

[edit] -in fairness tho, (s)he did a quick google after their initial blanket reply and realised that there's some serious sh!t to be had by using Kelly -lol. live, learn, earn!!
Makes sense now, I thought it was a typo.
Post Reply

Return to “Bet Angel - Example spreadsheets”