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.
