warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Similarly named company. Duplicate? |
None |
{'details': [{'other_company': 'Virtus Investment Partners Inc', 'shared_tokens': {'investment'}}]} |
warning |
No stock price available |
subcommand.plot |
{} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.481324876673714, 'aggregate_val': 1056300000, 'exp_sum': 425700000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 425700000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 21.844940867279895, 'aggregate_val': 5215500000, 'exp_sum': 228300000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 228300000}} |
warning |
Large missing amount for aggregate "Assets" added to remainder. |
industry.us_generic |
{'missing_ratio': 6.13044674800477, 'aggregate_val': 7772900000, 'exp_sum': 1090100000, 'exp_to_value': {'Investments': 209900000, 'CashAndCurrentAssets': 268600000, 'IntangibleAssets': 126500000, 'remainder_Assets': 485100000}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001611702', 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 100000, 'Expenses': 554700000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 848200000, 'LiabilitiesAndStockholdersEquity': 1014100000, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 155500000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 508100000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 699300000, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': -8100000, 'remainder_Expenses': 46500000, 'remainder_Liabilities': 848200000, 'remainder_LiabilitiesAndStockholdersEquity': 165900000, 'remainder_NetIncome': 10900000, 'remainder_Revenues': 699300000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 8.799718409010911e-05, 'aggregate_val': 1136300000, 'exp_sum': 1136400000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1123500000, 'DepreciationInterestAndFeesExpenses': 100000, 'remainder_Expenses': 12800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.0001802451333813987, 'aggregate_val': 554700000, 'exp_sum': 554800000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 508100000, 'DepreciationInterestAndFeesExpenses': 100000, 'remainder_Expenses': 46600000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 8.799718409010911e-05, 'aggregate_val': 1136300000, 'exp_sum': 1136400000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1123500000, 'DepreciationInterestAndFeesExpenses': 100000, 'remainder_Expenses': 12800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.0001802451333813987, 'aggregate_val': 554700000, 'exp_sum': 554800000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 508100000, 'DepreciationInterestAndFeesExpenses': 100000, 'remainder_Expenses': 46600000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001611702')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001611702')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |