Forumula for Betting - a Staking Plan formula

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

The table layout below is what I am trying to achieve

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

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?

How do you know the next stake?

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?

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

Excellent! Thanks.

You're welcome.

Hey! I'm just curious, if there's any update

I see it’s been a while, but I wanted to chime in. One formula that could work is:
Stake = ((Total P&L + 10) / 2)
This formula would start with a stake of 10 and then increase by 2 after each losing bet. After a winning bet, the stake would reset to 10. I used this formula when betting at w88 and won a lot. I hope this helps, and good luck with your betting!