Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

It seems that Google does no longer provide historical stock data? #391

Closed
paintdog opened this issue Sep 8, 2017 · 7 comments
Closed

Comments

@paintdog
Copy link

paintdog commented Sep 8, 2017

It seems that Google does no longer provide historical stock data respectively Google does no longer update the data. Is this correct? Is there a solution? Will there be any other sources (in the near future)?

With pandas-datareader and source "google" you can only get data until 2017-09-05 :(

import pandas_datareader.data as wb
import datetime

web_df = wb.DataReader("ETR:DAI", 'google',
                       datetime.date(2017,9,1),
                       datetime.date(2017,9,9))

print(web_df)
@rsvp
Copy link

rsvp commented Sep 8, 2017

Confirmation and alternatives: rsvp/fecon235#7
seeking solutions to merge into pandas_datareader

Several years ago Google terminated their quote retrieval API for sheets,
but there was enough public backslash that it was reinstated.
So the current JSON termination might not be final.

@paintdog
Copy link
Author

paintdog commented Sep 9, 2017

Update!

With the source code above you will now get the following result:

             Open   High    Low  Close   Volume
Date                                           
2017-09-01  61.38  62.16  61.22  61.80  3042884
2017-09-04  61.40  62.01  61.31  61.84  1802854
2017-09-05  62.01  62.92  61.77  62.42  3113816
2017-09-08  64.59  65.40  64.53  64.83  2733424

This means to me that google has not stopped the data delivering at all; there are now 2 dates without data...

@paintdog
Copy link
Author

Since two days Google only delivers data for one year, this means you can get with pandas only data from 2016-09-16 till 2017-09-14, which is not so great.

@lmclupr
Copy link

lmclupr commented Sep 15, 2017

I hav the same issue. I only get one year of data, being the last year, regardless of start/end dates. Is this permanent, or a throttling issue?

@godknowspe
Copy link

I just did some research on this issue and post the result here:
https://stackoverflow.com/questions/46259528/datareader-google-finance-date-not-working/46356247#46356247

Google still offer the historical stock data, but the URL has changed.

@rsvp
Copy link

rsvp commented Sep 22, 2017

But unfortunately, for the PR to modify said URL, eac67a4 ,
the required Travis CI build has failed.

@bashtage
Copy link
Contributor

As of v0.7.0 Google finance and Morningstar have been immediately deprecated due to large changes in their API and no stable replacement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants