error |
Assets != LiabilitiesAndStockholdersEquity, ignoring company. |
pre-agg |
{'assets': 869000000, 'lase': 23531000000} |
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': 303.9230769230769, 'aggregate_val': 3964000000, 'exp_sum': 13000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 0, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 13000000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 6.922393414190851, 'aggregate_val': 1333830000, 'exp_sum': 168362000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 0, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 0, 'Taxes': 0, 'OperatingExpenses': 0, 'remainder_Expenses': 168362000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.035302593659942365, 'aggregate_val': 7185000000, 'exp_sum': 6940000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1304000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 88000000, 'Taxes': 195000000, 'OperatingExpenses': 429000000, 'remainder_Expenses': 4924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.018096272167933407, 'aggregate_val': 2813000000, 'exp_sum': 2763000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 2756000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 7000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.09628918746001279, 'aggregate_val': 3427000000, 'exp_sum': 3126000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1275000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 146000000, 'Taxes': 425000000, 'OperatingExpenses': 571000000, 'remainder_Expenses': 709000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.006664691943127962, 'aggregate_val': 6797000000, 'exp_sum': 6752000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 6747000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.09628918746001279, 'aggregate_val': 3427000000, 'exp_sum': 3126000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1275000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 146000000, 'Taxes': 425000000, 'OperatingExpenses': 571000000, 'remainder_Expenses': 709000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.006664691943127962, 'aggregate_val': 6797000000, 'exp_sum': 6752000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 6747000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.3459591275353008, 'aggregate_val': 144562000, 'exp_sum': 221029000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 66597000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 9870000, 'Taxes': 0, 'OperatingExpenses': 112808000, 'remainder_Expenses': 31754000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.32635632407093973, 'aggregate_val': 392033000, 'exp_sum': 581959000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 170005000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 19921000, 'Taxes': 0, 'OperatingExpenses': 283048000, 'remainder_Expenses': 108985000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.2005930111943839, 'aggregate_val': 985692000, 'exp_sum': 1233029000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 217697000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 29640000, 'Taxes': 0, 'OperatingExpenses': 1187002000, 'remainder_Expenses': -201310000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.05706088619700351, 'aggregate_val': 3316000000, 'exp_sum': 3137000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1447000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 104000000, 'Taxes': 248000000, 'OperatingExpenses': 494000000, 'remainder_Expenses': 844000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.035302593659942365, 'aggregate_val': 7185000000, 'exp_sum': 6940000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1304000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 88000000, 'Taxes': 195000000, 'OperatingExpenses': 429000000, 'remainder_Expenses': 4924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.018096272167933407, 'aggregate_val': 2813000000, 'exp_sum': 2763000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 2756000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 7000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.035302593659942365, 'aggregate_val': 7185000000, 'exp_sum': 6940000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1304000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 88000000, 'Taxes': 195000000, 'OperatingExpenses': 429000000, 'remainder_Expenses': 4924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.018096272167933407, 'aggregate_val': 2813000000, 'exp_sum': 2763000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 2756000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 7000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.09628918746001279, 'aggregate_val': 3427000000, 'exp_sum': 3126000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1275000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 146000000, 'Taxes': 425000000, 'OperatingExpenses': 571000000, 'remainder_Expenses': 709000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.006664691943127962, 'aggregate_val': 6797000000, 'exp_sum': 6752000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 6747000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.09628918746001279, 'aggregate_val': 3427000000, 'exp_sum': 3126000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1275000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 146000000, 'Taxes': 425000000, 'OperatingExpenses': 571000000, 'remainder_Expenses': 709000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.006664691943127962, 'aggregate_val': 6797000000, 'exp_sum': 6752000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 6747000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 5000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.035302593659942365, 'aggregate_val': 7185000000, 'exp_sum': 6940000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1304000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 88000000, 'Taxes': 195000000, 'OperatingExpenses': 429000000, 'remainder_Expenses': 4924000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Revenues', 'missing_ratio': 0.018096272167933407, 'aggregate_val': 2813000000, 'exp_sum': 2763000000, 'exp_to_value': {'RevenueFromContractWithCustomer': 2756000000, 'GainLossOnDerivatives': 0, 'remainder_Revenues': 7000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001539838')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |