# Thread: Forumula for Betting - a Staking Plan formula

1. ## 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

2. 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

3. 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

4. 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?

5. How do you know the next stake?

6. 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?

7. 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

8. Excellent! Thanks.

9. You're welcome.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•