Simple yet effective and powerful simulation in Excel or
In python with HTML reporting interface.
Customizable interface to simulation
Statistical results captured
Project is a computer simulation to play a million events of a simple game. Each event consists of drawing a ticket from a hat that contains 3 winning tickets and 2 losing tickets. And for each event a bet is made. Begin with a bet of $1000. If a winning ticket is drawn, increase the next bet by $5, and if a losing ticket is drawn, decrease the bet by $8. And continue this way for all bets of $1000 or higher. For all bets that fall below $1000, (which will happen if more losing tickets have been drawn), the amount to be decreased is different. On bets of less than $1000, if a winning ticket is drawn, increase the next bet by $5, and if a losing ticket is drawn, decrease the next bet by $7. The purpose in playing this betting strategy a million times is not so much to determine whether it will win or lose at this game in the long run, but rather to get a STATISTICAL PRINTOUT of the number of wins and losses at every amount bet. One final thing: In the statistical printout, I need to know the amount of the last (the millionth) bet made in every run of a million events.