title: How would you apply a For Loop, a pandas dataframe and a function that takes in multiple variables?
body: <p>I was wondering how someone would apply a for loop to a function that scrapes options prices?</p>
  <pre><code>from wallstreet import Stock, Call, Put
  import pandas as pd
  
  g = Call('CQP', d=17, m=7, y=2020, strike=40)
  
  df = g.price
  
  print(df)
  
  
  0.2
  </code></pre>
  <p>I was hoping I could create a For Loop that iterates through this spread sheet:
  <a href="https://docs.google.com/spreadsheets/d/1NeejZFvExsnHeH-XLIgMU8gAf8iRQYD6-5pAiTSvkKY/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1NeejZFvExsnHeH-XLIgMU8gAf8iRQYD6-5pAiTSvkKY/edit?usp=sharing</a></p>
  <p>So far I have something like:</p>
  <pre><code>from wallstreet import Stock, Call, Put
  import pandas as pd
  
  df = pd.read_excel('C:/Users/User/Downloads/Options List.xlsx', sheet_name='Sheet1')
  
  tickers_list = df['Ticker'].tolist()
  
  options = pd.DataFrame(rows=tickers_list)
  
  for ticker in tickers_list:
  options[ticker] = Call(Ticker, d=Day, m=Month, y=Year, strike=Strike).prices
  
  print(options)
  
  </code></pre>
  <p>I know that this is wrong but for the life of me, I cant make sense of how to run multiple variables though this thing.</p>