error |
Negative Expenses, ignoring company. |
pre-agg |
{'expenses': -1145000} |
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 |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001265131', 'EntityCommonStockSharesOutstanding': 90181888, 'Assets': 9242416000, 'AssetsAndSecurities': 1593301000, 'CashDepositsAndCashEquivalents': 782473000, 'Deposits': 6369892000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 251808000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 7781177000, 'LiabilitiesAndBorrowings': 4700508000, 'LiabilitiesAndStockholdersEquity': 9242416000, 'LoansAndLeasesReceivable': 3883435000, 'LongTermDebt': 0, 'NetIncome': 112558000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 206991000, 'Revenues': 0, 'remainder_Assets': 2524408000, 'remainder_ComprehensiveNetIncome': 34606000, 'remainder_Expenses': 0, 'remainder_Liabilities': -3289223000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1461239000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001265131', 'EntityCommonStockSharesOutstanding': 98895584, 'Assets': 11867001000, 'AssetsAndSecurities': 1785687000, 'CashDepositsAndCashEquivalents': 652036000, 'Deposits': 6952683000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 251808000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 10128876000, 'LiabilitiesAndBorrowings': 6510295000, 'LiabilitiesAndStockholdersEquity': 11867001000, 'LoansAndLeasesReceivable': 5174625000, 'LongTermDebt': 0, 'NetIncome': 212579000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 200618000, 'Revenues': 0, 'remainder_Assets': 3802227000, 'remainder_ComprehensiveNetIncome': 372000, 'remainder_Expenses': 0, 'remainder_Liabilities': -3334102000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1738125000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4216252873739216, 'aggregate_val': 11709679000, 'exp_sum': 20245835000, 'exp_to_value': {'Deposits': 8536156000, 'LongTermDebt': 228872000, 'LiabilitiesAndBorrowings': 7705571000, 'remainder_Liabilities': 3775236000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4091442664129235, 'aggregate_val': 13043652000, 'exp_sum': 22075866000, 'exp_to_value': {'Deposits': 9032214000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 8327086000, 'remainder_Liabilities': 4716566000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4335908241255054, 'aggregate_val': 6140315000, 'exp_sum': 10840776000, 'exp_to_value': {'Deposits': 4700461000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4763537000, 'remainder_Liabilities': 1376778000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.46963380962627815, 'aggregate_val': 7591301000, 'exp_sum': 14313320000, 'exp_to_value': {'Deposits': 6722019000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 6600651000, 'remainder_Liabilities': 990650000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.45013503926805815, 'aggregate_val': 7781177000, 'exp_sum': 14151069000, 'exp_to_value': {'Deposits': 6369892000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4700508000, 'remainder_Liabilities': 3080669000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.40702859733119207, 'aggregate_val': 10128876000, 'exp_sum': 17081559000, 'exp_to_value': {'Deposits': 6952683000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 6510295000, 'remainder_Liabilities': 3618581000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.39402420424253376, 'aggregate_val': 10863542000, 'exp_sum': 17927353000, 'exp_to_value': {'Deposits': 7063811000, 'LongTermDebt': 317912000, 'LiabilitiesAndBorrowings': 6707957000, 'remainder_Liabilities': 3837673000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.41062734873229834, 'aggregate_val': 11450979000, 'exp_sum': 19429098000, 'exp_to_value': {'Deposits': 7978119000, 'LongTermDebt': 208809000, 'LiabilitiesAndBorrowings': 7324064000, 'remainder_Liabilities': 3918106000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4216252873739216, 'aggregate_val': 11709679000, 'exp_sum': 20245835000, 'exp_to_value': {'Deposits': 8536156000, 'LongTermDebt': 228872000, 'LiabilitiesAndBorrowings': 7705571000, 'remainder_Liabilities': 3775236000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4091442664129235, 'aggregate_val': 13043652000, 'exp_sum': 22075866000, 'exp_to_value': {'Deposits': 9032214000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 8327086000, 'remainder_Liabilities': 4716566000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001265131')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |