2

the problem is that i can't access quandl data with quandl.get() because it throws an SSLError.

i have tried setting verify = False, and some other things.
this is the code:

    data = quandl.get("EOD/MSFT", authtoken="gyX6Yqxx3xT3hsdSmPva", verify=False)

    Exception has occurred: requests.exceptions.SSLError
    HTTPSConnectionPool(host='www.quandl.com', port=443): Max retries exceeded with url: /api/v3/datasets/EOD/MSFT/data?order=asc&verify=True 
    (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1056)')))
    File"C:\RILEYHQ\my_coding\PYTHON\script_files\graphing\financial\stock_price_data.py", line 29, in <module>
    data = quandl.get("EOD/MSFT", authtoken="gyX6Yqxx3xT3hsdSmPva", verify = True)

what is the cause an fix of an ssl error? is it to do with my internet, the code or the website?

BOBTHEBUILDER
  • 345
  • 1
  • 4
  • 20

3 Answers3

2

Try setting this before your call:

quandl.ApiConfig.verify_ssl = False

That should disable SSL.

If you have a cacert bundle you want to use (e.g. for a proxy server), you can point to it using the same:

quandl.ApiConfig.verify_ssl = <path to cacert bundle>

I had to dig through the code to figure this out--not sure if I missed documentation on it somehow...

Clark Updike
  • 160
  • 1
  • 9
1

I tried your code and got the same error. Then I tried it this way with your key and it worked. Not sure if it will work for you. 

import quandl
quandl.ApiConfig.api_key = 'gyX6Yqxx3xT3hsdSmPva'
data = quandl.get("EOD/MSFT")
data
run-out
  • 3,114
  • 1
  • 9
  • 25
1

I don't know if you still get that error after trying. My answer is it's not only because of the Internet connection, but also the version and how you set up SSL internally, so you need to reset PYTHONHTTPSVERIFY.

I added this block before acquiring https service, and that helped:

import os, ssl

if (not os.environ.get('PYTHONHTTPSVERIFY', '') and getattr(ssl, '_create_unverified_context', None)):
    ssl._create_default_https_context = ssl._create_unverified_context
StanTT
  • 21
  • 3