1-4 strategy formula

[Sam41798]

Hi everyone,

I need some help with a formula for an automated excel sheet I have. The formula is for a Recovery strategy called 1-4 recovery. It’s goes like this:
1x your bet amount first attempt
If that loses; 2x your bet amount
If that fails; 3x your bet amount
If that fails 4x your bet amount.
It doesn’t exceed 4x your bet amount but stays at 4x until you have fully recovered.

Has anyone used this strategy before and could help with the formula please?

thanks so much

 

[Eric W]

Welcome to the forum!

Try:

Book1
	A	B	C
1	Bet
2	10
3
4	Round	Bet	Result
5	1	10	L
6	2	20	W
7	3	10	L
8	4	20	L
9	5	30	L
10	6	40	L
11	7	40	L
12	8	40	W
13	9	10	W
14	10	10
15	11
16	12
Sheet12

Cell Formulas
Range	Formula
B5:B16	B5	=IF(OR(A5=1,C4="W"),A$2,IF(C4="","",MIN(A$2*4,B4+A$2)))

Put your base bet in A2. Put the formula in B5 and drag down. At the end of each round, put a W or an L in the C column. The formula on the next line should show your recommended bet for the next round.

As far as "does it work to make money"? Well, no. Given 50-50 odds, the house will still make money. In fact, I'd guess that even with better odds you'd lose money in the long run. There are multiple betting schemes, which casinos love people to use, since they don't really work. One scheme which theoretically does work is to bet 2^n+1 times the base bet if you lose, with no cap. But if you have a long losing streak, you could easily exceed your funds and the house still wins. So good luck, but don't bet too much on this!

 

[Eric W]

I was thinking about the "until fully recovered" part. Maybe this reflects better what you have in mind:

Book1
	A	B	C	D
1	Bet
2	10
3
4	Round	Bet	Result	Net gain
5	1	10	L	-10
6	2	20	W	10
7	3	10	L	0
8	4	20	L	-20
9	5	30	L	-50
10	6	40	L	-90
11	7	40	L	-130
12	8	40	W	-90
13	9	40	W	-50
14	10	40	W	-10
15	11	40	W	30
16	12	10	W	40
17	13	10	L	30
18	14	20	L	10
19	15	30	W	40
20	16	10	W	50
21	17	10		50
22	18			50
23	19			50
24	20			50
Sheet12

Cell Formulas
Range	Formula
B5:B24	B5	=IF(A5=1,A$2,IF(C4="","",IF(C4="L",MIN(A$2*4,B4+A$2),IF(D4>=0,A$2,B4))))
D5:D24	D5	=SUM(SUMIF(C$5:C5,{"W","L"},B$5:B5)*{1,-1})

 

[Sam41798]

Thanks so much for your reply. I’m hesitant to use it as I have heard it does fail over time.
Any chance you can show me a formula for something that’s similar to 1-4 but it doesn’t stop at 4x.
It’s goes like this

bet1 1xstake = loses
Bet 2 2x stake =loses
Bet 3 3x stake = loses

this keeps on multiplying until you have made it back to profits.
If there is a win at say 6x stake, you continue going up (7x,8x etc) until you’re back to profits. Kind of like the 1-4 but it keeps going.
Thanks so much

Sam