| Poster's Sportsbook Poll: 2011View Poll Results | ||
| # 1 5Dimes | 450 total points | 5Dimes Review |
| # 2 Pinnacle | 408 total points | Pinnacle Review |
| # 3 Heritage | 227 total points | Heritage Review |
| # 4 Bookmaker | 138 total points | Bookmaker Review |
| # 5 BetIslands | 129 total points | BetIslands Review |
| SBR Top-Rated SportsbooksRecommended List | ||
| Pinnacle Sports | SBR Rating A+ | Pinnacle Sports Review |
| 5Dimes | SBR Rating A+ | 5Dimes Review |
| BookMaker | SBR Rating A+ | BookMaker Review |
| Legends | SBR Rating A+ | Legends Review |
| Bodog | SBR Rating A | Bodog Review |
Calculating Odss based on Win Pct
I need an excel formula that can take the porbablilty % and calculate the american odds.
I can figure it out by trial and error or by pen, paper and algebra. But I want to have excel do it for me.
For example how can get Excel to calculate 60% = -150 for me?
=IF(A1<=0.5,SUM((1/A1)*100)-100,SUM((1/(1-A1))*-100)+100)
Where A1 contains the probabilty e.g. 0.60
|
|
How do you calculate the win probability if you knew the line was -150? In other words what is the reverse formula -150 to .6?
=IF(A1>0,SUM(1/((A1+100)/100)),SUM(1-(1/((A1-100)/-100))))Originally Posted by runnershane14
Again where cell A1 contains the US odds.
Was that really that hard to do for yourself? The only slightly complicated thing in there was an if statement... Learn excel, its the least you can do.
Yes. That was hard to do by myself. That is why I posted the question.
I have a file that should help but having problems posting it here. PM with your e-mail if you want it blargh and I'll send it over to you.
Blargh...I've seen Tim's file (previously posted) and it is easily understood and self-explanatory. Take him up on his offer and save the file on your 'puter.
Reply With Quote
elgreco gave Dunder 1 SBR Point(s) for this post.
