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.