1. #1
    CamNewtonOutfit
    CamNewtonOutfit's Avatar Become A Pro!
    Join Date: 09-26-16
    Posts: 446
    Betpoints: 661

    Convert moneyline to expected margin

    Hey guys is there a formula for converting moneyline into an expected margin of course also using the run total prediction.

  2. #2
    CamNewtonOutfit
    CamNewtonOutfit's Avatar Become A Pro!
    Join Date: 09-26-16
    Posts: 446
    Betpoints: 661

    i got % chance of wining but not margin:

    Moneyline to Percentages Conversion Chart
    Favorites
    +/-100 = 50%
    -110 = 52.4%
    -120 = 54.5%
    -130 = 56.5%
    -140 = 58.3%
    -150 = 60%
    -160 = 61.5%
    -170 = 63%
    -180 = 64.3%
    -190 = 65.5%
    -200 = 66.7%
    -210 = 67.7%
    -220 = 68.8%
    -230 = 69.7%
    -240 = 70.6%
    -250 = 71.4%
    -260 = 72.2%
    -270 = 73%
    -280 = 73.7%
    -290 = 74.4%
    -300 = 75%

    Underdogs
    +/-100 = 50%
    +110 = 48%
    +120 = 45%
    +130 = 43%
    +140 = 42%
    +150 = 40%
    +160 = 38%
    +170 = 37%
    +180 = 36%
    +190 = 34%
    +200 = 33%
    +210 = 32%
    +220 = 31%
    +230 = 30%
    +240 = 29.4%
    +250 = 28.6%
    +260 = 27.7%
    +270 = 27%
    +280 = 26.3%
    +290 = 25.6%
    +300 = 25%

    - See more at: http://www.lootmeister.com/mlb/money....vpOhQXfA.dpuf

  3. #3
    Waterstpub87
    Life-Style Arbitrage
    Waterstpub87's Avatar SBR PRO
    Join Date: 09-09-09
    Posts: 2,688
    Betpoints: 1145

    1. Open Microsoft Excel
    2. Across the first 5 Columns in the first row write: Away Runs, Home Runs, Total, Away Win %, Home Win %
    3. In the cell under total (C2), write the game total. do the same for the vig free moneyline converted into winning %s (D2,E2)
    4. In the cell under your away moneyline (D3), write the following formula: =(A2^2)/((a2^2)+(B2^2))
    5. In the cell under your home money line (E3):=(B2^2)/((a2^2)+(B2^2))
    6. Start to enter values in the home and away runs, and eventually you will come up with the answer, when cells D2 and D3 match

    Alternatively, you can use solver:
    Click Data, and then on the far right, click solver.
    Set D3 as the objective cell
    Set Objective to the value of D2
    Set A2 and B2 as the Cells to change
    Click Solve, and it will find the exact projected runs.
    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/21/2017

    175 pts

    3-QUESTION
    SBR TRIVIA WINNER 09/18/2017

    BTP
    Week 1
    3-1-1 184 pts


  4. #4
    CamNewtonOutfit
    CamNewtonOutfit's Avatar Become A Pro!
    Join Date: 09-26-16
    Posts: 446
    Betpoints: 661

    Thanks is there a place i can download the scores for each mlb game for 2016 plus either the moneyline or the runline or both?

  5. #5
    alling
    alling's Avatar Become A Pro!
    Join Date: 05-13-10
    Posts: 1,197
    Betpoints: 462

    W% (C1 CELL) X/(1-X) (D1 CELL) Q (E1 CELL) PRJ RUN (F1 CELL)
    =IF(A2<0,(A2)/((A2)-100),IF(A2>0,((100)/((A2)+100)))) =(C2)/(1-C2) =POWER(D2,0.556) =B2*E2/(1+E2)


    A2=money line
    B2=total

    sportsdatabase has all archived data

  6. #6
    MaddyMax
    MaddyMax's Avatar Become A Pro!
    Join Date: 02-14-17
    Posts: 539
    Betpoints: 30

    This calculator calculates moneylines to margins and margins to moneylines.

  7. #7
    CamNewtonOutfit
    CamNewtonOutfit's Avatar Become A Pro!
    Join Date: 09-26-16
    Posts: 446
    Betpoints: 661

    Thanks but this is win % but thats fine also

    Quote Originally Posted by MaddyMax View Post
    This calculator calculates moneylines to margins and margins to moneylines.

Top