title: Pulling specific value from Pandas DataReader dataframe?
body: <p>Here is the code I am running:</p>
  
  <pre><code>def competitor_stock_data_report():
      import datetime
      import pandas_datareader.data as web
  
      date_time = datetime.datetime.now()
      date = date_time.date()
  
      stocklist = ['LAZ','AMG','BEN','LM','EVR','GHL','HLI','MC','PJT','MS','GS','JPM','AB']
      start = datetime.datetime(date.year-1, date.month, date.day-1)
      end = datetime.datetime(date.year, date.month, date.day-1)
  
      for x in stocklist:
          df = web.DataReader(x, 'google', start, end)
          print(df)
          print(df.loc[df['Date'] == start]['Close'].values)
  </code></pre>
  
  <p>The problem is in the last line. How do I pull the specific value of the date specified 'Close' value?</p>
  
  <pre><code>             Open   High    Low  Close   Volume
  Date                                           
  2016-08-02  35.22  35.25  33.66  33.75   861111
  2016-08-03  33.57  34.72  33.42  34.25   921401
  2016-08-04  33.89  34.22  33.77  34.07   587016
  2016-08-05  34.55  34.94  34.31  34.35   463317
  2016-08-08  34.54  34.75  34.31  34.74   958230
  2016-08-09  34.68  35.12  34.64  34.87   732959
  </code></pre>
  
  <p>I would like to get <code>33.75</code> for example, but the date is dynamically changing..</p>
  
  <p>Any suggestions?</p>