error |
Negative Expenses, ignoring company. |
pre-agg |
{'expenses': -12013000} |
warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 5.256909992912828, 'aggregate_val': -12013000, 'exp_sum': 2822000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1744000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 13091000, 'Taxes': 0, 'OperatingExpenses': -6062000, 'remainder_Expenses': -5951000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.27140090198351546, 'aggregate_val': 51536000, 'exp_sum': 70733000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 2890000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 16307000, 'Taxes': 0, 'OperatingExpenses': 46395000, 'remainder_Expenses': 5141000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.28919853527620754, 'aggregate_val': 244193000, 'exp_sum': 343546000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 479000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 98874000, 'Taxes': 0, 'OperatingExpenses': 244008000, 'remainder_Expenses': 185000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3768493398444565, 'aggregate_val': 137816000, 'exp_sum': 221160000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1567000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 81777000, 'Taxes': 0, 'OperatingExpenses': 138006000, 'remainder_Expenses': -190000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.381974476759412, 'aggregate_val': 174633000, 'exp_sum': 282566000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 20446000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 87487000, 'Taxes': 0, 'OperatingExpenses': 174633000, 'remainder_Expenses': 0}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000061398')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |