warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 363.2315739419876, 'aggregate_val': 2285319000, 'exp_sum': -6309000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': -6309000}} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 108.3105873707417, 'aggregate_val': 2082476000, 'exp_sum': 19051000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 19051000}} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 43.634949619395435, 'aggregate_val': 2028837000, 'exp_sum': 45454000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 45454000}} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 363.2315739419876, 'aggregate_val': 2285319000, 'exp_sum': -6309000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': -6309000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001360901', 'EntityCommonStockSharesOutstanding': 29280213, 'Assets': 1145218000, 'CashAndCurrentAssets': 526747000, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 0, 'IntangibleAssets': 224081000, 'InvestmentIncome': 0, 'Investments': 110897000, 'LaborExpense': 0, 'Liabilities': 604742000, 'LiabilitiesAndStockholdersEquity': 1145218000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 0, 'OperatingAndEmployeeLiabilities': 320906000, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'TemporaryEquity': 49727000, 'remainder_Assets': 283493000, 'remainder_ComprehensiveNetIncome': 31861000, 'remainder_Expenses': 0, 'remainder_Liabilities': 283836000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 490749000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4350626702899386, 'aggregate_val': 1887037000, 'exp_sum': 3340259000, 'exp_to_value': {'LaborExpense': 1372339000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1737472000, 'DepreciationInterestAndFeesExpenses': 102297000, 'remainder_Expenses': 128151000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.42439976436459265, 'aggregate_val': 530567000, 'exp_sum': 921763000, 'exp_to_value': {'LaborExpense': 357680000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 488452000, 'DepreciationInterestAndFeesExpenses': 52907000, 'remainder_Expenses': 22724000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.42280424646876474, 'aggregate_val': 712947000, 'exp_sum': 1235191000, 'exp_to_value': {'LaborExpense': 485794000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 635253000, 'DepreciationInterestAndFeesExpenses': 50455000, 'remainder_Expenses': 63689000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4177526900142962, 'aggregate_val': 829211000, 'exp_sum': 1424156000, 'exp_to_value': {'LaborExpense': 549516000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 744911000, 'DepreciationInterestAndFeesExpenses': 60973000, 'remainder_Expenses': 68756000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4137857565594792, 'aggregate_val': 1188608000, 'exp_sum': 2027600000, 'exp_to_value': {'LaborExpense': 788175000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1094603000, 'DepreciationInterestAndFeesExpenses': 67792000, 'remainder_Expenses': 77030000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4215498491977744, 'aggregate_val': 1314919000, 'exp_sum': 2273176000, 'exp_to_value': {'LaborExpense': 900590000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1178878000, 'DepreciationInterestAndFeesExpenses': 74405000, 'remainder_Expenses': 119303000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3980455935211042, 'aggregate_val': 1553976000, 'exp_sum': 2581551000, 'exp_to_value': {'LaborExpense': 962512000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1275538000, 'DepreciationInterestAndFeesExpenses': 85059000, 'remainder_Expenses': 258442000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4369378706054496, 'aggregate_val': 1648919000, 'exp_sum': 2928485000, 'exp_to_value': {'LaborExpense': 1197173000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1522628000, 'DepreciationInterestAndFeesExpenses': 100164000, 'remainder_Expenses': 108520000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4320740990232401, 'aggregate_val': 1686172000, 'exp_sum': 2969000000, 'exp_to_value': {'LaborExpense': 1200977000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1570987000, 'DepreciationInterestAndFeesExpenses': 101990000, 'remainder_Expenses': 95046000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4350626702899386, 'aggregate_val': 1887037000, 'exp_sum': 3340259000, 'exp_to_value': {'LaborExpense': 1372339000, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1737472000, 'DepreciationInterestAndFeesExpenses': 102297000, 'remainder_Expenses': 128151000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001360901')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |