Message-ID: <1351886540.72334.YahooMailNeo@web142606.mail.bf1.yahoo.com>
Date: 2012-11-02T20:02:20Z
From: arun
Subject: Date format conversion from "2012-09-20" to "2012:09:20"
In-Reply-To: <1351881718001-4648258.post@n4.nabble.com>
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 <veepsirtt at gmail.com>
To: r-help at 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 at 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.