madeleine68

with open("sp500tickers.pickle", "rb") as f:
        tickers = pickle.load(f)
if not os.path.exists('stock_dfs'):
        os.makedirs('stock_dfs')

madeleine68

import datetime as dt
import os
import pandas_datareader.data as pdr

madeleine68

with open("sp500tickers.pickle", "wb") as f:   
        pickle.dump(tickers, f)

madeleine68

tickers = []
for row in table.findAll('tr')[1:]:
        ticker = row.findAll('td')[0].text
        ticker = ticker[:-1]
        tickers.append(ticker)

madeleine68

html = requests.get('http://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
soup = bs.BeautifulSoup(html.text, 'lxml')
table = soup.find('table', {'class': 'wikitable sortable'})

madeleine68

import bs4 as bs
import pickle
import requests