Results 1 to 9 of 9

Thread: Forumula for Betting - a Staking Plan formula

  1. #1
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016

    Forumula for Betting - a Staking Plan formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    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. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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. #4
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    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. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    How do you know the next stake?


  6. #6
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    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. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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. #8
    Seeker Betting's Avatar
    Join Date
    Jan 2019
    Posts
    8
    Articles
    0
    Excel Version
    2016
    Excellent! Thanks.

  9. #9
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    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
  •