warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001507605', 'EntityCommonStockSharesOutstanding': 51599792, 'Assets': 313251239, 'AssetsCurrent': 286409215, 'AssetsNonCurrent': 26842024, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'IntangibleAssets': 1002402, 'Liabilities': 1506275, 'LiabilitiesAndStockholdersEquity': 313251239, 'LiabilitiesCurrent': 1443775, 'LiabilitiesNonCurrent': 62500, 'NetIncome': -10447771, 'ResearchAndDevelopment': 0, 'Revenues': 4357443, 'SellingExpense': 0, 'remainder_Assets': -1002402, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_LiabilitiesAndStockholdersEquity': 311744964, 'remainder_NetIncome': 13575880, 'remainder_Revenues': 4357443, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4954523390183396, 'aggregate_val': 765221042, 'exp_sum': 1516647685, 'exp_to_value': {'LiabilitiesCurrent': 36815120, 'LiabilitiesNonCurrent': 751426643, 'remainder_Liabilities': 728405922}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3441927850508961, 'aggregate_val': 1448244423, 'exp_sum': 2208338655, 'exp_to_value': {'AssetsCurrent': 688150191, 'AssetsNonCurrent': 760094232, 'IntangibleAssets': 931226, 'remainder_Assets': 759163006}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.39094449503754336, 'aggregate_val': 12955230, 'exp_sum': 21271017, 'exp_to_value': {'AssetsCurrent': 4639443, 'AssetsNonCurrent': 8315787, 'IntangibleAssets': 2144488, 'remainder_Assets': 6171299}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4405826121738673, 'aggregate_val': 59486430, 'exp_sum': 106336398, 'exp_to_value': {'AssetsCurrent': 7684153, 'AssetsNonCurrent': 51802277, 'IntangibleAssets': 3432308, 'remainder_Assets': 43417660}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.33747861589497513, 'aggregate_val': 34551851, 'exp_sum': 52152054, 'exp_to_value': {'LiabilitiesCurrent': 17951648, 'LiabilitiesNonCurrent': 17600203, 'remainder_Liabilities': 16600203}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.473354705464825, 'aggregate_val': 47227593, 'exp_sum': 89676284, 'exp_to_value': {'AssetsCurrent': 4778902, 'AssetsNonCurrent': 42448691, 'IntangibleAssets': 29940484, 'remainder_Assets': 12508207}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.33747861589497513, 'aggregate_val': 34551851, 'exp_sum': 52152054, 'exp_to_value': {'LiabilitiesCurrent': 17951648, 'LiabilitiesNonCurrent': 17600203, 'remainder_Liabilities': 16600203}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.473354705464825, 'aggregate_val': 47227593, 'exp_sum': 89676284, 'exp_to_value': {'AssetsCurrent': 4778902, 'AssetsNonCurrent': 42448691, 'IntangibleAssets': 29940484, 'remainder_Assets': 12508207}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2050888870753732, 'aggregate_val': 27575577, 'exp_sum': 34690139, 'exp_to_value': {'LiabilitiesCurrent': 21461015, 'LiabilitiesNonCurrent': 7114562, 'remainder_Liabilities': 6114562}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.41110362056397337, 'aggregate_val': 18288435, 'exp_sum': 31055438, 'exp_to_value': {'AssetsCurrent': 5521432, 'AssetsNonCurrent': 12767003, 'IntangibleAssets': 12537471, 'remainder_Assets': 229532}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.2050888870753732, 'aggregate_val': 27575577, 'exp_sum': 34690139, 'exp_to_value': {'LiabilitiesCurrent': 21461015, 'LiabilitiesNonCurrent': 7114562, 'remainder_Liabilities': 6114562}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.41110362056397337, 'aggregate_val': 18288435, 'exp_sum': 31055438, 'exp_to_value': {'AssetsCurrent': 5521432, 'AssetsNonCurrent': 12767003, 'IntangibleAssets': 12537471, 'remainder_Assets': 229532}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.0006643778779089677, 'aggregate_val': 15058221, 'exp_sum': 15068232, 'exp_to_value': {'AssetsCurrent': 15048210, 'AssetsNonCurrent': 10011, 'IntangibleAssets': 0, 'remainder_Assets': 10011}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.2955489794526242, 'aggregate_val': 5194507, 'exp_sum': 7373837, 'exp_to_value': {'AssetsCurrent': 3015177, 'AssetsNonCurrent': 2179330, 'IntangibleAssets': 1144755, 'remainder_Assets': 1034575}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4363973288826062, 'aggregate_val': 6619962, 'exp_sum': 11745796, 'exp_to_value': {'AssetsCurrent': 1494128, 'AssetsNonCurrent': 5125834, 'IntangibleAssets': 1073578, 'remainder_Assets': 4052256}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.07892547992048875, 'aggregate_val': 313251239, 'exp_sum': 340093263, 'exp_to_value': {'AssetsCurrent': 286409215, 'AssetsNonCurrent': 26842024, 'IntangibleAssets': 1002402, 'remainder_Assets': 25839622}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4954523390183396, 'aggregate_val': 765221042, 'exp_sum': 1516647685, 'exp_to_value': {'LiabilitiesCurrent': 36815120, 'LiabilitiesNonCurrent': 751426643, 'remainder_Liabilities': 728405922}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3441927850508961, 'aggregate_val': 1448244423, 'exp_sum': 2208338655, 'exp_to_value': {'AssetsCurrent': 688150191, 'AssetsNonCurrent': 760094232, 'IntangibleAssets': 931226, 'remainder_Assets': 759163006}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Liabilities', 'missing_ratio': 0.4954523390183396, 'aggregate_val': 765221042, 'exp_sum': 1516647685, 'exp_to_value': {'LiabilitiesCurrent': 36815120, 'LiabilitiesNonCurrent': 751426643, 'remainder_Liabilities': 728405922}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3441927850508961, 'aggregate_val': 1448244423, 'exp_sum': 2208338655, 'exp_to_value': {'AssetsCurrent': 688150191, 'AssetsNonCurrent': 760094232, 'IntangibleAssets': 931226, 'remainder_Assets': 759163006}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001507605')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |