Excel Blackjack Monte Carlo Simulator with VBA Macro Code
The Excel Blackjack Monte Carlo Simulator was built off the back of Excel Blackjack. I took the guts of the blackjack program and rebuilt them as a simulator.
The program is pretty simple and straightforward to use:
- Set your strategy on the Strategy Card tab (by default it is set to basic strategy)
- Select Number of Decks
- Choose Starting Bankroll
- Choose number of Hands to Simulate
- Click Simulate button to begin simulation
As far as Blackjack Monte Carlo simulators go, it’s pretty basic but it will allow you to test out different strategies. Right now, there’s no way simulate card counting and changing bet size, but I would love to add more features in the future.
One cool feature I added is a progress bar. The simulator can take a while to run if you are simulating a lot of hands. The progress bar will show the percent complete and let’s you know that the program is working and not frozen.
Also check out Excel Blackjack with VBA Macro Code
Excel Workbook with playable game and full access to the VBA macro code.