Using Excel 2010
Hello,
Here is the below example attachment…
Note; Betting minimum amount 0.50€ so far a increment of the bet size will be start with 0.50€, 1.50€, 2.00€, 2.50€, 3.00€ and so on…..
0-Placing initial bet 1.00 € it return 3 times so far wins Are 3.00 €
1-in the column “E” cell 6 to down Enter X=If bet Losses & Y=If Bet wins
2-in the column “B” cell B6 to down there is 25 rounds of bets
3-in the column “C” cell C3 is entered initial bet amount 1.00 €
4-in the column “C” cell C6 to down manually bet is entered which cover the loss at any stage if in case number is matched and bet is wins. Otherwise losses continue…
5-in this example if the initial 1.00 € any ware in the column “E”
In the cell E6 if bet is pass and Y is replaced balance in cell F6 rise by 2.00€,
If in the cell E7 if bet is pass and Y is replaced balance in cell F7 rise by 1.00€
And if in the cells E8 if bet is pass and Y is replaced balance in cell F8 rise by 0.00€ that is breakeven point as bet pays 3.00€ profit of the 1.00€ bet
Here is overview….
If initial bet is 1.00€ first 3 rounds bets will be the same amount of the 1.00€ as bet pays 3.00€ profit of the 1.00€ bet so far we will earn 2.00€ if bet pass in 1st round, if in second 1.00€, in the third round will be breakeven no loss no profit.
Here are my requests….
1-if bet pass in the 1st round bet has to be restart again for 3 rounds of 1.00€, if bet pass in the 2nd round bet has to be restart again for 3 rounds of 1.00€, if bet pass in the 3rd round bet has to be restart again for 3 rounds of 1.00€
2-if bet fail 1st 3 rounds in the 4th round bet has to be increased in that proportional amount if 4th round pass it has to recovered all losses. If 4th round fails than in the 5th round bet has to be increased in that proportional amount if 4th round pass it has to recover all losses.
3-i need a formula in the Column “C” Cells C6 to down if there is 25 consecutive losses increase the proportional betting amount cover the loss only at any round placing “Y” in the column “E” and balance amount reach at breakeven in the column “F”
4-in this example initial bet is 1.00€ if the initial bet is set 1.50€ or 2.00€ or 0.50€ proportional betting amount increment be set as per initial bet does it is possible
Please help
Thank you all.
Regards,
Moti
Hello,
Here is the below example attachment…
Note; Betting minimum amount 0.50€ so far a increment of the bet size will be start with 0.50€, 1.50€, 2.00€, 2.50€, 3.00€ and so on…..
0-Placing initial bet 1.00 € it return 3 times so far wins Are 3.00 €
1-in the column “E” cell 6 to down Enter X=If bet Losses & Y=If Bet wins
2-in the column “B” cell B6 to down there is 25 rounds of bets
3-in the column “C” cell C3 is entered initial bet amount 1.00 €
4-in the column “C” cell C6 to down manually bet is entered which cover the loss at any stage if in case number is matched and bet is wins. Otherwise losses continue…
5-in this example if the initial 1.00 € any ware in the column “E”
In the cell E6 if bet is pass and Y is replaced balance in cell F6 rise by 2.00€,
If in the cell E7 if bet is pass and Y is replaced balance in cell F7 rise by 1.00€
And if in the cells E8 if bet is pass and Y is replaced balance in cell F8 rise by 0.00€ that is breakeven point as bet pays 3.00€ profit of the 1.00€ bet
Here is overview….
If initial bet is 1.00€ first 3 rounds bets will be the same amount of the 1.00€ as bet pays 3.00€ profit of the 1.00€ bet so far we will earn 2.00€ if bet pass in 1st round, if in second 1.00€, in the third round will be breakeven no loss no profit.
Here are my requests….
1-if bet pass in the 1st round bet has to be restart again for 3 rounds of 1.00€, if bet pass in the 2nd round bet has to be restart again for 3 rounds of 1.00€, if bet pass in the 3rd round bet has to be restart again for 3 rounds of 1.00€
2-if bet fail 1st 3 rounds in the 4th round bet has to be increased in that proportional amount if 4th round pass it has to recovered all losses. If 4th round fails than in the 5th round bet has to be increased in that proportional amount if 4th round pass it has to recover all losses.
3-i need a formula in the Column “C” Cells C6 to down if there is 25 consecutive losses increase the proportional betting amount cover the loss only at any round placing “Y” in the column “E” and balance amount reach at breakeven in the column “F”
4-in this example initial bet is 1.00€ if the initial bet is set 1.50€ or 2.00€ or 0.50€ proportional betting amount increment be set as per initial bet does it is possible
| MrExcel Question.xls | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Inicial Bet | Start Money | |||||||
| 2 | Amount | 25.000,00 € | |||||||
| 3 | 1,00 € | Result | |||||||
| 4 | PROFIT | PROFIT = Y | Net Gain/Loss | ||||||
| 5 | ROUND | BET € | IF Bet Pass | LOSS = X | BALANCE | ||||
| 6 | 1 | 1,00 € | 3,00 € | X | 24.999,00 € | ||||
| 7 | 2 | 1,00 € | 3,00 € | X | 24.998,00 € | ||||
| 8 | 3 | 1,00 € | 3,00 € | X | 24.997,00 € | ||||
| 9 | 4 | 1,50 € | 4,50 € | X | 24.995,50 € | ||||
| 10 | 5 | 2,50 € | 7,50 € | X | 24.993,00 € | ||||
| 11 | 6 | 3,50 € | 10,50 € | X | 24.989,50 € | ||||
| 12 | 7 | 5,50 € | 16,50 € | X | 24.984,00 € | ||||
| 13 | 8 | 8,00 € | 24,00 € | X | 24.976,00 € | ||||
| 14 | 9 | 12,00 € | 36,00 € | X | 24.964,00 € | ||||
| 15 | 10 | 18,00 € | 54,00 € | X | 24.946,00 € | ||||
| 16 | 11 | 27,00 € | 81,00 € | X | 24.919,00 € | ||||
| 17 | 12 | 40,50 € | 121,50 € | X | 24.878,50 € | ||||
| 18 | 13 | 61,00 € | 183,00 € | X | 24.817,50 € | ||||
| 19 | 14 | 91,50 € | 274,50 € | X | 24.726,00 € | ||||
| 20 | 15 | 137,00 € | 411,00 € | X | 24.589,00 € | ||||
| 21 | 16 | 205,50 € | 616,50 € | X | 24.383,50 € | ||||
| 22 | 17 | 308,50 € | 925,50 € | X | 24.075,00 € | ||||
| 23 | 18 | 462,50 € | 1.387,50 € | X | 23.612,50 € | ||||
| 24 | 19 | 694,00 € | 2.082,00 € | X | 22.918,50 € | ||||
| 25 | 20 | 1.041,00 € | 3.123,00 € | X | 21.877,50 € | ||||
| 26 | 21 | 1.561,50 € | 4.684,50 € | X | 20.316,00 € | ||||
| 27 | 22 | 2.342,00 € | 7.026,00 € | X | 17.974,00 € | ||||
| 28 | 23 | 3.513,00 € | 10.539,00 € | X | 14.461,00 € | ||||
| 29 | 24 | 5.269,50 € | 15.808,50 € | X | 9.191,50 € | ||||
| 30 | 25 | 7.904,50 € | 23.713,50 € | X | 1.287,00 € | ||||
| 31 | |||||||||
| 32 | |||||||||
| 33 | |||||||||
| 34 | |||||||||
| 35 | |||||||||
Sheet8 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C6 | C6 | =C3 |
| D6:D30 | D6 | =C6*3 |
| F6 | F6 | =IF(C6="","",IF(AND(OR(E6="Y")),(F$2-C6)+D6,F$2-C6)) |
| F7:F30 | F7 | =IF(C7="","",IF(AND(OR(E7="Y")),(F6-C7)+D7,F6-C7)) |
Please help
Thank you all.
Regards,
Moti
