warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
No stock price available |
subcommand.plot |
{} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001364742', 'EntityCommonStockSharesOutstanding': 169537195, 'Assets': 0, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 0, 'Expenses': 6843000000, 'FinancialSecurities': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillAndIntangibleAssets': 0, 'InterestIncome': 0, 'LaborExpense': 0, 'Liabilities': 174834000000, 'LiabilitiesAndStockholdersEquity': 200451000000, 'LiabilitiesCurrent': 0, 'LongTermLiabilities': 0, 'NetIncome': 2440000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 0, 'TemporaryEquity': 32000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 86000000, 'remainder_Expenses': 6843000000, 'remainder_Liabilities': 174834000000, 'remainder_NetIncome': 9283000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 25585000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001364742', 'EntityCommonStockSharesOutstanding': 167090120, 'Assets': 0, 'AssetsCurrent': 0, 'BrokerageAndAdvisoryCommissions': 0, 'CommissionsAndAdvisoryFees': 353000000, 'Expenses': 7345000000, 'FinancialSecurities': 0, 'GeneralAndAdministrativeExpense': 1540000000, 'GoodwillAndIntangibleAssets': 0, 'InterestIncome': 0, 'LaborExpense': 3560000000, 'Liabilities': 193203000000, 'LiabilitiesAndStockholdersEquity': 219873000000, 'LiabilitiesCurrent': 0, 'LongTermLiabilities': 0, 'NetIncome': 2951000000, 'OperatingExpenses': 0, 'Payables': 0, 'Receivables': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SecuritiesRepurchaseAgreements': 0, 'TemporaryEquity': 54000000, 'TradingGainsAndLosses': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 5000000, 'remainder_Expenses': 1892000000, 'remainder_Liabilities': 193203000000, 'remainder_NetIncome': 10296000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 26616000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.011022068202055207, 'aggregate_val': 126033000000, 'exp_sum': 124659000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 95264000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1292000000, 'remainder_Liabilities': 28103000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.024013193780441634, 'aggregate_val': 159573000000, 'exp_sum': 155831000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6302000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 31365000000, 'remainder_Assets': 118164000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.06731078904991948, 'aggregate_val': 6628000000, 'exp_sum': 6210000000, 'exp_to_value': {'LaborExpense': 3199000000, 'GeneralAndAdministrativeExpense': 1415000000, 'CommissionsAndAdvisoryFees': 0, 'OperatingExpenses': 0, 'remainder_Expenses': 1596000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.010349719844917653, 'aggregate_val': 154534000000, 'exp_sum': 152951000000, 'exp_to_value': {'LiabilitiesCurrent': 100000000, 'LongTermLiabilities': 123561000000, 'SecuritiesRepurchaseAgreements': 20918000000, 'Payables': 923000000, 'remainder_Liabilities': 7449000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.009500401227813223, 'aggregate_val': 179896000000, 'exp_sum': 178203000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 3506000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30148000000, 'remainder_Assets': 144549000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.06731078904991948, 'aggregate_val': 6628000000, 'exp_sum': 6210000000, 'exp_to_value': {'LaborExpense': 3199000000, 'GeneralAndAdministrativeExpense': 1415000000, 'CommissionsAndAdvisoryFees': 0, 'OperatingExpenses': 0, 'remainder_Expenses': 1596000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.010349719844917653, 'aggregate_val': 154534000000, 'exp_sum': 152951000000, 'exp_to_value': {'LiabilitiesCurrent': 100000000, 'LongTermLiabilities': 123561000000, 'SecuritiesRepurchaseAgreements': 20918000000, 'Payables': 923000000, 'remainder_Liabilities': 7449000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.009500401227813223, 'aggregate_val': 179896000000, 'exp_sum': 178203000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 3506000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30148000000, 'remainder_Assets': 144549000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.017416392688374055, 'aggregate_val': 212288000000, 'exp_sum': 208654000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 161287000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1035000000, 'remainder_Liabilities': 46332000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.015369763483474328, 'aggregate_val': 239808000000, 'exp_sum': 236178000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 5723000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30305000000, 'remainder_Assets': 200150000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.017416392688374055, 'aggregate_val': 212288000000, 'exp_sum': 208654000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 161287000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1035000000, 'remainder_Liabilities': 46332000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.015369763483474328, 'aggregate_val': 239808000000, 'exp_sum': 236178000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 5723000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30305000000, 'remainder_Assets': 200150000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.0009028769638849215, 'aggregate_val': 196217000000, 'exp_sum': 196040000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 155781000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1068000000, 'remainder_Liabilities': 39191000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.005557638740089994, 'aggregate_val': 225261000000, 'exp_sum': 224016000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6083000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30495000000, 'remainder_Assets': 187438000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.0009028769638849215, 'aggregate_val': 196217000000, 'exp_sum': 196040000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 155781000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1068000000, 'remainder_Liabilities': 39191000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.005557638740089994, 'aggregate_val': 225261000000, 'exp_sum': 224016000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6083000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30495000000, 'remainder_Assets': 187438000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.005273442850489905, 'aggregate_val': 220177000000, 'exp_sum': 219022000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6091000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30481000000, 'remainder_Assets': 182450000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.00779355098529156, 'aggregate_val': 220217000000, 'exp_sum': 218514000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6894000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 30609000000, 'remainder_Assets': 181011000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.011022068202055207, 'aggregate_val': 126033000000, 'exp_sum': 124659000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 95264000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1292000000, 'remainder_Liabilities': 28103000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.024013193780441634, 'aggregate_val': 159573000000, 'exp_sum': 155831000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6302000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 31365000000, 'remainder_Assets': 118164000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.011022068202055207, 'aggregate_val': 126033000000, 'exp_sum': 124659000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 95264000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1292000000, 'remainder_Liabilities': 28103000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.024013193780441634, 'aggregate_val': 159573000000, 'exp_sum': 155831000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6302000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 31365000000, 'remainder_Assets': 118164000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.011022068202055207, 'aggregate_val': 126033000000, 'exp_sum': 124659000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 95264000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1292000000, 'remainder_Liabilities': 28103000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.024013193780441634, 'aggregate_val': 159573000000, 'exp_sum': 155831000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6302000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 31365000000, 'remainder_Assets': 118164000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.011022068202055207, 'aggregate_val': 126033000000, 'exp_sum': 124659000000, 'exp_to_value': {'LiabilitiesCurrent': 0, 'LongTermLiabilities': 95264000000, 'SecuritiesRepurchaseAgreements': 0, 'Payables': 1292000000, 'remainder_Liabilities': 28103000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.024013193780441634, 'aggregate_val': 159573000000, 'exp_sum': 155831000000, 'exp_to_value': {'FinancialSecurities': 0, 'AssetsCurrent': 6302000000, 'Receivables': 0, 'GoodwillAndIntangibleAssets': 31365000000, 'remainder_Assets': 118164000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001364742')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001364742')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |