Solutions
August 2023 / VBA Excel / Dashboards
Betting strategies and winning probabilities based on occurrence simulations applied to the Roulette Martingale method.
The Martingale system is the most popular and commonly used roulette strategy. The concept behind it is pretty simple – you increase your bet after every loss, so when you eventually win, you get your lost money back and start betting with the initial amount again..
In theory, you can go on like this forever, doubling up after every loss and earning a small profit after every win. The harsh reality, however, is that there are many factors that are likely to screw over your perfect system and make you lose a lot of money.
This solution programmed in Excel, with VBA support in the background, allows you to parameterize when to enter and exit the game based on the different occurrences and iterations of black and red color, and to calculate the expected profit or loss from random sequences of numbers that are obtained by pressing a simple button.