[R-SIG-Finance] [R-sig-finance] Importing intra day data

ehxpieterse eduard.pieterse at macquarie.com
Fri Aug 7 15:17:52 CEST 2009


Hi,

I am reading intra day data into R using:

EWW <- read.table("EWW.txt", sep=",", header =TRUE)

EWW text file:

"Date","Time","Open","High","Low","Close","Volume"
07/01/1998,10:07:00,12.63,12.63,12.63,12.63,500
07/01/1998,10:27:00,12.75,12.75,12.75,12.75,100
07/01/1998,10:29:00,12.75,12.75,12.75,12.75,100
07/01/1998,11:07:00,12.75,12.75,12.75,12.75,100
07/01/1998,13:49:00,12.75,12.75,12.75,12.75,1000
07/01/1998,14:15:00,12.94,12.94,12.94,12.94,600

I think I am having trouble converting the data to xts type, due to the date
and time fields being contained in seperate variables. 

> EWW.xts <- as.xts(EWW)
Error in as.POSIXlt.character(x, tz, ...) : 
  character string is not in a standard unambiguous format

Has anyone come across a similar problem before?

Thanks,
Eduard

-- 
View this message in context: http://www.nabble.com/Importing-intra-day-data-tp24864718p24864718.html
Sent from the Rmetrics mailing list archive at Nabble.com.



More information about the R-SIG-Finance mailing list