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.
how do you import data from Pinnacle to Excel?
Collapse
X
-
robzillaSBR MVP
- 10-25-07
- 3556
#1how do you import data from Pinnacle to Excel?
Tags: None -
EasyHustlinSBR Wise Guy
- 07-15-10
- 633
#2=====> "An introduction to research" <===== (good place to start)Comment -
robzillaSBR MVP
- 10-25-07
- 3556
#3there has to be an easier way.Comment -
robzillaSBR MVP
- 10-25-07
- 3556
#4basically all i need to do is d/l a scrapper prog, and extract the data to excel that way?Comment -
MonkeyF0ckerSBR Posting Legend
- 06-12-07
- 12144
#5You can use Excel to scrape the data directly.Comment -
TomGSBR Wise Guy
- 10-29-07
- 500
-
MonkeyF0ckerSBR Posting Legend
- 06-12-07
- 12144
#10You'll need to learn VBA.Comment -
duritoSBR Posting Legend
- 07-03-06
- 13173
#12You already hit 75% not sure what else you need.Comment -
robzillaSBR MVP
- 10-25-07
- 3556
#13there has to be a way to do this without me having to learn to be a programmer.Comment -
duritoSBR Posting Legend
- 07-03-06
- 13173
#14Try paying a programmer.Comment -
brewers7SBR Sharp
- 03-11-06
- 298
#16robzilla:
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 -
evo34SBR MVP
- 11-09-08
- 1032
#17Web 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 -
uva3021SBR Wise Guy
- 03-01-07
- 537
#18use 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)
Comment
SBR Contests
Collapse
Top-Rated US Sportsbooks
Collapse
#1 BetMGM
4.8/5 BetMGM Bonus Code
#2 FanDuel
4.8/5 FanDuel Promo Code
#3 Caesars
4.8/5 Caesars Promo Code
#4 DraftKings
4.7/5 DraftKings Promo Code
#5 Fanatics
#6 bet365
4.7/5 bet365 Bonus Code
#7 Hard Rock
4.1/5 Hard Rock Bet Promo Code
#8 BetRivers
4.1/5 BetRivers Bonus Code