1. #1
    ferbs027
    ferbs027's Avatar Become A Pro!
    Join Date: 08-14-08
    Posts: 46
    Betpoints: 12

    Historical Database: Spreads/Totals

    Is anyone aware of a place where I can access a historical database of spreads and O/U totals for past sporting events? I'm really only interested in football (NFL more than college but I'll take what I can get). I'm new to this stuff and am trying to figure out how to back test a few ideas I've had floating in my head the past few days. I'm a college student and don't really have much expendable cash so cost is an issue. If anyone has any info that might be helpful I'd greatly appreciate it!

  2. #2
    Peep
    Peep's Avatar Become A Pro!
    Join Date: 06-23-08
    Posts: 2,295

    Just go to covers, you can copy and paste scores and games from there into excel, have your own little database for free in no time.

    And cost will not be an issue!

    I think you are always better off building any database you plan to use anyway, then you know what you have.

  3. #3
    rsigley
    rsigley's Avatar Become A Pro!
    Join Date: 02-23-08
    Posts: 304
    Betpoints: 180

    i posted most of them here

    http://www.squaresportsbetting.com/db/

    i've got all the other ones but haven't had a chance to upload them yet

    and for some reason i have the wnba on its own page

    http://www.squaresportsbetting.com/db/wnba.html

  4. #4
    Data
    Data's Avatar Become A Pro!
    Join Date: 11-27-07
    Posts: 2,236

    Quote Originally Posted by rsigley View Post
    i posted most of them here

    http://www.squaresportsbetting.com/db/

    i've got all the other ones but haven't had a chance to upload them yet

    and for some reason i have the wnba on its own page

    http://www.squaresportsbetting.com/db/wnba.html


    It is nice to see a poster sharing something useful.

    Speaking of quarters data you were looking for, can't you get it from the box scores? It seems you can.
    http://www.databasebasketball.com/te...I&yr=1995&lg=N

  5. #5
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,181

    Quote Originally Posted by rsigley View Post
    i posted most of them here

    http://www.squaresportsbetting.com/db/

    i've got all the other ones but haven't had a chance to upload them yet

    and for some reason i have the wnba on its own page

    http://www.squaresportsbetting.com/db/wnba.html
    Nice job.

    I wish I had that page before i spent a thousand hours and dollars collecting all that myself.

  6. #6
    ferbs027
    ferbs027's Avatar Become A Pro!
    Join Date: 08-14-08
    Posts: 46
    Betpoints: 12

    Really appreciate this stuff guys. I also found this in my search. http://www.repole.com/sun4cast/samples/csvpage.html

  7. #7
    rsigley
    rsigley's Avatar Become A Pro!
    Join Date: 02-23-08
    Posts: 304
    Betpoints: 180

    yea np it only took 8 hours or so to get every sport from covers, the ATSLines went much quicker

    once you write the script for one its easy to get them all

    about the quarter scores, that website i looked at it but i only know how to efficiently scrape data that is embedded in HTML

    that website puts the boxscores in a
     tag which seems like it'll be a huge pain to figure out how to scrape it

    that sunshine sites spreads are really off i noticed, i think he is using opening lines for it from the paper.

    i'm working on writing a script that will just automatically update the new csv to the website everyday, but i've been lazy

    the covers lines are also off a lot from the ATSLines ones. I think Covers is more accurate though, but depending on which one you're using you could get big difference in results

  8. #8
    durito
    escarabajo negro
    durito's Avatar Become A Pro!
    Join Date: 07-03-06
    Posts: 13,181

    yep, i'm learning to program now an realizing that if i'd learned this stuff a couple years ago when i was basically making my nfl database (which is basically worthless anyway since i hardly bet nfl anymore) manually i could have saved myself an inordinate amount of time (and money since i paid someone to do it for other leagues). oh well, it should help me tremendously going forward.

    thanks for the scripts, they should help.

  9. #9
    Data
    Data's Avatar Become A Pro!
    Join Date: 11-27-07
    Posts: 2,236

    Quote Originally Posted by rsigley View Post
    about the quarter scores, that website i looked at it but i only know how to efficiently scrape data that is embedded in HTML

    that website puts the boxscores in a
     tag which seems like it'll be a huge pain to figure out how to scrape it
    Seems like you need to search for 12 spaces and then grab the strings on the right after 7th and 9th successful searches.

    Regardless, take a look at this site as well:
    http://www.archive.org/web/web.php

  10. #10
    donjuan
    donjuan's Avatar Become A Pro!
    Join Date: 08-29-07
    Posts: 3,993
    Betpoints: 6675

    Good stuff rsigley. Appreciate it.

  11. #11
    cobra_king
    cobra_king's Avatar SBR PRO
    Join Date: 08-07-06
    Posts: 2,465
    Betpoints: 27653

    Thanks rsigley. Echo the other sentiments here and very much appreciate it.

  12. #12
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    Errors in the NCAAFB ATSLines DB:

    10/1/05, Mich/Mich St, score is reversed, Mich won 34-31
    9/22/07, Mich/Penn St, duplicate entry
    9/24/05, UNC/NC St, score is reversed, UNC won 31-24

  13. #13
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/3/05, Colorado/CSU, score should be 31-28
    9/10/05, Iowa St/Iowa, score should be 23-3

  14. #14
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/25/99, E Carolina/Miami FL, score should be 27-23
    11/13/05, Houston/SMU, away team was So Miss not SMU

  15. #15
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    12/1/07, UCF/Tulsa, score should be 44-23
    8/28/99, Notre Dame/Kansas, score should be 48-13

  16. #16
    rsigley
    rsigley's Avatar Become A Pro!
    Join Date: 02-23-08
    Posts: 304
    Betpoints: 180

    whops yea if its wrong in there its wrong on the website since i didn't manually input the information

    i found a couple errors in the covers db's too in nfl, but i think the one up there is the correct version

  17. #17
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    12/25/00, Arizona/BC, should be Arizona St, not Arizona

  18. #18
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/6/07, Ball St/Central Mich, score should be 38-58

  19. #19
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    11/13/04, Florida/S Carolina, score should be 48-14

  20. #20
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    12/6/03, Georgia/LSU, score should be 13-34

  21. #21
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/29/05, LSU/N Texas, score should be 56-3

  22. #22
    MonkeyF0cker
    Update your status
    MonkeyF0cker's Avatar Become A Pro!
    Join Date: 06-12-07
    Posts: 12,144
    Betpoints: 1126

    Quote Originally Posted by rsigley View Post
    yea np it only took 8 hours or so to get every sport from covers, the ATSLines went much quicker

    once you write the script for one its easy to get them all

    about the quarter scores, that website i looked at it but i only know how to efficiently scrape data that is embedded in HTML

    that website puts the boxscores in a
     tag which seems like it'll be a huge pain to figure out how to scrape it

    that sunshine sites spreads are really off i noticed, i think he is using opening lines for it from the paper.

    i'm working on writing a script that will just automatically update the new csv to the website everyday, but i've been lazy

    the covers lines are also off a lot from the ATSLines ones. I think Covers is more accurate though, but depending on which one you're using you could get big difference in results
    FYI, you should teach yourself one of the Visual Studio languages. It's pretty simple to parse HTML files and mine any tags or sets of tags (even nested ones) using the webbrowser control and regular expressions. The syntax for regular expressions is a bit cumbersome at first. However, once you learn it, it's a powerful tool for parsing. There are also utilities (like RegEx Buddy) that can help you learn and format your string searches.

  23. #23
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/17/05, New Mexico/New Mexico St, score should be 38-21

  24. #24
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/22/97, S Carolina/Kentucky, game does not exist

  25. #25
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    11/27/2004, S Carolina/Georgia Tech, home team should be Georgia

  26. #26
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/5/99, TCU/Arizona, score should be 31-35

  27. #27
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/23/04, UL-Lafayette/Arkansas St, score should be 27-24

  28. #28
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/18/03, UL-Lafayette/New Mexico St, score should be 26-24

  29. #29
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/10/05, Utah/Utah St, score should be 31-7

  30. #30
    turnip
    turnip's Avatar Become A Pro!
    Join Date: 12-03-06
    Posts: 940
    Betpoints: 294

    nice rsigley, thanks for sharing

  31. #31
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    9/18/04, UL-Monroe/Arkansas, line should be +29.5

  32. #32
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    1/2/02, Maryland/Florida, line should be +14.5

  33. #33
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    10/6/01, LSU/Florida, line should be +14

  34. #34
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    1/2/98, Tennessee/Nebraska, line should be +13

  35. #35
    RickySteve
    SBR is a criminal organization
    RickySteve's Avatar Become A Pro!
    Join Date: 01-31-06
    Posts: 3,426
    Betpoints: 186

    12/18/01, N Texas/Colorado St, line should be +11

123 Last
Top