Excel worksheet needed for coin toss

V

virtualmoney

I was wondering if a simple excel worksheet can be created to project the effects of applying different types of betting progressions to a user defined number of coin flip simulations.

The user input a certain amount of capital and he begins with a bet of x% of this capital with a user defined progression set in the simulator, for example
bet ratio 1-2-2-4-2-1 restarting at 1 at any stage if it is a win, and also switching the bet to the opposite side (H or T) at the next throw whenever it is a win but following the progression set on the same side (H or T) if it is a loss.

I am interested to find out what are the maximum number of bets various progressions can enable the betting to go on before implosion, and create some statistics for different sample sizes of each type of progression(user defined).

I would appreciate if anyone can help to create and post this excel worksheet. Thanks.
 
Quote from virtualmoney:

The user input a certain amount of capital and he begins with a bet of x% of this capital with a user defined progression set in the simulator, for example
bet ratio 1-2-2-4-2-1 restarting at 1 at any stage if it is a win, and also switching the bet to the opposite side (H or T) at the next throw whenever it is a win but following the progression set on the same side (H or T) if it is a loss.
More...
Let me get this straight:
$10,000 initial capital
5% bet size
Bet $500 Heads, result Heads
Bet $1000 Tails, result Tails
Bet $1000 Heads, result Tails
Bet $2000 Heads, result Tails
Bet $1000 Heads, result Heads

When does the progression restart to the beginning ?
I don't quite "get it".
 
Quote from syswizard:
Let me get this straight:
$10,000 initial capital
5% bet size
Bet $500 Heads, result Heads
Bet $1000 Tails, result Tails
Bet $1000 Heads, result Tails
Bet $2000 Heads, result Tails
Bet $1000 Heads, result Heads
When does the progression restart to the beginning ?
I don't quite "get it".
More...

follow progression only if it is a loss, if it's a win, go back to 1
 
Quote from virtualmoney:

I was wondering if a simple excel worksheet...
More...
I have done it a while ago. I pretended red and black (of the roulette game), or head and tail, are all numbers inferior to 0.5 vs all numbers equal or superior to 0.5. Then I used excel's "rand" function, and produced about 65,000 random numbers.

What came out is that it doesn't make sense to be on red after a few straight blacks, nor of course to bet on head after a few tails. As an example, in all 65000 tests, there were a few sequences of 10 straight red (in my case numbers < 0.5), and after those the ensuing numbers were half red and half black.
 
Quote from travis:

I have done it a while ago. I pretended red and black (of the roulette game), or head and tail, are all numbers inferior to 0.5 vs all numbers equal or superior to 0.5. Then I used excel's "rand" function, and produced about 65,000 random numbers.

What came out is that it doesn't make sense to be on red after a few straight blacks, nor of course to bet on head after a few tails. As an example, in all 65000 tests, there were a few sequences of 10 straight red (in my case numbers < 0.5), and after those the ensuing numbers were half red and half black.
More...

Why would you use .5 if you were trying to model a roulette wheel?
 
Quote from stevegee58:

What's the most you ever lost on a coin toss?
More...

I get it Steve. Good one. Let's hope he doesn't 'just put it back in his pocket with all the other coins'.
 
You must log in or register to reply here.
Back
Top