Keep increase betting amount until full amount recovered

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,422
Office Version
  1. 2010
Using Excel 2010

Hello,

European roulette has 37 numbers 1 to 36 + 0, betting strait on single number for example 2€ in case of wins it pays 35 times + returns the betting amount so far 70€ + 2€ =72€.

In case of placing 2€ bet on 5 different numbers bet amount will be 10€ in this case winning number will pay 72€ in case of loss will be -10€

For example roulette table has starting amount from min bet 0.20€, 0.50€, 1.00€, 2.00€, 5.00€, 10.00€, 50.00€, & max 100.00€

If I chose 5 numbers and place 2.00€ on each number total bet will be 10.00€.

Here is my question from which number of consecutive losing round I should….
1- Increase the bet amount
2- How much it should be till full amount recovered.

Please I need a VBA or formula help in the column B which can calculate incremented amount after every bet is losses and finally when it wins fully amount is covered within at least 30 consecutive losses.

Note: in the first 7 bets no need increment of amount because the pay-outs are more than 7 consecutive losses.

Here below is attached a sample sheet in which after a loss bet increment is calculated manually so far if any betting round bet is win it cover all the losses even till last 30th bet pass bet .

Recovery question.xlsx
ABCDEFG
1Bett For nºBet AmountMin Bet->0,20 €Total
252,00 €PayoutPayoutAccumulated
3BettingTotal €In CaseIn CaseWinNet
4Rounds10,00 €Of WinOf No WinLossLoss / Profit
5110,00 €72,00 €-10,00 €Loss-10,00 €
6210,00 €72,00 €-10,00 €Loss-20,00 €
7310,00 €72,00 €-10,00 €Loss-30,00 €
8410,00 €72,00 €-10,00 €Loss-40,00 €
9510,00 €72,00 €-10,00 €Loss-50,00 €
10610,00 €72,00 €-10,00 €Loss-60,00 €
11710,00 €72,00 €-10,00 €Loss-70,00 €
12811,40 €82,08 €-11,40 €Loss-81,40 €
13913,20 €95,04 €-13,20 €Loss-94,60 €
141015,40 €110,88 €-15,40 €Loss-110,00 €
151117,80 €128,16 €-17,80 €Loss-127,80 €
161220,80 €149,76 €-20,80 €Loss-148,60 €
171324,00 €172,80 €-24,00 €Loss-172,60 €
181428,00 €201,60 €-28,00 €Loss-200,60 €
191532,40 €233,28 €-32,40 €Loss-233,00 €
201637,60 €270,72 €-37,60 €Loss-270,60 €
211743,80 €315,36 €-43,80 €Loss-314,40 €
221850,80 €365,76 €-50,80 €Loss-365,20 €
231959,00 €424,80 €-59,00 €Loss-424,20 €
242068,60 €493,92 €-68,60 €Loss-492,80 €
252179,60 €573,12 €-79,60 €Loss-572,40 €
262292,40 €665,28 €-92,40 €Loss-664,80 €
2723107,40 €773,28 €-107,40 €Loss-772,20 €
2824124,60 €897,12 €-124,60 €Loss-896,80 €
2925144,80 €1.042,56 €-144,80 €Loss-1.041,60 €
3026168,00 €1.209,60 €-168,00 €Loss-1.209,60 €
3127195,20 €1.405,44 €-195,20 €Loss-1.404,80 €
3228226,60 €1.631,52 €-226,60 €Loss-1.631,40 €
3329263,20 €1.895,04 €-263,20 €Loss-1.894,60 €
3430305,60 €2.200,32 €-305,60 €Win0,12 €
35
36
37
38
Sheet1



Thank you all.

Regards,
Moti
 
Last edited:

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Hello, in the above example I have tried to increase the betting amount manually in the column B so if last bet pass it show the profit.

i am unable to fix it with formula so after every loss some % amount should be increased to recover all losses.

Please suggest

Thank you all in advance

Regards,
Moti
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top