使用google与iex云api进行关键错误python算法交易

Question

下面是youtube视频中的代码，它使用iex。我一直在跟踪录像，但在这一点上我被困住了。

enter code here
# Function sourced from 
# https://stackoverflow.com/questions/312443/how-do-you-split-a-list-into-evenly-sized- 
  chunks
def chunks(lst, n):
    """Yield successive n-sized chunks from last."""
    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]))
for symbol_string in symbol_strings:
   batch_api_call_url = f'https://sandbox.iexapis.com/stable/stock/market/batch/? 
   types=quote&symbols={symbol_string}&token={IEX_CLOUD_API_TOKEN}'
   data = requests.get(batch_api_call_url).json()
   for symbol in symbol_string.split(','):
       final_dataframe = final_dataframe.append(
                                    pd.Series([symbol, 
                                               data[symbol]['quote']['latestPrice'], 
                                               data[symbol]['quote']['marketCap'], 
                                               'N/A'], 
                                              index = my_columns), 
                                    ignore_index = True)
    

 final_dataframe

我收到一个关键错误，上面说：

enter code 
hereKeyError                                  Traceback (most recent call last)
<ipython-input-16-23716615b418> in <module>()
 12         final_dataframe = final_dataframe.append(
 13                                         pd.Series([symbol, 
 ---> 14                                                    data[symbol]['quote'] 
                                                       ['latestPrice'],
 15                                                    data[symbol]['quote'] 
                                                       ['marketCap'],
 16                                                    'N/A'], 

 KeyError: 'HFC'

Answer 1

 for symbol in symbol_string.split(","):
    if symbol == 'HFC' or symbol == 'VIAC' or symbol == 'WLTW' or symbol == 'DISCA':
       continue
    else:
        final_dataframe=final_dataframe.append(
            pd.Series([
                symbol,
                data[symbol]["quote"]["latestPrice"],
                data[symbol]["quote"]["marketCap"],
                'N/A'
            ],
            index = columns),
            ignore_index=True
        )

Answer 2

我不知道确切原因，但是，跳过这三只股票.

   for symbol in symbol_string.split(','):
       if symbol == 'HFC' or symbol == 'VIAC' or symbol == 'WLTW':
           continue
       final_dataframe = final_dataframe.append(  .....

Answer 3

HFC是一个代码符号，所以我假设IEX没有关于HFC的相关信息，只需从‘股票’代码‘中删除它，或者按照上面的建议跳过它。