Forumula for Betting - a Staking Plan formula

[Betting]

Hi Forum

I need help with a formula for betting and hoping you guys can help.

I intend to have a starting bet of 10, if it wins, it will be multiplied by the odds of the winning horse/team etc, if it loses, it will be -10 (my stake).

But the next stake will increase by 2. Next bet will be 12, if it wins, it will be multiplied by the odds of the winning horse/team and added to a total. I intend to keep on adding 2 to my stake on each bet until I win, when I win, it will be reset to 10 again.

What sort of formula could I use for this staking plan?

Odds Stake Win/Lose P&L Total P&L +110
6 10 L -10
5 12 L -22
10 14 L -36
6 16 W 96
5 10 W 50

[Betting]

The table layout below is what I am trying to achieve

Odds	Stake	Win/Lose	P&L	Total P&L
6	10	L	-10	-10
5	12	L	-12	-22
10	14	L	-14	-36
6	16	W	96	60
5	10	W	50	110

[NBVC]

Assuming data starts in A2:C2 and downwards, then in D2, copied down, try:

=B2*IF(C2="L",-1,A2)

and in E2, copied down, try:

=SUM(D$2: D2) - remove space before D2

[Betting]

Thanks very much!

Would there be any way that the next stake could be automatically produced using a formula, so the only variable I need to change is the actual result each time W/L?

Would that require a complicated formula?

[NBVC]

How do you know the next stake?

[Betting]

If the last race lost, it will be the previous stake plus 2, if it won, it resets to 10.

Opening stake = 10
L= 12
L = 14
L = 16
W = 10

Hopefully makes sense?

[NBVC]

Ok. So you will hard code the first stake (10) in B2, then in B3, formula would be:

=IF(C2="L",B2+2,10)

copied down

[Betting]

Excellent! Thanks.

[NBVC]

You're welcome.