R help - Nov 2012 - 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.

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.

head(dataspy, 6) seems easiest.

Cheers,
Michael

On Fri, Nov 2, 2012 at 6:41 PM, veepsirtt <veepsirtt at gmail.com>
wrote:
> 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.