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': inf, 'aggregate_val': 887400000, 'exp_sum': 0, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 0}} |
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 "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': inf, 'aggregate_val': 663500000, 'exp_sum': 0, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 0}} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': inf, 'aggregate_val': 887400000, 'exp_sum': 0, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 0, 'remainder_Revenues': 0}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.7565762004175365, 'aggregate_val': 1320400000, 'exp_sum': 479000000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 479000000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.121996303142329, 'aggregate_val': 1377600000, 'exp_sum': 649200000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 649200000}} |
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 "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 2.861855670103093, 'aggregate_val': 1123800000, 'exp_sum': 291000000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 291000000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.7565762004175365, 'aggregate_val': 1320400000, 'exp_sum': 479000000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 479000000}} |
warning |
Large missing amount for aggregate "Liabilities" added to remainder. |
industry.us_generic |
{'missing_ratio': 1.121996303142329, 'aggregate_val': 1377600000, 'exp_sum': 649200000, 'exp_to_value': {'DepositsAndPayablesToCustomers': 0, 'Debt': 0, 'LoansPayable': 0, 'OperatingAndEmployeeLiabilities': 0, 'remainder_Liabilities': 649200000}} |
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': 0.006905210295040804, 'aggregate_val': 949200000, 'exp_sum': 955800000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 816400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 132800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.22713063507732806, 'aggregate_val': 1491700000, 'exp_sum': 1215600000, 'exp_to_value': {'Investments': 381100000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 559900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.025635359116022098, 'aggregate_val': 928200000, 'exp_sum': 905000000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 905000000, 'remainder_Revenues': 0}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.007710280373831775, 'aggregate_val': 849400000, 'exp_sum': 856000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 844400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.30628888515217756, 'aggregate_val': 1553700000, 'exp_sum': 1189400000, 'exp_to_value': {'Investments': 323300000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 591500000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.025635359116022098, 'aggregate_val': 928200000, 'exp_sum': 905000000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 905000000, 'remainder_Revenues': 0}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.007710280373831775, 'aggregate_val': 849400000, 'exp_sum': 856000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 844400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.30628888515217756, 'aggregate_val': 1553700000, 'exp_sum': 1189400000, 'exp_to_value': {'Investments': 323300000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 591500000}} |
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': 0.004716125521494649, 'aggregate_val': 548700000, 'exp_sum': 551300000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 507900000, 'DepreciationInterestAndFeesExpenses': 2600000, 'remainder_Expenses': 40800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.24956555319559762, 'aggregate_val': 1294300000, 'exp_sum': 1035800000, 'exp_to_value': {'Investments': 268800000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 272700000, 'remainder_Assets': 494300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.004716125521494649, 'aggregate_val': 548700000, 'exp_sum': 551300000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 507900000, 'DepreciationInterestAndFeesExpenses': 2600000, 'remainder_Expenses': 40800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.24956555319559762, 'aggregate_val': 1294300000, 'exp_sum': 1035800000, 'exp_to_value': {'Investments': 268800000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 272700000, 'remainder_Assets': 494300000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.006905210295040804, 'aggregate_val': 949200000, 'exp_sum': 955800000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 816400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 132800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.22713063507732806, 'aggregate_val': 1491700000, 'exp_sum': 1215600000, 'exp_to_value': {'Investments': 381100000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 559900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.006905210295040804, 'aggregate_val': 949200000, 'exp_sum': 955800000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 816400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 132800000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.22713063507732806, 'aggregate_val': 1491700000, 'exp_sum': 1215600000, 'exp_to_value': {'Investments': 381100000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 559900000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.025635359116022098, 'aggregate_val': 928200000, 'exp_sum': 905000000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 905000000, 'remainder_Revenues': 0}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.007710280373831775, 'aggregate_val': 849400000, 'exp_sum': 856000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 844400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.30628888515217756, 'aggregate_val': 1553700000, 'exp_sum': 1189400000, 'exp_to_value': {'Investments': 323300000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 591500000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.025635359116022098, 'aggregate_val': 928200000, 'exp_sum': 905000000, 'exp_to_value': {'InvestmentIncome': 0, 'LoansIncome': 0, 'RevenueFromContractWithCustomer': 905000000, 'remainder_Revenues': 0}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.007710280373831775, 'aggregate_val': 849400000, 'exp_sum': 856000000, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'CostOfGoodsSold': 0, 'OperatingExpenses': 844400000, 'DepreciationInterestAndFeesExpenses': 6600000, 'remainder_Expenses': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.30628888515217756, 'aggregate_val': 1553700000, 'exp_sum': 1189400000, 'exp_to_value': {'Investments': 323300000, 'CashAndCurrentAssets': 0, 'IntangibleAssets': 274600000, 'remainder_Assets': 591500000}} |
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 |
{} |