View New Posts
  1. #1

    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.sbrforum.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's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,013
    Betpoints: 842
    Message Me

    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.sbrforum.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.

    SBR Founder Join Date: 8/28/2005


  3. #3

    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