search

dgunning / edgartools

Navigate SEC Edgar data in Python
MIT License
516 stars 101 forks source link

XBRL Class some line-items do not have an accurate +/- when exporting to excel. #108

Closed david08-08 closed 2 months ago

david08-08 commented 2 months ago

I am not sure if this is a bug that needs to be looked into more. But when using the XBRL class some of the numbers that are being exported into excel are not properly being identified as a positive or negative number. If you look at Apple 2023 Financial Statements (Consolidated Statements of Cashflows) some of the line items are not accurate. I provided a few below. Is there a fix to this or any idea how this can be addressed?

us-gaap_OtherNoncashIncomeExpense us-gaap_PaymentsForRepurchaseOfCommonStock us-gaap_PaymentsForProceedsFromOtherInvestingActivities

dgunning commented 2 months ago

Looking into it

dgunning commented 2 months ago

I think I found the issue. Some values require using the calculation file to apply the negative of the number. This was one file I had parsed but hadn't yet applied because I didn't know how to apply the calculation logic. Now I have an idea. This will take a couple of days - I'm running into a busy period, but will try to get it in the next release

dgunning commented 2 months ago

Release 2.30.0 with a fix of this issue