Re: [R] zoo.read intraday data

2010-12-22 Thread sl z
Dear Gabor, many thanks for the quick reply. for the sake of a working example in list archive, code below reads a csv with 5 min intraday bars and converts it to a quantmod::barChart_able xts object ##csv file 5min bars with the format below #,, #ICE.BRN,ice.brn_m5,5,20100802,10:40:00,

Re: [R] zoo.read intraday data

2010-12-22 Thread Gabor Grothendieck
On Tue, Dec 21, 2010 at 11:36 PM, szimine wrote: > > Hi Gabor et al. > > the >  f3 <- function(...) as.POSIXct(paste(...), format = "%Y%m%d %H:%M:%S" ) > > helped me to read intraday data from file > ## > ,, > ICE.BRN,ice.brn_m5,5,20100802,10:40:00,79.21000,79.26000,79.16000,79.2,2

Re: [R] zoo.read intraday data

2010-12-21 Thread szimine
Hi Gabor et al. the f3 <- function(...) as.POSIXct(paste(...), format = "%Y%m%d %H:%M:%S" ) helped me to read intraday data from file ## ,, ICE.BRN,ice.brn_m5,5,20100802,10:40:00,79.21000,79.26000,79.16000,79.2,238,0 ICE.BRN,ice.brn_m5,5,20100802,10:45:00,79.19000,79.26000,79.

Re: [R] zoo.read intraday data

2010-10-25 Thread Gabor Grothendieck
On Mon, Oct 25, 2010 at 11:44 AM, Immanuel wrote: > Thanks, > > by now I ran already into the next problem, while trying to convert > the zoo to an xts object. > Somehow the timestamps get lost, no idea why. > > I did read through the vignettes, but got confused > by all this, chron, as.POSIXct, z

Re: [R] zoo.read intraday data

2010-10-25 Thread Immanuel
Thanks, by now I ran already into the next problem, while trying to convert the zoo to an xts object. Somehow the timestamps get lost, no idea why. I did read through the vignettes, but got confused by all this, chron, as.POSIXct, zoo and xts stuff. with your example I got: Error in .subset(x, j

Re: [R] zoo.read intraday data

2010-10-25 Thread Gabor Grothendieck
On Mon, Oct 25, 2010 at 9:02 AM, Immanuel wrote: > Hello all, > > I'm trying to use zoo.read but can't figure out > how to deal with the time format. (example below) > > would be nice if someone could help. > > best regards, > Immanuel > > --- > L <- "Date,Time,Open,High,Lo

Re: [R] zoo.read intraday data

2010-10-25 Thread Immanuel
Hey, work's like a charm. thanks __ 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

Re: [R] zoo.read intraday data

2010-10-25 Thread Achim Zeileis
On Mon, 25 Oct 2010, Immanuel wrote: Hello all, I'm trying to use zoo.read Just for the record: read.zoo(). but can't figure out how to deal with the time format. (example below) Yes, the problem is only the chron conversion (and not read.zoo). would be nice if someone could help. best

[R] zoo.read intraday data

2010-10-25 Thread Immanuel
Hello all, I'm trying to use zoo.read but can't figure out how to deal with the time format. (example below) would be nice if someone could help. best regards, Immanuel --- L <- "Date,Time,Open,High,Low,Close,Up,Down 05.02.2001,00:30,421.20,421.20,421.20,421.20,1