'Why is my data from IEX Cloud API Token not going through?
On Jupyter Notebook:
Whenever, I run this code it says N/A for the Number of Shares to Buy section. I followed this tutorial on youtube: https://www.youtube.com/watch?v=xfzGZB4HhEE&t=5656s. Any suggestions on what I should change. I have spent days looking at the code and can't find a solution.
from secrets import IEX_CLOUD_API_TOKEN
symbol='AAPL'
api_url = f'https://sandbox.iexapis.com/stable/stock/{symbol}/quote?token={IEX_CLOUD_API_TOKEN}'
data = requests.get(api_url).json()
data
data['latestPrice']
data['marketCap']
my_columns = ['Ticker', 'Price','Market Capitalization', 'Number Of Shares to Buy']
final_dataframe = pd.DataFrame(columns = my_columns)
final_dataframe
final_dataframe = final_dataframe.append(
pd.Series(['AAPL',
data['latestPrice'],
data['marketCap'],
'N/A'],
index = my_columns),
ignore_index = True)
final_dataframe
final_dataframe = pd.DataFrame(columns = my_columns)
for symbol in stocks['Ticker']:
api_url = f'https://sandbox.iexapis.com/stable/stock/{symbol}/quote?token={IEX_CLOUD_API_TOKEN}'
data = requests.get(api_url).json()
final_dataframe = final_dataframe.append(
pd.Series([symbol,
data['latestPrice'],
data['marketCap'],
'N/A'],
index = my_columns),
ignore_index = True)
final_dataframe
def chunks(lst, n):
"""Yield successive n-sized chunks from lst."""
for i in range(0, len(lst), n):
yield lst[i:i + n]
symbol_groups = list(chunks(stocks['Ticker'], 100))
symbol_strings = []
for i in range(0, len(symbol_groups)):
symbol_strings.append(','.join(symbol_groups[i]))
# print(symbol_strings[i])
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
