1. 03-13-11 10:59 PM #1
    Igetp2s
    Igetp2s's Avatar Become A Pro!
    Join Date: 05-21-07
    Posts: 1,046
    Betpoints: 6

    Getting SBR Odds historical lines into Excel?

    Is there an easy way to get it into Excel? All I want is the closing Pinnacle NBA lines including the vig, without all the other data like top scorers and such. Right now it's easiest to input by hand 1 game at a time, which obviously is not very efficient.

    Or is there another source that includes the vig with the spread that I can easily get to Excel?
    Reply With Quote Reply With Quote
  2. 03-14-11 12:40 AM #2
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119
    Betpoints: 7

    AFAIK, no; the only way I would know how to do it would be via a programming language. I would first write the code to scrape all the "Odds History" links from the page for each date. Then I would have it go to each one of the Odds History pages and have it scrape the last <tr> in the Pinnacle table and then parse that. Kinda complicated if you aren't familiar with programming.
    Reply With Quote Reply With Quote
  3. 03-15-11 12:39 PM #3
    jane2geo
    jane2geo's Avatar Become A Pro!
    Join Date: 04-28-10
    Posts: 93
    Betpoints: 3112

    "
    Reply With Quote Reply With Quote
  4. 03-15-11 05:43 PM #4
    Igetp2s
    Igetp2s's Avatar Become A Pro!
    Join Date: 05-21-07
    Posts: 1,046
    Betpoints: 6

    "
    Reply With Quote Reply With Quote
  5. 03-15-11 06:05 PM #5
    jgilmartin
    jgilmartin's Avatar Become A Pro!
    Join Date: 03-31-09
    Posts: 1,119
    Betpoints: 7

    Have you considered Don Best? I personally like SportsOptions' software a lot better, but I have never been able to copy and paste into Excel from their Line Archive. With DB, you can.
    Reply With Quote Reply With Quote
  6. 03-17-11 11:37 PM #6
    Igetp2s
    Igetp2s's Avatar Become A Pro!
    Join Date: 05-21-07
    Posts: 1,046
    Betpoints: 6

    Quote Originally Posted by jgilmartin View Post
    Have you considered Don Best? I personally like SportsOptions' software a lot better, but I have never been able to copy and paste into Excel from their Line Archive. With DB, you can.
    Is it free?
    Reply With Quote Reply With Quote
  7. 03-18-11 03:21 AM #7
    runnershane14
    runnershane14's Avatar Become A Pro!
    Join Date: 07-23-07
    Posts: 803
    Betpoints: 84

    Is there anyway to go back more than one day on the odds page that lists all the books. I know you can look at scoreboard and see open and close but I want to see all the books.
    Reply With Quote Reply With Quote
  8. 03-19-11 02:29 AM #8
    rake922
    rake922's Avatar Become A Pro!
    Join Date: 12-23-07
    Posts: 11,692
    Betpoints: 2105

    Quote Originally Posted by runnershane14 View Post
    Is there anyway to go back more than one day on the odds page that lists all the books. I know you can look at scoreboard and see open and close but I want to see all the books.
    No. That's why I update my own excel sheet every day.
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »