
* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.
* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

작성한 코드 및 에러 메세지
from yahooquery import Ticker
import pandas as pd
def add_company(code):
company = Ticker(code)
modules = 'summaryDetail assetProfile price financialData defaultKeyStatistics'
all_data = company.get_modules(modules)
name = all_data[code]['price']['shortName']
marketcap = all_data[code]['price']['marketCap']
industry = all_data[code]['assetProfile']['industry']
revenue = all_data[code]['financialData']['totalRevenue']
summary = all_data[code]['assetProfile']['longBusinessSummary']
current = all_data[code]['financialData']['currentPrice']
meanprice = all_data[code]['financialData']['targetMeanPrice']
per = all_data[code]['summaryDetail']['trailingPE']
eps = all_data[code]['defaultKeyStatistics']['trailingEps']
pbr = all_data[code]['defaultKeyStatistics']['priceToBook']
doc = company.earnings[code]['financialsChart']['yearly']
df = pd.DataFrame(doc)
rev2019 = df.iloc[0,1] /1000
rev2020 = df.iloc[1,1] /1000
rev2021 = df.iloc[2,1] /1000
ear2019 = df.iloc[0,2] /1000
ear2020 = df.iloc[1,2] /1000
ear2021 = df.iloc[2,2] /1000
doc = {
'code':code,
'name':name,
'industry':industry,
'marketCap':marketcap/1000,
'currentPrice':currentPrice,
'targetPrice':targetPrice,
'per':per,
'eps':eps,
'pbr':pbr,
'rev2021':rev2021/1000,
'rev2020':rev2020/1000,
'rev2019':rev2019/1000,
'ear2021':ear2021/1000,
'ear2020':ear2020/1000,
'ear2019':ear2019/1000,
}
return doc
df = pd.DataFrame()
codes = ['AAPL','ABNB','BIDU','META','GOOG','MSFT','TSLA','PYPL','NFLX','NVDA']
for code in codes:
try:
row = add_company(code)
df = df.append(row, ignore_index = True)
except:
print(f'error - {code}')
df
