Historical Database: Spreads/Totals

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ferbs027
    SBR Rookie
    • 08-14-08
    • 46

    #1
    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!
  • Peep
    SBR MVP
    • 06-23-08
    • 2295

    #2
    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.
    Comment
    • rsigley
      SBR Sharp
      • 02-23-08
      • 304

      #3
      i posted most of them here



      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

      Comment
      • Data
        SBR MVP
        • 11-27-07
        • 2236

        #4
        Originally posted by rsigley
        i posted most of them here



        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.
        World Biggest Gambler Portal. Deals, Sports betting, Online Casino, Lottery, Horseracing. Free Slot Games and Live Score with Best Offers
        Comment
        • durito
          SBR Posting Legend
          • 07-03-06
          • 13173

          #5
          Originally posted by rsigley
          i posted most of them here



          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.
          Comment
          • ferbs027
            SBR Rookie
            • 08-14-08
            • 46

            #6
            Really appreciate this stuff guys. I also found this in my search. http://www.repole.com/sun4cast/samples/csvpage.html
            Comment
            • rsigley
              SBR Sharp
              • 02-23-08
              • 304

              #7
              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 <pre> 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
              Comment
              • durito
                SBR Posting Legend
                • 07-03-06
                • 13173

                #8
                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.
                Comment
                • Data
                  SBR MVP
                  • 11-27-07
                  • 2236

                  #9
                  Originally posted by rsigley
                  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 <pre> 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:
                  Comment
                  • donjuan
                    SBR MVP
                    • 08-29-07
                    • 3993

                    #10
                    Good stuff rsigley. Appreciate it.
                    Comment
                    • cobra_king
                      SBR MVP
                      • 08-07-06
                      • 2491

                      #11
                      Thanks rsigley. Echo the other sentiments here and very much appreciate it.
                      Comment
                      • RickySteve
                        Restricted User
                        • 01-31-06
                        • 3415

                        #12
                        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
                        Comment
                        • RickySteve
                          Restricted User
                          • 01-31-06
                          • 3415

                          #13
                          9/3/05, Colorado/CSU, score should be 31-28
                          9/10/05, Iowa St/Iowa, score should be 23-3
                          Comment
                          • RickySteve
                            Restricted User
                            • 01-31-06
                            • 3415

                            #14
                            9/25/99, E Carolina/Miami FL, score should be 27-23
                            11/13/05, Houston/SMU, away team was So Miss not SMU
                            Comment
                            • RickySteve
                              Restricted User
                              • 01-31-06
                              • 3415

                              #15
                              12/1/07, UCF/Tulsa, score should be 44-23
                              8/28/99, Notre Dame/Kansas, score should be 48-13
                              Comment
                              • rsigley
                                SBR Sharp
                                • 02-23-08
                                • 304

                                #16
                                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
                                Comment
                                • RickySteve
                                  Restricted User
                                  • 01-31-06
                                  • 3415

                                  #17
                                  12/25/00, Arizona/BC, should be Arizona St, not Arizona
                                  Comment
                                  • RickySteve
                                    Restricted User
                                    • 01-31-06
                                    • 3415

                                    #18
                                    10/6/07, Ball St/Central Mich, score should be 38-58
                                    Comment
                                    • RickySteve
                                      Restricted User
                                      • 01-31-06
                                      • 3415

                                      #19
                                      11/13/04, Florida/S Carolina, score should be 48-14
                                      Comment
                                      • RickySteve
                                        Restricted User
                                        • 01-31-06
                                        • 3415

                                        #20
                                        12/6/03, Georgia/LSU, score should be 13-34
                                        Comment
                                        • RickySteve
                                          Restricted User
                                          • 01-31-06
                                          • 3415

                                          #21
                                          10/29/05, LSU/N Texas, score should be 56-3
                                          Comment
                                          • MonkeyF0cker
                                            SBR Posting Legend
                                            • 06-12-07
                                            • 12144

                                            #22
                                            Originally posted by rsigley
                                            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 <pre> 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.
                                            Comment
                                            • RickySteve
                                              Restricted User
                                              • 01-31-06
                                              • 3415

                                              #23
                                              9/17/05, New Mexico/New Mexico St, score should be 38-21
                                              Comment
                                              • RickySteve
                                                Restricted User
                                                • 01-31-06
                                                • 3415

                                                #24
                                                10/22/97, S Carolina/Kentucky, game does not exist
                                                Comment
                                                • RickySteve
                                                  Restricted User
                                                  • 01-31-06
                                                  • 3415

                                                  #25
                                                  11/27/2004, S Carolina/Georgia Tech, home team should be Georgia
                                                  Comment
                                                  • RickySteve
                                                    Restricted User
                                                    • 01-31-06
                                                    • 3415

                                                    #26
                                                    9/5/99, TCU/Arizona, score should be 31-35
                                                    Comment
                                                    • RickySteve
                                                      Restricted User
                                                      • 01-31-06
                                                      • 3415

                                                      #27
                                                      10/23/04, UL-Lafayette/Arkansas St, score should be 27-24
                                                      Comment
                                                      • RickySteve
                                                        Restricted User
                                                        • 01-31-06
                                                        • 3415

                                                        #28
                                                        10/18/03, UL-Lafayette/New Mexico St, score should be 26-24
                                                        Comment
                                                        • RickySteve
                                                          Restricted User
                                                          • 01-31-06
                                                          • 3415

                                                          #29
                                                          9/10/05, Utah/Utah St, score should be 31-7
                                                          Comment
                                                          • turnip
                                                            SBR Wise Guy
                                                            • 12-03-06
                                                            • 940

                                                            #30
                                                            nice rsigley, thanks for sharing
                                                            Comment
                                                            • RickySteve
                                                              Restricted User
                                                              • 01-31-06
                                                              • 3415

                                                              #31
                                                              9/18/04, UL-Monroe/Arkansas, line should be +29.5
                                                              Comment
                                                              • RickySteve
                                                                Restricted User
                                                                • 01-31-06
                                                                • 3415

                                                                #32
                                                                1/2/02, Maryland/Florida, line should be +14.5
                                                                Comment
                                                                • RickySteve
                                                                  Restricted User
                                                                  • 01-31-06
                                                                  • 3415

                                                                  #33
                                                                  10/6/01, LSU/Florida, line should be +14
                                                                  Comment
                                                                  • RickySteve
                                                                    Restricted User
                                                                    • 01-31-06
                                                                    • 3415

                                                                    #34
                                                                    1/2/98, Tennessee/Nebraska, line should be +13
                                                                    Comment
                                                                    • RickySteve
                                                                      Restricted User
                                                                      • 01-31-06
                                                                      • 3415

                                                                      #35
                                                                      12/18/01, N Texas/Colorado St, line should be +11
                                                                      Comment
                                                                      SBR Contests
                                                                      Collapse
                                                                      Top-Rated US Sportsbooks
                                                                      Collapse
                                                                      Working...