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'}}, {'other_company': 'First Financial Bankshares INC', 'shared_tokens': {'first'}}, {'other_company': 'First Hawaiian INC', 'shared_tokens': {'first'}}, {'other_company': 'First Busey Corp Nv', 'shared_tokens': {'first'}}, {'other_company': 'Trico Bancshares', 'shared_tokens': {'bancshares'}}, {'other_company': 'First MID Bancshares INC', 'shared_tokens': {'first', 'bancshares'}}, {'other_company': 'Southside Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'First Financial Corp In', 'shared_tokens': {'first'}}]} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000717806', 'EntityCommonStockSharesOutstanding': 6015737, 'Assets': 0, 'AssetsAndSecurities': 0, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 0, 'Expenses': -5958308, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndBorrowings': 0, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': -9075710, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 0, 'Revenues': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -406051, 'remainder_Expenses': -5958308, 'remainder_Liabilities': 0, 'remainder_NetIncome': -15034018, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000717806', 'EntityCommonStockSharesOutstanding': 6023622, 'Assets': 0, 'AssetsAndSecurities': 0, 'CashDepositsAndCashEquivalents': 0, 'Deposits': 0, 'Expenses': 744995, 'Fees': 0, 'Goodwill': 0, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndBorrowings': 0, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 2195189, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 0, 'Revenues': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 134493, 'remainder_Expenses': 744995, 'remainder_Liabilities': 0, 'remainder_NetIncome': 2940184, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4888997655034371, 'aggregate_val': 909532000, 'exp_sum': 1779557000, 'exp_to_value': {'Deposits': 870025000, 'LongTermDebt': 10726000, 'LiabilitiesAndBorrowings': 708339000, 'remainder_Liabilities': 190467000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48967635411004534, 'aggregate_val': 499466000, 'exp_sum': 978724000, 'exp_to_value': {'Deposits': 479258000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 417024000, 'remainder_Liabilities': 82442000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48390645074386773, 'aggregate_val': 530651000, 'exp_sum': 1028207000, 'exp_to_value': {'Deposits': 497556000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 429296000, 'remainder_Liabilities': 101355000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4848591404020059, 'aggregate_val': 549373000, 'exp_sum': 1066452000, 'exp_to_value': {'Deposits': 517079000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 441567000, 'remainder_Liabilities': 107806000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49725626169978415, 'aggregate_val': 712502000, 'exp_sum': 1417227000, 'exp_to_value': {'Deposits': 704725000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 602501000, 'remainder_Liabilities': 110001000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4926753970015537, 'aggregate_val': 703990000, 'exp_sum': 1387652000, 'exp_to_value': {'Deposits': 683662000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 580699000, 'remainder_Liabilities': 123291000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49318398910497496, 'aggregate_val': 803833000, 'exp_sum': 1586045000, 'exp_to_value': {'Deposits': 782212000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 641589000, 'remainder_Liabilities': 162244000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4911765602181012, 'aggregate_val': 868238000, 'exp_sum': 1706364000, 'exp_to_value': {'Deposits': 838126000, 'LongTermDebt': 10653000, 'LiabilitiesAndBorrowings': 672814000, 'remainder_Liabilities': 184771000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4888997655034371, 'aggregate_val': 909532000, 'exp_sum': 1779557000, 'exp_to_value': {'Deposits': 870025000, 'LongTermDebt': 10726000, 'LiabilitiesAndBorrowings': 708339000, 'remainder_Liabilities': 190467000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000717806')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |