1. #1
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    How to convert NBA win % to point spread??

    I have an estimated win probability for the NBA home team and want to convert it to a point spread, what is the formula for this?

    Thanks in advance.

  2. #2
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    One way is to convert the win probability percentages into a money line and then enter those odds into Spread/ML Converter

    http://www.sportsbookreview.com/pick...-ml-converter/

    BTP
    Week 8
    5-0-0 461 pts


  3. #3
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    I appreciate the response.

    Do you know of a formula to input into an excel spreadsheet?

  4. #4
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by oilcountry99 View Post
    I appreciate the response.

    Do you know of a formula to input into an excel spreadsheet?
    You mean to convert probability to ML?

    If greater than 50%, then -(probability/(1-probability)). So 55% would be -.55/.45 for roughly -122

    If 50% or less, then +((1-probability)/probability). So 40% would .60/.40 for +150

    BTP
    Week 8
    5-0-0 461 pts


  5. #5
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    thanks again for the post. What I need is a formula to convert win% to point spread

    Appreciate your efforts thanks LT.

  6. #6
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by oilcountry99 View Post
    thanks again for the post. What I need is a formula to convert win% to point spread

    Appreciate your efforts thanks LT.
    There is no such thing because all point spreads are priced differently, and it varies from sport to sport. That is what makes the converter valuable, it is based on historical results.

    BTP
    Week 8
    5-0-0 461 pts


  7. #7
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    LT,
    What if I input different point spreads in the converter and created a table of WIN% = PT SPREAD and put that table into excel to reference from? so if team X has a win% of 56% excel will then look up the corresponding pt. spread in the table. Does that make sense? Would it work? I'm just trying to avoid having to input the numbers into the table and then input the results into excel...to time consuming.

  8. #8
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    LT, I found this...

    W% = 1 / (1 + e^(-0.13959 * (Avg. Pt. Diff)))


    Using a win% of 0.663 as an example:


    0.663 = 1 / (1 + e^(-0.13959 * P))


    Solving for P (i.e., the point spread) we get:


    P = -ln(1/0.663 – 1) / 0.13959 = 4.85

  9. #9
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by oilcountry99 View Post
    LT, I found this...

    W% = 1 / (1 + e^(-0.13959 * (Avg. Pt. Diff)))


    Using a win% of 0.663 as an example:


    0.663 = 1 / (1 + e^(-0.13959 * P))


    Solving for P (i.e., the point spread) we get:


    P = -ln(1/0.663 – 1) / 0.13959 = 4.85
    I do not know if that formula is right for the specific sport you are looking at, but I DO know it is not good universally over all sports. You can test it for the sport you are looking at by inputting -197 (.663/.337) in converter and seeing how close it is to -4.5

    BTP
    Week 8
    5-0-0 461 pts


  10. #10
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    I was more exact and inputed -196.7 and got the following:

    NFL: -4.5 (Voila!)
    CFB: -6.5
    NBA: -5.5
    CBK: -4.5 (Voila!)

    Doesn't really prove anything but you may be close for NFL. And it seems fluky that your formula gets 4.5 for both NFL and CBK given the mass difference in the scoring distributions for those two sports.

    BTP
    Week 8
    5-0-0 461 pts


  11. #11
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    LT, the example was specific to the NBA, so the -5.5 is off.

  12. #12
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    here's a link to what I'm looking into...maybe it will help further

    http://statitudes.com/blog/2013/11/1...ity-using-srs/

  13. #13
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by oilcountry99 View Post
    LT, the example was specific to the NBA, so the -5.5 is off.
    Or the formula is off. Not really sure which is true.

    BTP
    Week 8
    5-0-0 461 pts


  14. #14
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by oilcountry99 View Post
    here's a link to what I'm looking into...maybe it will help further

    http://statitudes.com/blog/2013/11/1...ity-using-srs/
    This seems to make a lot of sense, so I would go for it for NBA if you want to. I wasn't too thrilled at first with usage of end-of-season SRS, but he addressed that later.

    BTP
    Week 8
    5-0-0 461 pts


  15. #15
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by LT Profits View Post
    This seems to make a lot of sense, so I would go for it for NBA if you want to. I wasn't too thrilled at first with usage of end-of-season SRS, but he addressed that later.
    I believe I would have to apply the formula's set out by TomTango in the comments below the article...

    Justin’s equation can be rewritten as:


    x = EXP(-dSRS * .167)
    win% = 1.844 / (1.844 + x)


    However, that dSRS in the model is the UNREGRESSED value.


    If you used a regressed value (meaning Games / (Games + 12) x dSRS), then the “x” equation becomes:


    x = EXP(-reg_dSRS * .191)

  16. #16
    The Hat
    The Hat's Avatar SBR PRO
    Join Date: 09-24-16
    Posts: 557
    Betpoints: 124

    IMO, point spread and win probability do not correspond. The spread corresponds to public perception and does not reflect or equate to win probability.

    BTP
    Week 11
    4-0-1 660 pts

    BTP
    Week 9
    3-1-1 268 pts


  17. #17
    LT Profits
    LT Profits's Avatar VIP Moderator
    Join Date: 10-27-06
    Posts: 65,869
    Betpoints: 96860

    Quote Originally Posted by The Hat View Post
    IMO, point spread and win probability do not correspond. The spread corresponds to public perception and does not reflect or equate to win probability.
    Precisely the reason you can gain an edge with a model that CAN generate an accurate unbiased spread.

    BTP
    Week 8
    5-0-0 461 pts


  18. #18
    The Hat
    The Hat's Avatar SBR PRO
    Join Date: 09-24-16
    Posts: 557
    Betpoints: 124

    Quote Originally Posted by LT Profits View Post
    Precisely the reason you can gain an edge with a model that CAN generate an accurate unbiased spread.
    I see what you mean in regards to comparing the 'vegas spread' with the spread that that model generates and betting accordingly, but IMO, I don't think you can actually begin the process with an accurate win probability. What generates the win probability percentage? What comes before the win prob prcntg?

    BTP
    Week 11
    4-0-1 660 pts

    BTP
    Week 9
    3-1-1 268 pts


  19. #19
    The Hat
    The Hat's Avatar SBR PRO
    Join Date: 09-24-16
    Posts: 557
    Betpoints: 124

    OP starts off with 'I have an estimated win probability'.

    What margin for error are you dealing with in regards to the estimation? 2%? 5%? 7%?

    Do you run the model plugging in the various 'win prob %'s' due to the margin for error? Once you get into doing that, not sure that you would see any significant variance between 'model line' and 'vegas line'. And again, just my opinion and I very well may be wrong.

    BTP
    Week 11
    4-0-1 660 pts

    BTP
    Week 9
    3-1-1 268 pts


  20. #20
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by The Hat View Post
    IMO, point spread and win probability do not correspond. The spread corresponds to public perception and does not reflect or equate to win probability.
    The calculations however would give a 'base' as to what the spread should be, from there one can evaluate whether or not there is any value in the selection based on the given ML and PS on the game.

  21. #21
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by The Hat View Post
    OP starts off with 'I have an estimated win probability'.

    What margin for error are you dealing with in regards to the estimation? 2%? 5%? 7%?

    Do you run the model plugging in the various 'win prob %'s' due to the margin for error? Once you get into doing that, not sure that you would see any significant variance between 'model line' and 'vegas line'. And again, just my opinion and I very well may be wrong.
    Refer to the link in post #12 for more insight.

    I'm no expert here just looking at options, thanks for your thoughts

  22. #22
    The Hat
    The Hat's Avatar SBR PRO
    Join Date: 09-24-16
    Posts: 557
    Betpoints: 124

    Quote Originally Posted by oilcountry99 View Post
    Refer to the link in post #12 for more insight.

    I'm no expert here just looking at options, thanks for your thoughts
    Yeah I checked it out. IMO, the formula doesn't have enough criteria built into it. In basketball, you have to take into account teams playing back to back games vs a team that isn't. Also, coast to coast travel factors in. Injuries. etc etc etc.

    BTP
    Week 11
    4-0-1 660 pts

    BTP
    Week 9
    3-1-1 268 pts


  23. #23
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by The Hat View Post
    Yeah I checked it out. IMO, the formula doesn't have enough criteria built into it. In basketball, you have to take into account teams playing back to back games vs a team that isn't. Also, coast to coast travel factors in. Injuries. etc etc etc.
    That's where the handicap comes in. The formula only gives a lean.

  24. #24
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by The Hat View Post
    I see what you mean in regards to comparing the 'vegas spread' with the spread that that model generates and betting accordingly, but IMO, I don't think you can actually begin the process with an accurate win probability. What generates the win probability percentage? What comes before the win prob prcntg?
    The SRS is what generates the base. This stat is powerful in that it takes past games point differential and opponents strength and incorporates it into a number or rating based on the average NBA team.

    Look at the tables in the article, there are some great correlations based on the formula.

  25. #25
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    How do you enter this formula into excel:

    p = 1 / (1 + e-(0.613230 + 0.167546 (-3.01)))

  26. #26
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-10-09
    Posts: 2,753
    Betpoints: 511

    =1/(1+exp(-(0.61323+0.167546*(-3.01))))

    I assume you mean raising e to that power. Not subtracting it from e

    The result is
    0.527202
    is that close to what you want?
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 11/09/2017

    BTP
    Week 8
    4-1-0 292 pts


  27. #27
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Thanks Waterstpub87...appreciate the reply! worked like a charm

    how about this one:
    Where dSRS is a cell reference, the number in the cell could be positive or negative.

    x = EXP(-dSRS * .167)


    Last edited by oilcountry99; 10-24-16 at 02:14 PM.

  28. #28
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-10-09
    Posts: 2,753
    Betpoints: 511

    Go to Formulas on the ribbon at the top.

    Select Name manager
    Select New
    Type dSRS
    Select the cell where you will have dSRS in the refers section
    Close the name manager
    you can use this formula

    =EXP(-drRs*0.167)

    is there a reason you want to lock it to a specific cell? You know that you can just select the cell and get the same result, right? If you type -A1, it will give you the negative of what is in cell A1
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 11/09/2017

    BTP
    Week 8
    4-1-0 292 pts


  29. #29
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Quote Originally Posted by Waterstpub87 View Post
    Go to Formulas on the ribbon at the top.

    Select Name manager
    Select New
    Type dSRS
    Select the cell where you will have dSRS in the refers section
    Close the name manager
    you can use this formula

    =EXP(-drRs*0.167)

    is there a reason you want to lock it to a specific cell? You know that you can just select the cell and get the same result, right? If you type -A1, it will give you the negative of what is in cell A1
    Maybe the above forumula is the incorrect one to use. I'm getting a decimal number result which seems way off.

  30. #30
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    l also have this last one:

    Where win% is a cell, for example N7

    = -ln(1/N7 – 1) / 0.13959

    Thanks again for your help

  31. #31
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-10-09
    Posts: 2,753
    Betpoints: 511

    You need to specify order of operations.

    Do you want

    The natural log of 1/(N7-1) or the natural log of ((1/n7)-1)

    Option 1: =-ln(1/(N7-1))/0.13959
    Option 2: =-ln((1/N7)-1)/0.13959
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 11/09/2017

    BTP
    Week 8
    4-1-0 292 pts


  32. #32
    oilcountry99
    oilcountry99's Avatar SBR PRO
    Join Date: 08-29-10
    Posts: 268
    Betpoints: 1881

    Option 2 worked....

    I was inputting what you had in the above post and it wasn't working. I did a copy/paste of your formula and it worked fine, strange!

  33. #33
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-10-09
    Posts: 2,753
    Betpoints: 511

    Quote Originally Posted by oilcountry99 View Post
    Option 2 worked....

    I was inputting what you had in the above post and it wasn't working. I did a copy/paste of your formula and it worked fine, strange!
    Excel can be a pain sometimes. You might have missed a ( somewhere and it caused it to fail.
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 11/09/2017

    BTP
    Week 8
    4-1-0 292 pts


  34. #34
    gojetsgomoxies
    gojetsgomoxies's Avatar Become A Pro!
    Join Date: 09-04-12
    Posts: 2,106
    Betpoints: 4026

    you could put moneylines and spreads into excel and do one of two things i can think of:

    1: run a regression although will be curve-linear i'm sure... then you will have formula to convert.

    2) vlookup it.

    as mentioned no real formula as it's different for each sport and changes somewhat over time. lots of conversion tables out there though

Top