| 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': 5.460011518525628, 'aggregate_val': 1346008000, 'exp_sum': 208360000, 'exp_to_value': {'RevenueFromContractWithCustomer': 0, 'GainLossOnDerivatives': 208360000, 'remainder_Revenues': 0}} |
| warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': 11.973882198592474, 'aggregate_val': 1355044000, 'exp_sum': -123479000, 'exp_to_value': {'RevenueFromContractWithCustomer': 0, 'GainLossOnDerivatives': -123479000, 'remainder_Revenues': 0}} |
| warning |
Invalid stock price, skipping obs_EconomicCapitalRatio |
industry.us_generic |
{'stock_price': nan} |
| warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000874499', 'EntityCommonStockSharesOutstanding': 159709221, 'Assets': 0, 'AssetsCurrent': 0, 'CostOfGoodsAndServicesSold': 0, 'DeferredIncomeTaxLiabilitiesNet': 3127000, 'DepreciationDepletionAndAmortization': 550108000, 'Expenses': 3042138000, 'GainLossOnDerivatives': 208360000, 'GeneralAndAdministrativeExpense': 47979000, 'Liabilities': 2568227000, 'LiabilitiesAndStockholdersEquity': 3882819000, 'LiabilitiesCurrent': 451198000, 'LongTermDebt': 2091852000, 'NetIncome': -2002358000, 'OilAndGasPropertySuccessfulEffortMethodNet': 0, 'OperatingExpenses': 82998000, 'PropertyPlantAndEquipment': 0, 'RevenueFromContractWithCustomer': 0, 'Revenues': 1346008000, 'Taxes': 28571000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 9193000, 'remainder_Expenses': 2332482000, 'remainder_Liabilities': 22050000, 'remainder_LiabilitiesAndStockholdersEquity': 1314592000, 'remainder_NetIncome': -306228000, 'remainder_Revenues': 1137648000, 'obs_EconomicCapitalRatio': nan}} |
| info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.10606588901375902, 'aggregate_val': 3042138000, 'exp_sum': 2750413000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 550108000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 47979000, 'Taxes': 28571000, 'OperatingExpenses': 82998000, 'remainder_Expenses': 2040757000}} |
| info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.37466870897837645, 'aggregate_val': 962655000, 'exp_sum': 1539432000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 486664000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 56633000, 'Taxes': 33480000, 'OperatingExpenses': 962724000, 'remainder_Expenses': -69000}} |
| info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000874499')"} |
| info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |