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': '0001501570', 'EntityCommonStockSharesOutstanding': 22648718, 'Assets': 2945583000, 'AssetsAndSecurities': 14518000, 'CashDepositsAndCashEquivalents': 149044000, 'Deposits': 2278630000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 159452000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 2456654000, 'LiabilitiesAndBorrowings': 1680800000, 'LiabilitiesAndStockholdersEquity': 2945583000, 'LoansAndLeasesReceivable': 2221523000, 'LongTermDebt': 0, 'NetIncome': 15152000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 75251000, 'Revenues': 0, 'remainder_Assets': 325795000, 'remainder_ComprehensiveNetIncome': 195000, 'remainder_Expenses': 0, 'remainder_Liabilities': -1502776000, 'remainder_LiabilitiesAndStockholdersEquity': 488929000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001501570', 'EntityCommonStockSharesOutstanding': 24227086, 'Assets': 3208550000, 'AssetsAndSecurities': 14091000, 'CashDepositsAndCashEquivalents': 84449000, 'Deposits': 2622428000, 'Expenses': 0, 'Fees': 0, 'Goodwill': 161447000, 'ITAndEquipmentExpense': 0, 'LaborExpense': 0, 'Liabilities': 2677912000, 'LiabilitiesAndBorrowings': 1313161000, 'LiabilitiesAndStockholdersEquity': 3208550000, 'LoansAndLeasesReceivable': 2537497000, 'LongTermDebt': 0, 'NetIncome': 39341000, 'Occupancy': 0, 'OtherNoninterestExpense': 0, 'PropertyPlantAndEquipment': 78409000, 'Revenues': 0, 'remainder_Assets': 332657000, 'remainder_ComprehensiveNetIncome': -1650000, 'remainder_Expenses': 0, 'remainder_Liabilities': -1257677000, 'remainder_LiabilitiesAndStockholdersEquity': 530638000, '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.4658810049611582, 'aggregate_val': 8442170000, 'exp_sum': 15805785000, 'exp_to_value': {'Deposits': 7363615000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3276312000, 'remainder_Liabilities': 5165858000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.46012285161728805, 'aggregate_val': 10704588000, 'exp_sum': 19827822000, 'exp_to_value': {'Deposits': 9123234000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4395975000, 'remainder_Liabilities': 6308613000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48108369479339347, 'aggregate_val': 688974000, 'exp_sum': 1327717000, 'exp_to_value': {'Deposits': 638743000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 387619000, 'remainder_Liabilities': 301355000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48897950634134474, 'aggregate_val': 907554000, 'exp_sum': 1775964000, 'exp_to_value': {'Deposits': 868410000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 567043000, 'remainder_Liabilities': 340511000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48912452289138414, 'aggregate_val': 1169419000, 'exp_sum': 2289049000, 'exp_to_value': {'Deposits': 1119630000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 792016000, 'remainder_Liabilities': 377403000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.48120239461878106, 'aggregate_val': 2456654000, 'exp_sum': 4735284000, 'exp_to_value': {'Deposits': 2278630000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1680800000, 'remainder_Liabilities': 775854000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.49476599614364364, 'aggregate_val': 2677912000, 'exp_sum': 5300340000, 'exp_to_value': {'Deposits': 2622428000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 1313161000, 'remainder_Liabilities': 1364751000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4656440065126251, 'aggregate_val': 6764140000, 'exp_sum': 12658490000, 'exp_to_value': {'Deposits': 5894350000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2657325000, 'remainder_Liabilities': 4106815000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4609121605770165, 'aggregate_val': 7617495000, 'exp_sum': 14130341000, 'exp_to_value': {'Deposits': 6512846000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 2960681000, 'remainder_Liabilities': 4656814000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4658810049611582, 'aggregate_val': 8442170000, 'exp_sum': 15805785000, 'exp_to_value': {'Deposits': 7363615000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 3276312000, 'remainder_Liabilities': 5165858000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.46012285161728805, 'aggregate_val': 10704588000, 'exp_sum': 19827822000, 'exp_to_value': {'Deposits': 9123234000, 'LongTermDebt': 0, 'LiabilitiesAndBorrowings': 4395975000, 'remainder_Liabilities': 6308613000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001501570')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |