1. #1
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    Odds calculation in excel

    Hello everyone,

    I have the american odds for these games in the NHL from 2 days ago.

    Date Day Season Team Opp Site P1 P2 P3 Final Line Total SUm SUr OUr ot
    Jan 04, 2015 Sunday 2014 Hurricanes Bruins home 1-0 0-1 0-0 2-1 133 5.0 1 W U 1
    Jan 04, 2015 Sunday 2014 Bruins Hurricanes away 0-1 1-0 0-0 1-2 -147 5.0 -1 L U 1
    Jan 04, 2015 Sunday 2014 Capitals Panthers home 0-0 3-2 1-1 4-3 -161 5.0 1 W O 0
    Jan 04, 2015 Sunday 2014 Panthers Capitals away 0-0 2-3 1-1 3-4 145 5.0 -1 L O 0
    Jan 04, 2015 Sunday 2014 Senators Lightning home 1-0 1-3 0-1 2-4 137 5.5 -2 L O 0
    Jan 04, 2015 Sunday 2014 Lightning Senators away 0-1 3-1 1-0 4-2 -152 5.5 2 W O 0
    Jan 04, 2015 Sunday 2014 Blackhawks Stars home 1-1 2-2 1-1 5-4 -198 5.5 1 W O 1
    Jan 04, 2015 Sunday 2014 Stars Blackhawks away 1-1 2-2 1-1 4-5 178 5.5 -1 L O 1
    Jan 04, 2015 Sunday 2014 Avalanche Blue Jackets home 1-1 2-2 0-1 3-4 -186 5.5 -1 L O 0
    Jan 04, 2015 Sunday 2014 Blue Jackets Avalanche away 1-1 2-2 1-0 4-3 167 5.5 1 W O 0
    Jan 04, 2015 Sunday 2014 Ducks Predators home 1-0 1-3 1-0 4-3 -155 5.0 1 W O 1
    Jan 04, 2015 Sunday 2014 Predators Ducks away 0-1 3-1 0-1 3-4 140 5.0 -1 L O 1
    Jan 04, 2015 Sunday 2014 Oilers Islanders home 1-0 1-1 3-1 5-2 160 5.5 3 W O 0
    Jan 04, 2015 Sunday 2014 Islanders Oilers away 0-1 1-1 1-3 2-5 -178 5.5 -3 L O 0

    1 row in perspective of the home team, the other in the perspective of the away team.
    How do i calculate the odds if i only have one side of it?

    Dec 23, 2014 Tuesday 2014 Coyotes Oilers away 2-1 1-0 2-0 5-1 122 5.5 4 W O 0

    Let's say i only have the Coyotes odds of +122 how do i calculate the odds for the Oilers?
    A possible vig should be included.

    Second question: What avg odds can i assume for Over/Under plays in the NHL. -105 to -105 is not realistic i know. but i would like to have a avg number to calculate estimations based on that.

    Thanks for the help.
    Last edited by nash13; 01-06-15 at 08:19 AM.

  2. #2
    Professor1215
    Improve Everyday
    Professor1215's Avatar Become A Pro!
    Join Date: 11-28-11
    Posts: 216
    Betpoints: 3212

    +122
    -122

    NO Vig Odds.

    Add whatever vig you would like and adjust. You can search on the forum for how to do this.

  3. #3
    HeeeHAWWWW
    HeeeHAWWWW's Avatar Become A Pro!
    Join Date: 06-13-08
    Posts: 5,487
    Betpoints: 578

    It depends how much juice is on the prices. Do you know which book they're from?

  4. #4
    nash13
    nash13's Avatar Become A Pro!
    Join Date: 01-21-14
    Posts: 1,122
    Betpoints: 7160

    I calculated the formula myself
    TemBOdd=(100*TemAOdd)/((100*TemAOdd)+(JUICE IN PCT*TemAOdd)-100)
    this is for decimal odds
    Example (Juice of 2.5%)
    Coyotes 122 transfers to 2.22 in decimals
    Oilers odd is then
    (100*2.22)/((2.22*100)+(2.5*2.22)-100)=1.74

  5. #5
    staf
    staf's Avatar Become A Pro!
    Join Date: 11-11-07
    Posts: 2,520
    Betpoints: 3553

    At sportsdatabase you can write your query so it lists the lines for both teams.

    Something like this should work:
    date,team,points,line,o:team,ooints,o:line@"game parameters"

Top