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 MID Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Southside Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Merchants Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'First Citizens Bancshares INC De', 'shared_tokens': {'bancshares'}}, {'other_company': 'Croghan Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Kentucky Bancshares INC Ky', 'shared_tokens': {'bancshares'}}, {'other_company': 'Commercial Bancshares INC Oh', 'shared_tokens': {'bancshares'}}, {'other_company': 'Georgia Carolina Bancshares Inc', 'shared_tokens': {'bancshares'}}, {'other_company': 'Guaranty Federal Bancshares INC', 'shared_tokens': {'bancshares'}}, {'other_company': 'Texas Capital Bancshares INC Tx', 'shared_tokens': {'bancshares'}}, {'other_company': 'Community West Bancshares', 'shared_tokens': {'bancshares'}}, {'other_company': 'OLD Line Bancshares INC', 'shared_tokens': {'bancshares'}}]} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001331520', 'EntityCommonStockSharesOutstanding': 67530400, 'Assets': 7403272000, 'AssetsAndSecurities': 93689000, 'CashDepositsAndCashEquivalents': 112528000, 'Deposits': 5423971000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 325423000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 6387980000, 'LiabilitiesAndBorrowings': 0, 'LiabilitiesAndStockholdersEquity': 7403272000, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 113063000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 206912000, 'Revenues': 0, 'remainder_Assets': 6664720000, 'remainder_ComprehensiveNetIncome': 11149000, 'remainder_Expenses': 0, 'remainder_Liabilities': 964009000, 'remainder_LiabilitiesAndStockholdersEquity': 1015292000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001331520', 'EntityCommonStockSharesOutstanding': 27993142, 'Assets': 4242130000, 'AssetsAndSecurities': 75741000, 'CashDepositsAndCashEquivalents': 231855000, 'Deposits': 3483452000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 85681000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 3726657000, 'LiabilitiesAndBorrowings': 0, 'LiabilitiesAndStockholdersEquity': 4242130000, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 63022000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 113883000, 'Revenues': 0, 'remainder_Assets': 3734970000, 'remainder_ComprehensiveNetIncome': 3997000, 'remainder_Expenses': 0, 'remainder_Liabilities': 243205000, 'remainder_LiabilitiesAndStockholdersEquity': 515473000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001331520', 'EntityCommonStockSharesOutstanding': 67530400, 'Assets': 7403272000, 'AssetsAndSecurities': 93689000, 'CashDepositsAndCashEquivalents': 112528000, 'Deposits': 5423971000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 325423000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 6387980000, 'LiabilitiesAndBorrowings': 0, 'LiabilitiesAndStockholdersEquity': 7403272000, 'LoansAndLeasesReceivable': 0, 'LongTermDebt': 0, 'NetIncome': 113063000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 206912000, 'Revenues': 0, 'remainder_Assets': 6664720000, 'remainder_ComprehensiveNetIncome': 11149000, 'remainder_Expenses': 0, 'remainder_Liabilities': 964009000, 'remainder_LiabilitiesAndStockholdersEquity': 1015292000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.01711466215933728, 'aggregate_val': 6811861000, 'exp_sum': 6697240000, 'exp_to_value': {'LoansAndLeasesReceivable': 0, 'AssetsAndSecurities': 81215000, 'CashDepositsAndCashEquivalents': 165534000, 'Goodwill': 301736000, 'PropertyPlantAndEquipment': 197224000, 'remainder_Assets': 5951531000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001331520')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |