quandl-example.py

# Author: James Campbell
# Date Created: May 21st 2016
# Date Updated: 2 July 2019
# What: Example to get stock prices
from sys import exit
try:
    import quandl
except Exception:
    exit('quandl module required, run pip or pip3 install quandl --update')
try:
    from configs import myqkey
except Exception:
    print('no configs file set, create a file called configs.py and add var myqkey = "whatever"')
    myqkey = 'yoursecretkeyfromquandl.com'
# set API key
quandl.ApiConfig.api_key = myqkey  # get free key at quandl.com

dataset_data = quandl.Dataset('WIKI/AAPL').data(params={'start_date': '2001-01-01',
                                                        'end_date': '2010-01-01',
                                                        'collapse': 'annual',
                                                        'transformation': 'rdiff', 'rows': 4})
print('first date: {}'.format(dataset_data[0].date))
print('Total days of stock data available: {}'.format(len(dataset_data)))
print('The data includes the following columns: {}'.format(dataset_data.column_names))