Hello all:
As everyone knows the stock quotes in Yahoo can be downloaded directly
on EXCEL spreadsheet.
we can also use the simple sentence of package tseries of R to download
Yahoo quote:
x <- get.hist.quote(instrument = "ibm", start =
"2010-01-01",
quote = "close")
x
The result will display on the R console. BUT how can we also download
them onto
spreadsheet?
Thank!
--
View this message in context:
http://r.789695.n4.nabble.com/How-download-to-spreadsheet-tp3805182p3805182.html
Sent from the R help mailing list archive at Nabble.com.
require(quantmod)
getSymbols('IBM', from='2010-01-01')
write.csv(Cl(IBM), file='ibm-2010-present.csv')
I can open the resulting file in Excel without problems. Depending on
your preference, you may want to use write.csv2 instead.
On 11 September 2011 06:59, Yumin <zpxykm at gmail.com>
wrote:> ? ?The result will display on the R console. BUT how can we also download
> them onto
> spreadsheet?
--
Sent from my mobile device
Envoyait de mon telephone mobil