Marius Hofert
2012-Nov-23 03:38 UTC
[R] Constant (= wrong) historical quotes via get.hist.quote() from yahoo.finance
Dear expeRts, I would like to download a time series of historical data from the ticker with symbol "ROG.VX". Interestingly, I obtain constant values (138.3 for each day in the chosen period) although the yahoo.finance website tells me that the time series is not at all constant. What's wrong? Cheers, Marius require(tseries) hq <- get.hist.quote(instrument="ROG.VX", start="2011-09-09", end="2012-03-28", quote="Close", provider="yahoo", drop=TRUE) plot(hq) # => constant stopifnot(hq==138.3) # => constant 138.3 ## However, under finance.yahoo.com/q/hp?s=ROG.VX&a=08&b=09&c=2011&d=02&e=28&f=2012&g=d&z=66&y=132 ## the historical prices are not all equal to 138.3 -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 835 bytes Desc: not available URL: <stat.ethz.ch/pipermail/r-help/attachments/20121123/677e6098/attachment-0002.bin>
Achim Zeileis
2012-Nov-23 10:08 UTC
[R] Constant (= wrong) historical quotes via get.hist.quote() from yahoo.finance
On Fri, 23 Nov 2012, Marius Hofert wrote:> Dear expeRts, > > I would like to download a time series of historical data from the > ticker with symbol "ROG.VX". Interestingly, I obtain constant values > (138.3 for each day in the chosen period) although the yahoo.finance > website tells me that the time series is not at all constant. What's > wrong?Yahoo! Finance.> require(tseries) > hq <- get.hist.quote(instrument="ROG.VX", start="2011-09-09", end="2012-03-28", > quote="Close", provider="yahoo", drop=TRUE) > plot(hq) # => constant > stopifnot(hq==138.3) # => constant 138.3 > ## However, under finance.yahoo.com/q/hp?s=ROG.VX&a=08&b=09&c=2011&d=02&e=28&f=2012&g=d&z=66&y=132 > ## the historical prices are not all equal to 138.3It's true that that web page displays the prices correctly. However, if you click on "Download to Spreadsheet" you also get the constant 138.3 prices. And the spreadsheet functionality is what get.hist.quote() and other R interface to Yahoo! Finance use. Hence, you either have to process the HTML table or have to hope that Yahoo! Finance fixes the problem. Not sure whether they have functionality to report such problems... Best, Z