Hi Experts
I have made a staking plan, that works fine.
The one below is just an example.
The bank is in one cell (A3) and B1, B2, B3 are procentage of bank which changes when i change the bank.
B1= A3*5%, B2=A3*4,5%, B3=A3*4% ect.
What im missing is:
If bet 1 wins or loose then the bank should change (+/-) and change the procentage of the bank.
Bet 2 now changes to 4% of the new bank (based on value), and the stake should be 4% of 5100 insted of 4% of 5000
Hope it makes sence, but i cant figure out how to change it or the way to make the stake changing after each bet.
Hope you can help me.
I have made a staking plan, that works fine.
The one below is just an example.
The bank is in one cell (A3) and B1, B2, B3 are procentage of bank which changes when i change the bank.
B1= A3*5%, B2=A3*4,5%, B3=A3*4% ect.
What im missing is:
If bet 1 wins or loose then the bank should change (+/-) and change the procentage of the bank.
Bet 2 now changes to 4% of the new bank (based on value), and the stake should be 4% of 5100 insted of 4% of 5000
Hope it makes sence, but i cant figure out how to change it or the way to make the stake changing after each bet.
Hope you can help me.
| Bet | Bank | Procentage of bank based on value | Odds | Value | stake | win/loss | return |
| 1 | 5000 | 5% (250) if value 100 | 2 | 100 | 250 | win | 100 |
| 2 | 5100 | 4,5% (225) if value 95 | 3 | 90 | 204 | win | 408 |
| 4% (200) if value 90 |
