The probability of seeing the same color appear on successive spins just over halves from one spin to the next.

Random Spins Win or loss -> I would then want it to cut and paste the 8 and 9 to the next columnģ Loss Random Spins (1) Win or loss Random Spins (2) Win or lossĤ) Then I want it to repeat the process with the numbers that were pasted to the next column (winning numbers would start back at the winning numbers for bet 1)ĥ) I then will have it organized in a way in which I will be able to count consecutive losses which I will write a separate macro for. Example: The probability of the same color showing up 6 times in a row on an American roulette wheel is 1.13. Repeat this process until a win occurs.ģ) When a win occurs cut and paste all numbers below the winning number to the next column, starting back at the top row This is my thought on how to accomplish this, but I don't know how to write a macro to make it happen:ġ) Generate 10,000 random numbers from 1-38 down a column (already completed)Ģ) Start at the first number and identify if it is a win or loss. So if I lost the first 2 bets and then won on the third bet I want it to identify the win and then start over at bet 1 for the remaining 9,997 numbers. I have a series of consecutive bets that I would make, and the goal is to continue on this series until a win occurs and then start a second series and so on. I generated 10,000 random numbers from 1-38 which are my simulated spins. On roulette (betting red or black), I recommend going for at least 5 or 6 consecutive wins with this strategy or it loses most of its power. I'm pretty new to VBA, and can't seem to figure out a method to simulate wins or losses for roulette spins.

8 consecutive losses roulette