+ Reply to Thread
Results 1 to 22 of 22

looking for a formula to calculate betting size

  1. #1
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Question looking for a formula to calculate betting size

    hey all
    i am into sport betting
    and i m looking for a formula that will calculate the stake so it will cover the previous losses and will make a profit if the bet wins,if i provide the odds

    i.e. i make a bet,odds re 1.84 and i lose 1unit
    i need the formula to calculate the bbetting size that will cover the loss and make profit for X odds



    thank you mates

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    So if your losses are X and your odds are Y/Z that means you have to bet Z to make a profit of Y (assuming it wins).

    So the amount you need to bet to break even (on previous losses) is X/Y*Z.

  3. #3
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    i dont get it
    can you show an example?
    Last edited by AliGW; 07-12-2022 at 06:33 AM. Reason: Please DON'T quote unnecessarily!

  4. #4
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    So lets say your losses are $150 so far (X=150)

    You get a sure tip on a dishlicker at 5/2 (Y=5, Z=2)

    So you need to win $150 to break even. That means you need to win $150 at 5/2. Correct?

    If you put $60 on at 5/2 you win 2 and a half times your stake. Correct?

    So 2 and a half times $60 is $150 (your losses), so you have broke even.

    How did i get that $60? Well, $150 divided by 5 (=$30) multiplied by 2 =$60. ie. X/Y*Z.

    Disclaimer: Bet responsibly. Don't chase your losses. Isn't that what they say on the ads?
    Last edited by Croweater; 06-16-2022 at 08:01 PM.

  5. #5
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    thank you i got it now
    Last edited by Rizatou4; 06-16-2022 at 08:58 PM.

  6. #6
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    So you want to make 165 euros on your next bet (120+45). So X=165

    Odds are 2,25? I assume that means if you bet one euro you win 2.25 (So odds are 9/4...correct? If I have that wrong tell me what "2,25" actually means or change it appropriately in my calculation). So Y=9, Z=4

    X/Y*Z = 165/9*4 = 73.33

    So you would have to bet 73.33 Euros to make a 45 euro profit on a previous loss of 120 euros.

    EDIT. OK glad you got it.

  7. #7
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    thank you very much for your help
    now i d go on greedy mode,that what gambling is after all and ask smth more
    is there a way to calculate how many bet i can make for X amount of monney as bankroll Y odds and
    Z profit target after each bet?


    i.e.
    bankroll is 100 euros
    odds re 2.82
    protit target with covering previous losses is 1 euro

    can i calculate how many bets i can make before all the bankroll is gone?

  8. #8
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    Not quite sure what you mean here but I'll try to work something out...my initial formula didn't work out when I wrote a spreadsheet to test it.

    Give me a mo...and I'll get back to you.

    OK I've attached a worksheet that will tell you how long your initial bankroll will last given odds, your bet size, and your expected win/loss ratio

    I find a spreadsheet much easier to solve these types of problem than a 'formula' and this is an Excel forum after all, not a maths forum (note the cop out justification )

    (If I get keen, I'll try to work out the actual formula).

    Put your inputs in the green cells.
    Attached Files Attached Files
    Last edited by Croweater; 06-18-2022 at 10:36 PM.

  9. #9
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    OK. I've had a think about this and come up with the following;

    Your expected outcome for each bet = Probability of winning X Amount you win - Probability of Losing X Amount you lose

    So the amount of bets you can expect to make with your initial bankroll is your bankroll divided by that number above (multiplied by -1 because your expected outcome will be less than zero if you are being realistic)

    If your expected outcome is positive, your money will last forever of course.

    Another consideration is that your wins will not be nice and uniform over all of your bets, so the ACTUAL number of bets you get to make will depend on when your wins occur, as demonstrated by the worksheet I put up.

    Hope that explains it in a maths sense?

    Note: If you randomize your wins (as expected in the real world) by putting this formula in E2 in the worksheet I posted, every time you recalculate (F9), you will get vastly different results.

    Please Login or Register  to view this content.
    Last edited by Croweater; 06-19-2022 at 10:26 PM.

  10. #10
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    thank you very much

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,805

    Re: looking for a formula to calculate betting size

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  12. #12
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    ok i know now how to break even now
    what i m looking for if its possible is a way to calculate for a given amount of money with given odds and profit target
    how many bets i can make with covering losses and making the profit before original amount of money is gonne with the wind


    i.e.

    bankroll : 100 euros
    odds : 3.40
    profit target : 2.40


    how to calculate how many times i can bet with this bankroll aiming to 2.4 profits?

  13. #13
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    Quote Originally Posted by Rizatou4 View Post
    how many bets i can make with covering losses and making the profit before original amount of money is gonne with the wind
    I don't understand this. How can you make a profit AND lose your original stake money?

    Do you mean every time you are up by your profit target, you take that amount out of your pool of money and stick it in your back pocket? Or something else?

  14. #14
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    hello
    thank you for the reply
    i meant how many bets i can make by this way of betting meaning rising my stakes so i cover the previous loses and aiming for the profit of 2.40
    when i have a win i return to the start


    for my given example

    bankroll : 100 euros
    odds : 3.40
    profit target : 2.40

    target is 2.40 so i bet 1 euro on the first bet and the bet lost
    now i have to make another bet,covering the lost unit and aiming profit of 2.to40
    if that bet loses i have to make another bet covering the loses of the previous lost bets and giving me profit of 2.40
    and so on,till one bet win or my bankroll gone with the wind


    what i need to know is a way to figure out how many bets i can make with the given way

  15. #15
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,805

    Re: looking for a formula to calculate betting size

    This thread is marked as solved ...

  16. #16
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    how to change that?

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,805

    Re: looking for a formula to calculate betting size

    The same way you added it in reverse: please select Thread Tools from the menu link above right and mark this thread as UNSOLVED.

  18. #18
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    OK...I THINk this is what you mean.
    I made a change to your initial bet to give you your target profit, and made the following calculation for your next bet, depending on whether you won or lost on your last bet.
    This will cover your previous losses AND give you your target profit if you win.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Croweater; 07-25-2022 at 03:30 AM.

  19. #19
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    what i need to know is a way to figure out how many bets i can make with the given way of betting

    100 units

    odds 3.40

    profit aim 2.40

    how many bets befora bankroll gone with the wind?

  20. #20
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    Change the profit from whatever I put in the attachment to test it, to 2.40 then!

    Of course the worksheet I gave you works on a (more realistic) random win ratio.

    If you want a uniform win every so many bets, then use this formula in E2 and drag down

    Please Login or Register  to view this content.
    Then just increase your win loss ratio until your bankroll is "Gone with the Wind".

    The answer in that scenario for your given data is 15 bets.

    If that doesn't give you what you want, then maybe you should ask Margaret Mitchell.
    Last edited by Croweater; 07-25-2022 at 08:25 AM.

  21. #21
    Registered User
    Join Date
    06-16-2022
    Location
    uk
    MS-Off Ver
    365
    Posts
    10

    Re: looking for a formula to calculate betting size

    Quote Originally Posted by Croweater View Post
    The answer in that scenario for your given data is 15 bets.
    .

    that is what i was looking for

    can you tell me how you calculate it so i can do it my own with different numbers?

  22. #22
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: looking for a formula to calculate betting size

    Yes. Plug your different numbers into the spreadsheet I gave you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. AutoSum to calculate file size (Multiple Size Definitions)
    By anemae in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-24-2021, 04:28 AM
  2. Count if formula to calculate tshirt size & quanity
    By Always_Analyst in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2020, 10:56 AM
  3. Betting formula
    By starman102 in forum Excel General
    Replies: 25
    Last Post: 08-22-2014, 01:44 PM
  4. betting formula
    By orgagigio in forum Excel General
    Replies: 11
    Last Post: 08-21-2014, 07:35 PM
  5. Betting Prediction Formula
    By egemen_i in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-27-2012, 05:45 AM
  6. Formula required to calculate betting odds/returns
    By jonrayworth in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 08:14 AM
  7. Betting formula help
    By starman102 in forum Excel General
    Replies: 0
    Last Post: 06-19-2009, 11:52 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1