dgunning / edgartools

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

Search specific data from the SEC Files #126

Closed MuslemRahimi closed 5 days ago

MuslemRahimi commented 1 month ago

Hey everyone,

I just wanted to know if it is possible to get specific data such as Data Center Revenue from Nvidia for each quarter which they report for the last 10 years.

Is that possible with the current library here?

Cheers

MuslemRahimi commented 1 month ago

Ok i have now

from edgar import *

set_identity("Michael Mccallum mike.mccalum@indigo.com")

filings = Company("NVDA").get_filings(form="10-Q").latest(10)
print(filings)
output = filings[0].search("Revenue by Geography")

print(output[18])

where the output is image

How can I convert the data which has docsection type into a pandas dataframe?

dgunning commented 1 month ago

Hey, I'm going to say no - not yet, but I'm actively working on a related issue around trying to get the breakdowns to display correctly. I will give an update on this based on my progress over the next few days

MuslemRahimi commented 3 weeks ago

Any updates yet?

dgunning commented 2 weeks ago

Yes,

c = Company("NVDA")
xb = c.get_filings(form="10-Q").latest(1).xbrl()

Look for the statement number

Statements
xb.statements[70]
ByRegion
MuslemRahimi commented 2 weeks ago

In my case when I run the code image

Is there a way to get the data in pandas form for further modifications?

dgunning commented 2 weeks ago

Yes. Use

 xb.statements[70].get_dataframe()
dgunning commented 5 days ago

Closed as answered