1. #1
    keithb
    keithb's Avatar Become A Pro!
    Join Date: 12-09-08
    Posts: 5

    Historical NHL lines

    I am new to the forums but am already impressed by the information.

    I would like to get historical NHL moneylines and spreads (plus the moneyline for the spread) and the over/under lines (plus moneyline for the O/U). SBR has this information (looks like it goes back to October 14, 2006) but not in a format to analyze. Is there anyway to get the information without clicking on every day there was a hockey game and copying and pasting the data?

    Plus SBR has the lines for different books. The only problem is that I can't compile the lines because of the format (see http://www.sportsbookreview.com/Scores/NHL+Odds/20071101.aspx for an example of how the lines are provided).

    Please let me know if you know a way to get the SBR information into a spreadsheet.


    Keith

  2. #2
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,011
    Betpoints: 1088

    Quote Originally Posted by keithb View Post
    I am new to the forums but am already impressed by the information.

    I would like to get historical NHL moneylines and spreads (plus the moneyline for the spread) and the over/under lines (plus moneyline for the O/U). SBR has this information (looks like it goes back to October 14, 2006) but not in a format to analyze. Is there anyway to get the information without clicking on every day there was a hockey game and copying and pasting the data?

    Plus SBR has the lines for different books. The only problem is that I can't compile the lines because of the format (see http://www.sportsbookreview.com/Scores/NHL+Odds/20071101.aspx for an example of how the lines are provided).

    Please let me know if you know a way to get the SBR information into a spreadsheet
    At this point your only real solution is to write a program to go day by day and game by game and pull the data automatically.

    If you don't know how to do this you can either hire a coder to do it for you or get to learning. No time like the present, after all.

  3. #3
    Wea
    Wea's Avatar Become A Pro!
    Join Date: 12-13-08
    Posts: 19

    Import data to spreadsheet in Excel

    Hello.

    I'll give you a free lession on importing data into excel...

    1. Open Excel.
    2. Under data, chose "Import external data", "New Web Query"
    3. Put in the web adress
    4. Click on the arrows that indicate the table you want to import.
    5. Click import.
    6. Chose where to import to e.g. A1.

    There you are, know you have the data in Excel... But they will most of the time need some sorting and moving arround. This you can of course make a short program or macro for.

    Hope this helps.
    Wea

Top