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': 'Ameriprise Financial INC', 'shared_tokens': {'financial'}}]} |
warning |
No stock price available |
subcommand.plot |
{} |
warning |
Ignoring company because Liabilities is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'EntityCommonStockSharesOutstanding': 6887500, 'Assets': 18801, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 128929, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 0, 'LiabilitiesAndStockholdersEquity': 18801, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -128229, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 700, 'SellingAndGeneralAdministrativeExpense': 18436, 'remainder_Assets': 18801, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 110493, 'remainder_Liabilities': 0, 'remainder_NetIncome': 0, 'remainder_Revenues': 700, 'remainder_StockholdersEquity': 18801, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'EntityCommonStockSharesOutstanding': 6902500, 'Assets': 3746, 'CashAndCurrentAssets': 3746, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 0, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 209254, 'LiabilitiesAndStockholdersEquity': 3746, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -117147, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 209254, 'remainder_LiabilitiesAndStockholdersEquity': -205508, 'remainder_NetIncome': -117147, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'Assets': 953, 'CashAndCurrentAssets': 953, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 0, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 282614, 'LiabilitiesAndStockholdersEquity': 953, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -100003, 'OperatingAndEmployeeLiabilities': 282614, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_LiabilitiesAndStockholdersEquity': -281661, 'remainder_NetIncome': -100003, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'Assets': 29, 'CashAndCurrentAssets': 29, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 0, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 336419, 'LiabilitiesAndStockholdersEquity': 29, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -84349, 'OperatingAndEmployeeLiabilities': 336419, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 0, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_LiabilitiesAndStockholdersEquity': -336390, 'remainder_NetIncome': -84349, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'EntityCommonStockSharesOutstanding': 6902500, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 96592, 'Expenses': 114331, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 24201, 'LiabilitiesAndStockholdersEquity': 1278, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -114847, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 76, 'SellingAndGeneralAdministrativeExpense': 17739, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 24201, 'remainder_LiabilitiesAndStockholdersEquity': -22923, 'remainder_NetIncome': -592, 'remainder_Revenues': 76, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001498122', 'EntityCommonStockSharesOutstanding': 6902500, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 82730, 'Expenses': 97551, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 0, 'Liabilities': 106101, 'LiabilitiesAndStockholdersEquity': 827, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': -100867, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'SellingAndGeneralAdministrativeExpense': 14821, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 106101, 'remainder_LiabilitiesAndStockholdersEquity': -105274, 'remainder_NetIncome': -3316, 'remainder_Revenues': 0, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.33204504382953637, 'aggregate_val': 1004991, 'exp_sum': 1504579, 'exp_to_value': {'LaborExpense': 0, 'SellingAndGeneralAdministrativeExpense': 56012, 'CostOfGoodsSold': 0, 'OperatingExpenses': 1004991, 'DepreciationInterestAndFeesExpenses': 443576, 'remainder_Expenses': 0}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001498122')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |