Thank you, I will have to wait until I get home form work to test the XML. But I'm looking to do something more along the lines of an automated process over copy and pasting. 

James


________________________________
 From: "Adams, Jean" <jvadams@usgs.gov>
To: jcrosbie <james@crosb.ie> 
Cc: R help <r-help@r-project.org> 
Sent: Wednesday, May 29, 2013 6:50 AM
Subject: Re: [R] Download data



I tried reading in the data using the XML package, but I can't figure out how to read either ALL of the tables or a particular table.  The code below just reads the first table.  Maybe someone else will know how.

Jean



library(XML)
look <- readHTMLTable("http://www.ngx.com/settlehistory.html")
head(look[[1]])
                                          V1         V2         V3 V4 V5 V6 V7 V8       V9 V10
1 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-05-01 2013-05-31  0             -16.0000    
2 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-06-01 2013-06-30  0             -18.2500    
3 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-07-01 2013-07-31  0             -19.7500    
4 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-08-01 2013-08-31  0             -21.2500    
5 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-09-01 2013-09-30  0             -22.7500    
6 Crude Firm Phys AHS, ID, WTI, Edm-Enbridge 2013-10-01 2013-10-31  0             -23.0000    




On Tue, May 28, 2013 at 11:02 AM, jcrosbie <james@crosb.ie> wrote:

Hi, I'm trying to download data from:
>http://www.ngx.com/settlehistory.html
>
>Is it possible to fetch the data with R?
>
>Thank you
>
>
>
>--
>View this message in context: http://r.789695.n4.nabble.com/Download-data-tp4668138.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>R-help@r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]

