blog2_20190723-mlb-data-collection.py

# this blog of code allows me to import my secrets file from the conf folder in my 
# current jupyter notebook
root_dir = os.path.join(os.getcwd(), '..')
sys.path.append(root_dir)

from conf import secrets

# Download data as CSV from API 
function = 'TIME_SERIES_DAILY_ADJUSTED'
symbol = 'MSFT'
datatype = 'csv'
url = f"https://www.alphavantage.co/query?function={function}&symbol={symbol}&\
      datatype={datatype}&apikey={ALPHA_VANTAGE_KEY}"
msft_raw = pd.read_csv(url)

# before making any changes save this to raw data folder
msft_raw.to_csv('../data/01_raw/msft_raw.csv', index=False)