import numpy as np
import pandas as pd
from scipy.stats import percentileofscore as score
import math
import requests
import xlsxwriter

df = pd.read_csv('sp_500_stocks.csv')

from secrets import IEX_CLOUD_API_TOKEN

def chunks(lst, n):
    """Yield successive n-sized chunks from lst."""
    for i in range(0, len(lst), n):
        yield lst[i:i + n]

my_columns = ['Ticker',  'Price', 'P/E Ratio', 'Number of Shares To Buy']
new_df = pd.DataFrame(columns=my_columns)