Excel formula needed

AlisonHarrison

Not sure whether to post this on techy board orgambling. I will try this one first.

I am trying to test a roulette system and am looking for anexcel formula.

The system is the reverse Labouchere and is as follows:

Write down

1

2

3

4

Your first stake is 1 + 4

If you win you add the stake to the bottom of the line soyour line is

1

2

3

4

5

Your next stake is 1 + 5. You win again.

Your line becomes

1

2

3

4

5

6

You stake 1 + 6 (7)

This time you lose.

So you score off 1 and 6.

Your next stake is 2 + 5.

Etc.

Once you have scored off all of the numbers you startanother line.

Can anyone give me a formula for this?

WTFH

Excel can work things out, but you need to provide more information...
What is the probability of winning? at each round?

paddyrg

It's a roulette system, so 1/37 I guess.

However it is also worth pointing out that a staking system does nothing to affect the fact the house odds are ALWAYS mechanically against the gambler.

If the OP is excited by the results from 'Thirteen against the Bank', it's mathematically demonstrated to be a great bit of stroytelling but utter (roulette) balls.

AlisonHarrison

Its black or red. So 50:50 (ignoring 0)
I just want a formula to calculate the system so that I can put various permutations of black/red etc in, so the odds shouldn't really come into it.

Cornucopia

As stated, it looks too complex for Excel formulae. You may need to program it (Excel macro or something similar).

WTFH

But are 1,2,3 & 4 the values of the bets?

And how much do you win if you win?

WTFH

AlisonHarrison wrote: »

Its black or red. So 50:50 (ignoring 0)
I just want a formula to calculate the system so that I can put various permutations of black/red etc in, so the odds shouldn't really come into it.

1. You can't ignore 0
2. If you choose to ignore 0, then the probability of winning at each hand is 50%.
3. Odds and probability are what it all comes down to.

WTFH

OK, let's break it down...
The odds of winning any one round are 18/37 or 0.486.

So, if you have 1,2,3 &4 as your bets, the likelihood is you will arrive with £10 and leave with £4.86, based on 100% return.
You can break it down whatever way you like, but it doesn't change the maths.

Cornucopia

Based on averages, yes, but what the OP wants is a system that will play this out, round by round.

http://www.joecainey.co.uk/gambling/

This website explains it in more detail, and says that it doesn't work.

Blackbeard_of_Perranporth

I suggest OP reads The man who broke the bank at Monte Carlo.

Blackbeard_of_Perranporth

Cornucopia wrote: »

Based on averages, yes, but what the OP wants is a system that will play this out, round by round.

http://www.joecainey.co.uk/gambling/

This website explains it in more detail, and says that it doesn't work.

Pure statistics says the the odds in the first game are 1 in 37.

They are the same in the second game, the third and the fourth ad infinitim, they do not change.

The reason for this, is the ball is placed in the same spinning disc every game. It is a game of chance, designed to let the punter loose their money.

Of course, the gambling site may offer a different opinion.