[robzilla]

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]

=====> "An introduction to research" <===== (good place to start)

[robzilla]

there has to be an easier way.

[robzilla]

basically all i need to do is d/l a scrapper prog, and extract the data to excel that way?

[MonkeyF0cker]

You can use Excel to scrape the data directly.

[robzilla]

You can use Excel to scrape the data directly.

awesome. thanks monkey.

[mebaran]

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.

[TomG]

http://xml.pinnaclesports.com/xmlfeed.asp

[robzilla]

You can use Excel to scrape the data directly.

i tried to capture my graded bets with excel but it wouldnt work.

[MonkeyF0cker]

You'll need to learn VBA.

[robzilla]

You'll need to learn VBA.

are u shitting me? that is BS.

[durito]

You already hit 75% not sure what else you need.

[robzilla]

there has to be a way to do this without me having to learn to be a programmer.

[durito]

Try paying a programmer.

[robzilla]

Try paying a programmer.

cmon cool ranch. is it cuz pin uses script to show graded bets?

[brewers7]

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...

[evo34]

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.

[uva3021]

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:

    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