error |
Negative Expenses, ignoring company. |
pre-agg |
{'expenses': -2164000} |
error |
Aggregate label 'OtherNoninterestExpense' starts with 'Other' |
input.sec.calculation_linkbase.edgar_model_mapping |
{} |
warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Similarly named company. Duplicate? |
None |
{'details': [{'other_company': 'Commerce Bancshares INC Mo', 'shared_tokens': {'bancshares'}}]} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.44239215828341605, 'aggregate_val': 3186145000, 'exp_sum': 5713953000, 'exp_to_value': {'Deposits': 2527808000, 'LongTermDebt': 559660000, 'LiabilitiesAndBorrowings': 2022170000, 'remainder_Liabilities': 604315000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.43504741546857545, 'aggregate_val': 4382018000, 'exp_sum': 7756435000, 'exp_to_value': {'Deposits': 3374417000, 'LongTermDebt': 660363000, 'LiabilitiesAndBorrowings': 2757291000, 'remainder_Liabilities': 964364000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4326180211125896, 'aggregate_val': 3044890000, 'exp_sum': 5366561000, 'exp_to_value': {'Deposits': 2321671000, 'LongTermDebt': 321035000, 'LiabilitiesAndBorrowings': 1852773000, 'remainder_Liabilities': 871082000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4411292653506859, 'aggregate_val': 2979640000, 'exp_sum': 5331537000, 'exp_to_value': {'Deposits': 2351897000, 'LongTermDebt': 429408000, 'LiabilitiesAndBorrowings': 1793888000, 'remainder_Liabilities': 756344000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.44239215828341605, 'aggregate_val': 3186145000, 'exp_sum': 5713953000, 'exp_to_value': {'Deposits': 2527808000, 'LongTermDebt': 559660000, 'LiabilitiesAndBorrowings': 2022170000, 'remainder_Liabilities': 604315000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.43504741546857545, 'aggregate_val': 4382018000, 'exp_sum': 7756435000, 'exp_to_value': {'Deposits': 3374417000, 'LongTermDebt': 660363000, 'LiabilitiesAndBorrowings': 2757291000, 'remainder_Liabilities': 964364000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000705432')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |