how do you import data from Pinnacle to Excel?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • robzilla
    SBR MVP
    • 10-25-07
    • 3556

    #1
    how do you import data from Pinnacle to Excel?
    I'm trying to track plays and make some graphs, but I'm having problems importing data from Pinnacle to excel. It doesnt copy and paste properly. Is there a way to do this without manually entering the data myself. I really dont want to do that cuz there are thousands of plays.
  • EasyHustlin
    SBR Wise Guy
    • 07-15-10
    • 633

    #2
    =====> "An introduction to research" <===== (good place to start)
    Comment
    • robzilla
      SBR MVP
      • 10-25-07
      • 3556

      #3
      there has to be an easier way.
      Comment
      • robzilla
        SBR MVP
        • 10-25-07
        • 3556

        #4
        basically all i need to do is d/l a scrapper prog, and extract the data to excel that way?
        Comment
        • MonkeyF0cker
          SBR Posting Legend
          • 06-12-07
          • 12144

          #5
          You can use Excel to scrape the data directly.
          Comment
          • robzilla
            SBR MVP
            • 10-25-07
            • 3556

            #6
            Originally posted by MonkeyF0cker
            You can use Excel to scrape the data directly.
            awesome. thanks monkey.
            Comment
            • mebaran
              SBR MVP
              • 09-16-09
              • 1540

              #7
              Originally posted by MonkeyF0cker
              You can use Excel to scrape the data directly.
              This.

              Web Queries are pretty powerful in Excel if used correctly. Pick yourself up a book about Macros or VBA and you'll have a fairly robust process working.
              Comment
              • TomG
                SBR Wise Guy
                • 10-29-07
                • 500

                #8
                Comment
                • robzilla
                  SBR MVP
                  • 10-25-07
                  • 3556

                  #9
                  Originally posted by MonkeyF0cker
                  You can use Excel to scrape the data directly.
                  i tried to capture my graded bets with excel but it wouldnt work.
                  Comment
                  • MonkeyF0cker
                    SBR Posting Legend
                    • 06-12-07
                    • 12144

                    #10
                    You'll need to learn VBA.
                    Comment
                    • robzilla
                      SBR MVP
                      • 10-25-07
                      • 3556

                      #11
                      Originally posted by MonkeyF0cker
                      You'll need to learn VBA.
                      are u shitting me? that is BS.
                      Comment
                      • durito
                        SBR Posting Legend
                        • 07-03-06
                        • 13173

                        #12
                        You already hit 75% not sure what else you need.
                        Comment
                        • robzilla
                          SBR MVP
                          • 10-25-07
                          • 3556

                          #13
                          there has to be a way to do this without me having to learn to be a programmer.
                          Comment
                          • durito
                            SBR Posting Legend
                            • 07-03-06
                            • 13173

                            #14
                            Try paying a programmer.
                            Comment
                            • robzilla
                              SBR MVP
                              • 10-25-07
                              • 3556

                              #15
                              Originally posted by durito
                              Try paying a programmer.
                              cmon cool ranch. is it cuz pin uses script to show graded bets?
                              Comment
                              • brewers7
                                SBR Sharp
                                • 03-11-06
                                • 298

                                #16
                                robzilla:

                                I have been copying-and-pasting Pinnacle lines into MS-Excel for years...

                                It is EASY and the formatting comes out just fine with a simple little "adjustment" and you don't have to do any VB programming at all...It takes just seconds to make this "adjustment" and any Excel beginner can do it....

                                any questions, elt me know...I can send you or post a sample if need be...
                                Comment
                                • evo34
                                  SBR MVP
                                  • 11-09-08
                                  • 1032

                                  #17
                                  Web queries work fine. E.g., you can import: http://www.pinnaclesports.com/lines....=mlb&periods=1. The only issue (starting this season) with Pinnacle is that you cannot select a single table, so you have to import the entire page; for whatever reason, the first game seems to be located in a slightly different spot every day. I.e., your query may put your useable data in a different row from day to day. Able to be dealt with, but small hassle.
                                  Comment
                                  • uva3021
                                    SBR Wise Guy
                                    • 03-01-07
                                    • 537

                                    #18
                                    use dom to extract each node value via the xml document tree, the dom inspector plugin in firefox facilitates the search for the correct node positions, but its easy to do it visually without any other program

                                    the vba code for transferring xml into memory so you can manipulate the document:

                                    Code:
                                        Dim xmlLoad As New MSXML2.DOMDocument
                                          Dim events As IXMLDOMNode
                                        Dim XMLHttpRequest As MSXML2.xmlhttp
                                        Dim URL As String
                                        
                                        URL = "http://xml.pinnaclesports.com/pinnacleFeed.aspx?sportType=baseball&sportsubType=MLB"
                                        Set XMLHttpRequest = New MSXML2.xmlhttp
                                        XMLHttpRequest.Open "GET", URL, False
                                        XMLHttpRequest.send
                                        Set xmlLoad = New MSXML2.DOMDocument
                                        Do Until xmlLoad.readyState = 4
                                        Loop
                                        xmlLoad.LoadXML (XMLHttpRequest.responseText)
                                    from there its just pointing the node positions to the cells in excel
                                    Comment
                                    SBR Contests
                                    Collapse
                                    Top-Rated US Sportsbooks
                                    Collapse
                                    Working...