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': 'Southside Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'First Us Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Merchants Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Kentucky Bancshares INC Ky', 'shared_tokens': {'bancshares'}}, {'other_company': 'Prosperity Bancshares INC', 'shared_tokens': {'bancshares'}}]} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.6315908124047807, 'aggregate_val': 1418494000, 'exp_sum': 3850322000, 'exp_to_value': {'Deposits': 1215914000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1078842000, 'remainder_Liabilities': 1555566000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001227500', 'EntityCommonStockSharesOutstanding': 7150017, 'Assets': 1585727000, 'AssetsAndSecurities': 11206000, 'CashDepositsAndCashEquivalents': 62074000, 'Deposits': 1215914000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 18130000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 1418494000, 'LiabilitiesAndBorrowings': 1078842000, 'LiabilitiesAndStockholdersEquity': 1585727000, 'LoansAndLeasesReceivable': 958353000, 'LongTermDebt': 0, 'NetIncome': 10300000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 39147000, 'Revenues': 0, 'remainder_Assets': 496817000, 'remainder_ComprehensiveNetIncome': -90000, 'remainder_Expenses': 0, 'remainder_Liabilities': -876262000, 'remainder_LiabilitiesAndStockholdersEquity': 167233000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4573906935238769, 'aggregate_val': 1934228000, 'exp_sum': 3564679000, 'exp_to_value': {'Deposits': 1630451000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1443420000, 'remainder_Liabilities': 490808000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4599921056361664, 'aggregate_val': 2796365000, 'exp_sum': 5178378000, 'exp_to_value': {'Deposits': 2382013000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2052975000, 'remainder_Liabilities': 743390000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4573906935238769, 'aggregate_val': 1934228000, 'exp_sum': 3564679000, 'exp_to_value': {'Deposits': 1630451000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1443420000, 'remainder_Liabilities': 490808000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4599921056361664, 'aggregate_val': 2796365000, 'exp_sum': 5178378000, 'exp_to_value': {'Deposits': 2382013000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2052975000, 'remainder_Liabilities': 743390000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001227500')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |