dgunning / edgartools

Navigate SEC Edgar data in Python
MIT License
460 stars 90 forks source link

Missing Fields in Income Statement Facts #73

Closed amitgandhinz closed 2 months ago

amitgandhinz commented 2 months ago

For some 10Q imports, some facts are missing when querying the facts table.

For example, in the latest 10Q (Q2 2024) for $GD, the 10Q contains rows for Costs of Products and Services (us-gaap:CostOfGoodsAndServicesSold) but this fact is never loaded into the facts table in Edgar-tools or in the income-statement printed.

Likewise for "us-gaap:InterestIncomeExpenseNet" and "us-gaap:OtherNonoperatingIncomeExpense" facts.

This may possibly be related to these fields having a role of "http://fasb.org/us-gaap/role/ref/legacyRef" while most of the facts that do get loaded have a role of "http://www.xbrl.org/2003/role/disclosureRef"

image

dgunning commented 2 months ago

Hey Amit,

I'm working on a rewrite of the XBRL financials the intent of which is to render the data row for row as it is in the financials statements. Here is what it looks like now for General Dynamic

GDFinancials

It's technically inside of edgartools now, but I need a few more rounds of testing to get it rock solid. I have been incorporating you findings in the new code base so that thanks for that. Should be stable within a week or so

Will keep you posted

amitgandhinz commented 2 months ago

Awesome. Thanks so much. Look forward to trying out the changes

dgunning commented 2 months ago

Tracking changes on Financials Extraction from XBRL