Using the Quandl API and Pandas Datareader API to call Microsoft, Apple, Zoom, Snowflake stocks and other finance data
This post includes code adapted from python for finance and trading algorithms udemy course and python for finance and trading algorithms udemy course notebooks.
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
import pandas_datareader.data as web
import datetime
start = datetime.datetime(2020, 1, 1)
end = pd.to_datetime('today')
AAPL_stock = web.DataReader('AAPL', 'yahoo', start, end)
AAPL_stock.head()
MSFT_stock = web.DataReader('MSFT', 'yahoo', start, end)
MSFT_stock.head()
ZOOM_stock = web.DataReader('ZM', 'yahoo', start, end)
ZOOM_stock.head()
SNOW_stock = web.DataReader('SNOW', 'yahoo', start, end)
SNOW_stock.head()
fig = plt.figure(figsize=(12, 6))
plt.title('Open')
MSFT_stock['Open'].plot(label='Microsoft')
ZOOM_stock['Open'].plot(label='Zoom')
SNOW_stock['Open'].plot(label='Snowflake')
AAPL_stock['Open'].plot(label='Apple')
plt.legend()
fig = plt.figure(figsize=(12, 6))
plt.title('Volume')
MSFT_stock['Volume'].plot(label='Microsoft')
ZOOM_stock['Volume'].plot(label='Zoom')
SNOW_stock['Volume'].plot(label='Snowflake')
AAPL_stock['Volume'].plot(label='Apple')
plt.legend()
import pandas_datareader.data as web
import datetime
gdp = web.DataReader("GDP", "fred", start, end)
gdp.head()
import quandl
#quandl.ApiConfig.api_key = ''
mydata = quandl.get("EIA/PET_RWTC_D")
mydata.head()
mydata.plot(figsize=(12,6))
#mydata = quandl.get("EIA/PET_RWTC_D", returns="numpy",start_date=start,end_date=end)
mydata = quandl.get("FRED/GDP",start_date=start,end_date=end)
mydata.head()
mydata = quandl.get(["NSE/OIL.1", "WIKI/AAPL.4"],start_date=start,end_date=end)
mydata.head()
mydata = quandl.get("FRED/GDP")
mydata = quandl.get('WIKI/FB',start_date=start,end_date=end)
mydata.head()
mydata = quandl.get('WIKI/FB.1',start_date=start,end_date=end)
mydata.head()
mydata = quandl.get('WIKI/FB.7',start_date=start,end_date=end)
mydata.head()
# Homes
houses = quandl.get('ZILLOW/M11_ZRIAH',start_date=start,end_date=end)
houses.head()
houses.plot()