Hey guys is there a formula for converting moneyline into an expected margin of course also using the run total prediction.
-
-
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.dpufComment -
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.Comment -
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?Comment -
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 dataComment -
