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': 2.348045397225725, 'aggregate_val': 5310000000, 'exp_sum': 1586000000, 'exp_to_value': {'GeneralAndAdministrativeExpense': 311000000, 'DepreciationDepletionAndAmortization': 331000000, 'CostOfGoodsAndServicesSold': 0, 'OperatingExpenses': 0, 'remainder_Expenses': 944000000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001585689', 'EntityCommonStockSharesOutstanding': 296569995, 'Assets': 13995000000, 'AssetsCurrent': 1983000000, 'AssetsNonCurrent': 12012000000, 'ComprehensiveNetIncome': 707000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'IntangibleAssets': 6032000000, 'Liabilities': 13437000000, 'LiabilitiesAndStockholdersEquity': 13995000000, 'LiabilitiesCurrent': 2615000000, 'LongTermLiabilities': 0, 'NetIncome': 769000000, 'OperatingExpenses': 0, 'PropertyPlantAndEquipment': 367000000, 'Revenues': 0, 'remainder_Assets': -6399000000, 'remainder_ComprehensiveNetIncome': -62000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 10822000000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 558000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.08813491266813893, 'aggregate_val': 16260000000, 'exp_sum': 14943000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 3019000000, 'remainder_Liabilities': 11924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4293580694038952, 'aggregate_val': 15441000000, 'exp_sum': 27059000000, 'exp_to_value': {'PropertyPlantAndEquipment': 305000000, 'AssetsNonCurrent': 12570000000, 'AssetsCurrent': 2871000000, 'IntangibleAssets': 5071000000, 'remainder_Assets': 6242000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.08813491266813893, 'aggregate_val': 16260000000, 'exp_sum': 14943000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 3019000000, 'remainder_Liabilities': 11924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4293580694038952, 'aggregate_val': 15441000000, 'exp_sum': 27059000000, 'exp_to_value': {'PropertyPlantAndEquipment': 305000000, 'AssetsNonCurrent': 12570000000, 'AssetsCurrent': 2871000000, 'IntangibleAssets': 5071000000, 'remainder_Assets': 6242000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.474884926936142, 'aggregate_val': 26125000000, 'exp_sum': 49751000000, 'exp_to_value': {'PropertyPlantAndEquipment': 7483000000, 'AssetsNonCurrent': 23626000000, 'AssetsCurrent': 2499000000, 'IntangibleAssets': 6154000000, 'remainder_Assets': 9989000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.47353982844391673, 'aggregate_val': 25716000000, 'exp_sum': 48847000000, 'exp_to_value': {'PropertyPlantAndEquipment': 9119000000, 'AssetsNonCurrent': 23131000000, 'AssetsCurrent': 2585000000, 'IntangibleAssets': 5887000000, 'remainder_Assets': 8125000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.46360380640540266, 'aggregate_val': 26211000000, 'exp_sum': 48865000000, 'exp_to_value': {'PropertyPlantAndEquipment': 8930000000, 'AssetsNonCurrent': 22654000000, 'AssetsCurrent': 3557000000, 'IntangibleAssets': 6841000000, 'remainder_Assets': 6883000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4618756488637675, 'aggregate_val': 13995000000, 'exp_sum': 26007000000, 'exp_to_value': {'PropertyPlantAndEquipment': 367000000, 'AssetsNonCurrent': 12012000000, 'AssetsCurrent': 1983000000, 'IntangibleAssets': 6032000000, 'remainder_Assets': 5613000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.1071927162367223, 'aggregate_val': 18241000000, 'exp_sum': 16475000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 2431000000, 'remainder_Liabilities': 14044000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.42831308857649786, 'aggregate_val': 16755000000, 'exp_sum': 29308000000, 'exp_to_value': {'PropertyPlantAndEquipment': 346000000, 'AssetsNonCurrent': 12553000000, 'AssetsCurrent': 4202000000, 'IntangibleAssets': 5748000000, 'remainder_Assets': 6459000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.1071927162367223, 'aggregate_val': 18241000000, 'exp_sum': 16475000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 2431000000, 'remainder_Liabilities': 14044000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.42831308857649786, 'aggregate_val': 16755000000, 'exp_sum': 29308000000, 'exp_to_value': {'PropertyPlantAndEquipment': 346000000, 'AssetsNonCurrent': 12553000000, 'AssetsCurrent': 4202000000, 'IntangibleAssets': 5748000000, 'remainder_Assets': 6459000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.08813491266813893, 'aggregate_val': 16260000000, 'exp_sum': 14943000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 3019000000, 'remainder_Liabilities': 11924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4293580694038952, 'aggregate_val': 15441000000, 'exp_sum': 27059000000, 'exp_to_value': {'PropertyPlantAndEquipment': 305000000, 'AssetsNonCurrent': 12570000000, 'AssetsCurrent': 2871000000, 'IntangibleAssets': 5071000000, 'remainder_Assets': 6242000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.08813491266813893, 'aggregate_val': 16260000000, 'exp_sum': 14943000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 3019000000, 'remainder_Liabilities': 11924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4293580694038952, 'aggregate_val': 15441000000, 'exp_sum': 27059000000, 'exp_to_value': {'PropertyPlantAndEquipment': 305000000, 'AssetsNonCurrent': 12570000000, 'AssetsCurrent': 2871000000, 'IntangibleAssets': 5071000000, 'remainder_Assets': 6242000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.1071927162367223, 'aggregate_val': 18241000000, 'exp_sum': 16475000000, 'exp_to_value': {'LongTermLiabilities': 0, 'LiabilitiesCurrent': 2431000000, 'remainder_Liabilities': 14044000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.42831308857649786, 'aggregate_val': 16755000000, 'exp_sum': 29308000000, 'exp_to_value': {'PropertyPlantAndEquipment': 346000000, 'AssetsNonCurrent': 12553000000, 'AssetsCurrent': 4202000000, 'IntangibleAssets': 5748000000, 'remainder_Assets': 6459000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001585689')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |