dgunning / edgartools

Navigate SEC Edgar data in Python
MIT License
449 stars 88 forks source link

10-Q filings Facts to pandas dataframe #10

Closed vpanchal-code closed 1 year ago

vpanchal-code commented 1 year ago

First of all, This is really amazing! I am enjoying using it and makes it much more easier to find filings than the edgar sec website.

Is there a way to convert the latest 10-Q filing data to a pandas dataframe?

from edgar import *
set_identity("first last first.last@gmail.com")
company = Company(909832)
last10q = company.get_filings(form="10-Q").latest()
last10q.xbrl()
dgunning commented 1 year ago
xbrl = last10q.xbrl()
facts = xbrl.facts
df = facts.data
vpanchal-code commented 1 year ago

Thank you that worked! Much appreciated