Hi all,
I have run into a problem and some help would be highly appreciated.
I have a .csv with the following columns:
Date Time Open High Low Close
1/2/2005 17:05 1.3546 1.3553 1.3546 1.35495
1/2/2005 17:10 1.3553 1.3556 1.3549 1.35525
1/2/2005 17:15 1.3556 1.35565 1.35515 1.3553
1/2/2005 17:25 1.355 1.3556 1.355 1.3555
….
…..
2/13/2006 5:20 1.18895 1.18925 1.18835 1.1885
1) Without using zoo, xts or any other time series object, I am trying to
run this code but fails to pass the argument to the function
#n is the length of the series
for (t in seq(from=10,to=n,by=1))
{
while (time[t]=='02:00:00')
{
entrytrade(t)
}
}
Is this possible to do? If yes, any ideas what I am doing wrong?
2) I have also tried with xts by creating the object like this
lines<-data.frame(date,time,open,high,low,close)
z <- read.zoo(lines, header = TRUE, index = list(1, 2), FUN = function(d,t)
as.POSIXct(paste(date,time), format = "%m/%d/%Y %H:%M"))
x<-as.xts(z)
However, I am unable to call just the time and run the above for loop. any
ideas here?
Thanks
--
View this message in context:
http://r.789695.n4.nabble.com/Time-and-xts-tp3219722p3219722.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.
