In my last post, I showed you
how to create a roulette simulator in excel.
In this post, I'll show you how to do a simple of track your wins, losses and bank for a level staking plan (bet the same flat amount every time). In a future post we'll make it a little more advanced.
The following screenshot shows you what we're looking to generate.
This allows us to see the wins, losses and bank for a Red/Black betting strategy against our roulette simulator (btw, betting red/black blindly is a good way of losing money, see my post
on true odds of roulette).
1) The first 2 columns are generated by our roulette simulator, please see
how to create a roulette simulator in excel to show you how to generate those two columns. Alternatively you can manually type in your own values (or copy and paste them in) if you want to track your bank against actual results instead of randomly generated ones.
2) The 3rd Column (Bet) - this is your prediction, just enter in Red or Black (i've bet red for every row). Enter Red in cell C3.
3) The 4th column (stake) - this is a level staking plan, e.g. bet $10 every time. Enter 10 in cell D3
4) The 5th column (win) - this tells you if your prediction won or not. type in the following formula in Cell E3
=IF(C3=B3, "Win", "Loss")
B2 has the result of the random number generator, C3 has your prediction. (The letter is the column, the number is the row)
5) The 6th column (bank) - is your bank. In cell F2, enter your start bank (1000 in my case) And for cell F3, enter the following formula
=IF(E3="Win",F2+D3,F2-D3)
This basically means, if the result in E3 (Win column) is Win, then you add your winnings to your previous bank (D3 is stake, F2 is previous bank). if it's not a win, then minus your stake (D3) from your previous bank F2.
6) And now do the draggy copy with each row down the excel sheet, to do this for multiple rows. Excel will automatically update the formula cells as you drag and copy.
This is pretty simple. At the moment only works for red/black. but can be easily modified for other betting strategies.
In a future posts
- will show you how to use excel to track your current bank and final bank etc.
- will test stupid plans such as martingale and reverse martingale
If you're interested in track streak, you could combine the technique in the
how to track streaks in excel, to see your winning streaks or streaks of red/black results
Hope you have fun playing with this. Feel free to drag a million rows :). See what happens to your bank. BTW, you will see that the casino always has the edge (should correlate with the true odds after a while)
UPDATE
I've now included a copy of the Roulette Level Staking Plan simulator for Excel in my dropbox here:
(please note the simulator doesn't handle half bet returns on zero and only does red or black. the point of the simulator is to disprove strategies hence why i haven't put time onto this yet).
hope this helps
