R obtaining rownames date using quantmod

r xts quantmod
adam.888 picture adam.888 · Mar 12, 2012 · Viewed 14.8k times · Source

Using quantmod and collecting data from Yahoo. I am trying to get the dates that are in rownames. However I am just getting NULL.

library("quantmod")
sp500 <- new.env()

getSymbols("^GSPC", env = sp500, src = "yahoo",
           from = as.Date("2008-01-04"),  to = Sys.Date())
GSPC <- get("GSPC", envir = sp500)
date1 <- rownames(GSPC)

date1
> NULL

I would be grateful for your help into getting the rowname dates into a vector.

Answer

nograpes picture nograpes · Mar 12, 2012

You need to use the index function. The xts object isn't the same as a normal data.frame, and has its own way of handling dimension names. 

# Return all dates
index(GSPC)

Related questions

Convert daily to weekly/monthly data with R

I have daily prices series over a wide range of products; I want to convert to a new dataframe with weekly or monthly data. I first used xts in order to apply the to.weekly function...which works only for …

Read More
ADD a new column into an XTS object

Hi: I have an xts object as such: AAPL.Open AAPL.High AAPL.Low AAPL.Close AAPL.Volume AAPL.Adjusted 2013-09-09 505.00 507.92 503.48 506.17 12116200 506.17 2013-09-10 506.20 507.45 489.50 494.64 26490200 494.64 2013-09-11 467.01 473.69 464.81 467.71 32031600 467.71 2013-09-12 468.50 475.40 466.01 472.69 14409400 472.69 I try to calculate a rolling mean and attach it to a …

Read More
Longer object length is not a multiple of shorter object length?

I don't understand why R gives me a warning about "Longer object length is not a multiple of shorter object length" I have this object which is generated by doing an aggregate over an xts series giving the weekday median: …

Read More