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 <ja...@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]] ______________________________________________ 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.