warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.5398075240594926, 'aggregate_val': 1578000000, 'exp_sum': 3429000000, 'exp_to_value': {'LaborExpense': 957000000, 'SellingAndGeneralAdministrativeExpense': 894000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1851000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': -273000000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000933136', 'EntityCommonStockSharesOutstanding': 91087252, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 1578000000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 957000000, 'Liabilities': 16074000000, 'LiabilitiesAndStockholdersEquity': 18305000000, 'LoansIncome': 1098000000, 'LoansPayable': 0, 'NetIncome': 270000000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 1851000000, 'RevenueFromContractWithCustomer': 909000000, 'Revenues': 2007000000, 'SellingAndGeneralAdministrativeExpense': 894000000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': -2124000000, 'remainder_Liabilities': 16074000000, 'remainder_NetIncome': -159000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 2231000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4379446640316206, 'aggregate_val': 2133000000, 'exp_sum': 3795000000, 'exp_to_value': {'LaborExpense': 1036000000, 'SellingAndGeneralAdministrativeExpense': 626000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 471000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44874955970412117, 'aggregate_val': 1565000000, 'exp_sum': 2839000000, 'exp_to_value': {'LaborExpense': 789000000, 'SellingAndGeneralAdministrativeExpense': 485000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1274000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 291000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.045386835295576695, 'aggregate_val': 685060000, 'exp_sum': 717631000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 9924000, 'IntangibleAssets': 0, 'remainder_Assets': 707707000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.03815802538816508, 'aggregate_val': 736190000, 'exp_sum': 765396000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 2491000, 'IntangibleAssets': 0, 'remainder_Assets': 762905000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.0024657307285600814, 'aggregate_val': 614121000, 'exp_sum': 615639000, 'exp_to_value': {'Investments': 0, 'CashAndCurrentAssets': 26709000, 'IntangibleAssets': 0, 'remainder_Assets': 588930000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.48774640383590834, 'aggregate_val': 1923000000, 'exp_sum': 3754000000, 'exp_to_value': {'LaborExpense': 1068000000, 'SellingAndGeneralAdministrativeExpense': 763000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1831000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 92000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4379446640316206, 'aggregate_val': 2133000000, 'exp_sum': 3795000000, 'exp_to_value': {'LaborExpense': 1036000000, 'SellingAndGeneralAdministrativeExpense': 626000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1662000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 471000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44874955970412117, 'aggregate_val': 1565000000, 'exp_sum': 2839000000, 'exp_to_value': {'LaborExpense': 789000000, 'SellingAndGeneralAdministrativeExpense': 485000000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1274000000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 291000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000933136')"} |