warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Potential income statement missing revenue and net income |
input.sec.get_statements |
{'available_keys': ['DebtInstrumentCarryingAmount', 'DebtInstrumentUnamortizedDiscountPremiumNet', 'UnamortizedDebtIssuanceExpense', 'LongTermDebt', 'LongTermDebtCurrent', 'LongTermDebtNoncurrent', 'DebtInstrumentMaturityDate', 'DebtInstrumentInterestRateStatedPercentage']} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.7861806311207835, 'aggregate_val': 13132000000, 'exp_sum': 7352000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 2223000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 395000000, 'Taxes': 0, 'OperatingExpenses': 2826000000, 'remainder_Expenses': 1908000000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.8253164556962025, 'aggregate_val': 9373000000, 'exp_sum': 5135000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 2158000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 391000000, 'Taxes': 0, 'OperatingExpenses': 2145000000, 'remainder_Expenses': 441000000}} |
warning |
Large missing amount for aggregate "Expenses" added to remainder. |
industry.us_generic |
{'missing_ratio': 0.7861806311207835, 'aggregate_val': 13132000000, 'exp_sum': 7352000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 2223000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 395000000, 'Taxes': 0, 'OperatingExpenses': 2826000000, 'remainder_Expenses': 1908000000}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0001090012', 'EntityCommonStockSharesOutstanding': 468200000, 'Assets': 19566000000, 'AssetsCurrent': 4437000000, 'ComprehensiveNetIncome': 0, 'CostOfGoodsAndServicesSold': 0, 'DeferredIncomeTaxLiabilitiesNet': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GainLossOnDerivatives': 0, 'GeneralAndAdministrativeExpense': 0, 'Liabilities': 2226000000, 'LiabilitiesAndStockholdersEquity': 19566000000, 'LiabilitiesCurrent': 2226000000, 'LongTermDebt': 0, 'NetIncome': 0, 'OilAndGasPropertySuccessfulEffortMethodNet': 12813000000, 'OperatingExpenses': 0, 'PropertyPlantAndEquipment': 13935000000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 0, 'Taxes': 0, 'remainder_Assets': -11619000000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 0, 'remainder_LiabilitiesAndStockholdersEquity': 8154000000, 'remainder_NetIncome': 0, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 9186000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4328782843617759, 'aggregate_val': 23721000000, 'exp_sum': 41827000000, 'exp_to_value': {'PropertyPlantAndEquipment': 18106000000, 'AssetsCurrent': 3891000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 16567000000, 'remainder_Assets': 3263000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.2702816309373686, 'aggregate_val': 10416000000, 'exp_sum': 14274000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 2780000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 617000000, 'Taxes': 461000000, 'OperatingExpenses': 9776000000, 'remainder_Expenses': 640000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.41595773260499685, 'aggregate_val': 19566000000, 'exp_sum': 33501000000, 'exp_to_value': {'PropertyPlantAndEquipment': 13935000000, 'AssetsCurrent': 4437000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 12813000000, 'remainder_Assets': 2316000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.38516360376512776, 'aggregate_val': 13717000000, 'exp_sum': 22310000000, 'exp_to_value': {'PropertyPlantAndEquipment': 8593000000, 'AssetsCurrent': 3851000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 7558000000, 'remainder_Assets': 2308000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.37569988801791715, 'aggregate_val': 7371000000, 'exp_sum': 5358000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1300000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 338000000, 'Taxes': 0, 'OperatingExpenses': 1290000000, 'remainder_Expenses': 2430000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3523685070238484, 'aggregate_val': 9912000000, 'exp_sum': 15305000000, 'exp_to_value': {'PropertyPlantAndEquipment': 5393000000, 'AssetsCurrent': 3260000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 4436000000, 'remainder_Assets': 2216000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.37569988801791715, 'aggregate_val': 7371000000, 'exp_sum': 5358000000, 'exp_to_value': {'DepreciationDepletionAndAmortization': 1300000000, 'CostOfGoodsAndServicesSold': 0, 'GeneralAndAdministrativeExpense': 338000000, 'Taxes': 0, 'OperatingExpenses': 1290000000, 'remainder_Expenses': 2430000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.3523685070238484, 'aggregate_val': 9912000000, 'exp_sum': 15305000000, 'exp_to_value': {'PropertyPlantAndEquipment': 5393000000, 'AssetsCurrent': 3260000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 4436000000, 'remainder_Assets': 2216000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.41650709072239334, 'aggregate_val': 21025000000, 'exp_sum': 36033000000, 'exp_to_value': {'PropertyPlantAndEquipment': 15008000000, 'AssetsCurrent': 4249000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 13536000000, 'remainder_Assets': 3240000000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Assets', 'missing_ratio': 0.4328782843617759, 'aggregate_val': 23721000000, 'exp_sum': 41827000000, 'exp_to_value': {'PropertyPlantAndEquipment': 18106000000, 'AssetsCurrent': 3891000000, 'OilAndGasPropertySuccessfulEffortMethodNet': 16567000000, 'remainder_Assets': 3263000000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0001090012')"} |
info |
Ambiguous roles for statement |
input.sec.calculation_linkbase.expand_agg |
{'statement': 'operations', 'valid_roles': {'100010 - Statement - Consolidated Statements of Comprehensive Earnings': 20, '100040 - Statement - Consolidated Statements of Comprehensive Earnings 2': 4}} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |