[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