Roullete betting strategy.xlsm
I have gone as far as I think I can on formulas alone and don't know enough about macros to do the following. The whole point of this is to analyze progressive betting roulette strategies. If my steps are not clear, or even possible, please let me know thank you in advance.
Macro steps
instert random number between 0 and 37 into Spins sheet, number row
consult row 158 of appropriate spin column, adjust current money, D162 appropriately
If it was a win, take below detailed cease macro steps
If it was a loss,
Subtract loosings, row 158 of appropriate column from current money, D162
Adjust all bets on the table (in Bets sheet)by the appropriate amount in row 9,
example, if spin 8 was a loss, consult increase previous bet value
under spin 9 prior conducting the random number for spin 9
Macro will run continously for 50 spins unless,
Hit a winning number,
Not enough money to fully place next bets
Have hit max bet, Spins D160<D164
Ran through 50 spins without winning
Upon coming to a reason to cease the macro,
Fill in Summary sheet,
Column B, win, bust (from either not having enough money to cover
the next bet, or exceeding the table max bet, or not winning in 50 spins
Column C, How much money do I have left? Even if I bust I will most likely have a little left, unless the
previous bet required every last dollar
Column D, Which spin did I finally win on, leave blank if I went bust
IGNORE, I realized this could be done via formula!!! Column E, How much money did I win in this round, take into account additional rounds
should factor in total money from the previous round, not money over the starting money
example: I start with $1000, in round 1 I win $200 for a total of $1200,
in round 2 I win $300. Column E would state that $300 for round 2, not the entire
$500 winnings from all rounds
Column G, How much money was I down from the start of the round until I finally won
Column H I and have self explanatory headings
Column J is another one I realized could be fulfilled by formula
Bookmarks