Hi, This works: dataspy['20121003/20121009'] # SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted #2012-10-03 144.89 145.43 144.13 145.09 121283100 145.09 #2012-10-04 145.64 146.34 145.44 146.13 124311600 146.13 #2012-10-05 146.91 147.16 145.70 146.14 124842100 146.14 #2012-10-08 145.60 146.12 145.31 145.64 78415400 145.64 #2012-10-09 145.53 145.65 144.15 144.20 148872900 144.20 This also works: startDate<-"2012-10-03" endDate<-"2012-10-08" startEndDate<-paste(startDate,endDate,sep="::") dataspy[startEndDate,] # SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted #2012-10-03 144.89 145.43 144.13 145.09 121283100 145.09 #2012-10-04 145.64 146.34 145.44 146.13 124311600 146.13 #2012-10-05 146.91 147.16 145.70 146.14 124842100 146.14 #2012-10-08 145.60 146.12 145.31 145.64 78415400 145.64 A.K.
----- Original Message ----- From: veepsirtt <veepsi...@gmail.com> To: r-help@r-project.org Cc: Sent: Friday, November 2, 2012 2:41 PM Subject: Re: [R] Date format conversion from "2012-09-20" to "2012:09:20" Hi R, How to get the range of values form startDate to lastDate as given below?. #***************************************************************** # Load historical data #****************************************************************** library('quantmod') endDate =Sys.Date() startDate = as.Date(endDate-30, order="ymd") dataspy = getSymbols("SPY", from = startDate, to=endDate, auto.assign = FALSE) lastDate=startDate+5 #subset first 5 days dataspy['startDate::lastDate'] print(dataspy) Thanks veepsirtt -- View this message in context: http://r.789695.n4.nabble.com/Date-format-conversion-from-2012-09-20-to-2012-09-20-tp4643710p4648258.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. ______________________________________________ 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.