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.44012761365085146, 'aggregate_val': 5743957000, 'exp_sum': 10259404000, 'exp_to_value': {'Deposits': 4515447000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3530706000, 'remainder_Liabilities': 2213251000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.45074105911512946, 'aggregate_val': 5392203000, 'exp_sum': 9817233000, 'exp_to_value': {'Deposits': 4425030000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3513427000, 'remainder_Liabilities': 1878776000}} |
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 |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.42276494282539206, 'aggregate_val': 4718014000, 'exp_sum': 8173471000, 'exp_to_value': {'Deposits': 3455407000, 'LongTermDebt': 562592000, 'LiabilitiesAndBorrowings': 2818195000, 'remainder_Liabilities': 1337277000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41184910909966455, 'aggregate_val': 5045493000, 'exp_sum': 8578569000, 'exp_to_value': {'Deposits': 3533076000, 'LongTermDebt': 601464000, 'LiabilitiesAndBorrowings': 2873338000, 'remainder_Liabilities': 1570691000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.44012761365085146, 'aggregate_val': 5743957000, 'exp_sum': 10259404000, 'exp_to_value': {'Deposits': 4515447000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3530706000, 'remainder_Liabilities': 2213251000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.45074105911512946, 'aggregate_val': 5392203000, 'exp_sum': 9817233000, 'exp_to_value': {'Deposits': 4425030000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3513427000, 'remainder_Liabilities': 1878776000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000705432')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |