Hi all, I need to test the below sequence of bets as if I'm using a fixed % of my bank.
Hence I need to add a single cell where I can enter a certain amount and the sheet runs all the bets in column A at odds of column B at a certain % of said a amount. So say I enter 100, the first bet is a 0.05x100 stake, the second one is 0.05x(100-5) and so on and at the same time I need the sheet to be able to add a winning stake (D5 and D14 in this case) to the sequence in recalculating my available balance in such cases.
There are probably other ways to test it I don't know, I'm open to suggestions.
This is the sheets and it's editable if someone can showme how to add those features:
work in progress as you are posting suggestions https://docs.google.com/spreadsheets...it?usp=sharing
How it looked originally:
https://docs.google.com/spreadsheets...it?usp=sharing