Screen scraping/Excel help!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • twister
    SBR Sharp
    • 09-09-08
    • 405

    #1
    Screen scraping/Excel help!
    Currently, I am manually inputting data from the covers.com scoreboard (http://scores.covers.com/baseball-sc...chups.aspx?t=0) into excel. It is taking me an age to do it, as I am trying to get the whole seasons worth. Even worse, is the fact that I want to do this for the previous 2/3 seasons too. So manually doing it would take me quite forever.

    So if anyone can help me get the data from covers (or any other site that provides, by date, the matchups + score + closing pinnacle line) into my excel file in the following format, I'd be very grateful.
  • Grind-It-Out
    SBR Wise Guy
    • 05-04-10
    • 537

    #2
    I'll take a look at it. Probably would be really easy with php/cURL.
    Comment
    • twister
      SBR Sharp
      • 09-09-08
      • 405

      #3
      Originally posted by Grind-It-Out
      I'll take a look at it. Probably would be really easy with php/cURL.
      Thanks, exactly what I wanted to hear!
      Comment
      • Grind-It-Out
        SBR Wise Guy
        • 05-04-10
        • 537

        #4
        It looks like Covers does all of their information with Ajax calls which isn't a good sign as far as complexity goes. Do you know of any other sites that offer the information you want?
        Comment
        • twister
          SBR Sharp
          • 09-09-08
          • 405

          #5
          Aah, damn. I can't think of any other sites that have the information I want. SBR has a scoreboard feature too, but they don't use the pinnacle closing line, same with TheRX. Not sure where else to look... Thanks for trying anyway.
          Comment
          • uva3021
            SBR Wise Guy
            • 03-01-07
            • 537

            #6
            probably statfox
            Comment
            • skrtelfan
              SBR MVP
              • 10-09-08
              • 1913

              #7
              If you go to the individual team pages, highlight the data and paste it into Excel as unicode text, that'll only take 30 cut and pastes per season, which isn't too terribly tedious.
              Comment
              • unusialsusp5
                SBR MVP
                • 04-18-10
                • 4198

                #8
                don't waste your time. it won't help you win baseball bets. just pick the 3 best road team underdogs you can find everyday for whatever reason and you will be suprised how many times you win 2 of them.
                Comment
                • Maverick22
                  SBR Wise Guy
                  • 04-10-10
                  • 807

                  #9
                  Originally posted by skrtelfan
                  If you go to the individual team pages, highlight the data and paste it into Excel as unicode text, that'll only take 30 cut and pastes per season, which isn't too terribly tedious.
                  But doing that every day? On top of EVERYTHING else he is doing?
                  Comment
                  • skrtelfan
                    SBR MVP
                    • 10-09-08
                    • 1913

                    #10
                    For every day data collection it's way too tedious, but it sounded to me like he was trying to get the entire 2009 season into a database. If you only need to grab entire seasons at a time, it isn't the worst thing in the world.
                    Comment
                    SBR Contests
                    Collapse
                    Top-Rated US Sportsbooks
                    Collapse
                    Working...