Get data from Yahoo! Finance to R

Question

I am trying to get data from Yahoo! Finance to R

I've installed quantmod like that:

install.packages("quantmod", repos="http://R-Forge.R-project.org")

But when I try this:

getQuote("QQQQ;SPY", what=yahooQF("Last Trade (Price Only)"))

I see:

Error in download.file(paste("http://finance.yahoo.com/d/quotes.csv?
s=",  : 
cannot open URL 'http://finance.yahoo.com/d/quotes.csv?
s=QQQQ+SPY&f=d1t1l1'
In addition: Warning message:
In download.file(paste("http://finance.yahoo.com/d/quotes.csv?s=",  :
URL 'http://download.finance.yahoo.com/d/quotes.csv?
s=QQQQ+SPY&f=d1t1l1': status was 'Couldn't resolve host name'

getSymbols("YHOO",src="google") # from google finance --------- financegetSymbols("GOOG",src="yahoo") # from yahoo finance ------ https://www.quantmod.com/examples/intro/ — Andryas Waurzenczak, Feb 02 '18 at 13:37
@ Andryas Waurzenczak. Thanks. It works! How to get not daily quotes? — Oktu, Feb 03 '18 at 16:27
Use functions, to.weekly , to.year see the link in my first comment. — Andryas Waurzenczak, Feb 03 '18 at 17:07
@Andryas Waurzenczak, Is something wrong with GOOGL method now? — Oktu, Mar 16 '18 at 12:53
cannot open URL 'http://finance.google.com/finance/historical?q=GOOGL&startdate=Jan+01,+2007&enddate=Mar+16,+2018&output=csv': HTTP status was '403 Forbidden' — Oktu, Mar 16 '18 at 12:55

score 1 · Answer 1 · answered Sep 23 '19 at 19:40

To answer the specific question asked:

getSymbols("QQQ;SPY", from="1997-12-31", src='yahoo')

works just fine - you get two xts series, QQQ and SPY (note that QQQQ is "dead" and replaced with QQQ), with 6 columns Open, High, Low, Close, Volume, Adjusted.
It looks like you only want the close? If so, you can get just that series with

Cl(QQQ)

If you don't like auto-assignment, you can use

qqq.data <- getSymbols("QQQ", auto.assign=FALSE, from="1997-12-31", src='yahoo')

to assign the downloaded data to a variable of your choice. Note that most people would probably be interested in the adjusted price instead, if so, you can select it with

Ad(QQQ)

Finally, indeed, as pointed out, google finance no longer provides data through its API.

score 0 · Answer 2 · edited Aug 02 '18 at 10:49

0

getSymbols("AAPL",src="google") has been deprecated.

Error: ‘getSymbols.google’ is defunct. Google Finance stopped providing data in March, 2018. You could try setting src = "yahoo" instead. See help("Defunct") and help("quantmod-defunct")

edited Aug 02 '18 at 10:49

Jens Habegger

5,266
41
57

answered Aug 02 '18 at 01:14

andrew.paul.acosta

7
5

1

Thanks, Andrew. This is useful information. Although, it doesn't answer the OP's question and would have been better suited as a comment. – Graeme Walsh Aug 22 '18 at 14:14

Get data from Yahoo! Finance to R

2 Answers2

Linked