Can excel create this type of coin toss simulator?
 

Hi all,

appreciate if anyone can create this excel spreadsheet simulation:

User input:

T= Total number of tosses, e.g. T=1000

W=Winning probability% of each toss e.g. 0.5 (= fair)

N = number of latest tosses without the occurrence of 2 consecutive Heads or Tails e.g, N=7

e.g, For bets on Heads (vice-versa for Tails),

If there is No occurrence of 2 Consecutive Heads within the last N=7 tosses, then on the next appearance of a Head (could be one or more tosses after N), place first bet 1 on the next toss on Heads.

If Heads appears on next toss, +1 is added to Balance Total(cycle ends), otherwise, 1 is subtracted.
If Tails subsequently continues to appear, do not place next bet until the next Head appears.

When that Heads appears, place bet 2 on the next toss on Heads.
If Heads appears on next toss, +2 is added to Balance Total(cycle ends), otherwise, 2 is subtracted.
If Tails subsequently continues to appear, do not place next bet until the next Head appears.

When that Heads appears, place bet 4 on the next toss on Heads.
If Heads appears on next toss, +4 is added to Balance Total, otherwise, 4 is subtracted.
CYCLE ENDs here regardless it is a win or loss.(SAFER martingale)

Wait for the next Non-occurrence of 2 Consecutive Heads or Tails within the latest N=7draws to start the new cycle.

Plot Balance Total chart over T number of tosses.

Thanks,
Scalpmaster