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.
