Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save janlukasschroeder/3da274150fd00c1c1776c7e541a9b61b to your computer and use it in GitHub Desktop.
Save janlukasschroeder/3da274150fd00c1c1776c7e541a9b61b to your computer and use it in GitHub Desktop.
extracting-financial-statements-from-sec-filings.ipynb
Display the source blob
Display the rendered blob
Raw
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@janlukasschroeder
Copy link
Author

@EmilieTX try using pip install sec-api (dash instead of underscore)

@bennychee
Copy link

bennychee commented Nov 2, 2022

@janlukasschroeder Getting errors trying to output of
statement_1 = add_fourth_quarter_results(statement)

While trying to extract data from ticker:MU (Micron Technology).

 41                     for row_key, row_value in statement[column].iteritems():
---> 42                         value = num(statement[column][row_key]) - num(statement[column_1][row_key])
   44                         if isinstance(value, float):
   45                             value = round(value, 2)

TypeError: cannot convert the series to <class 'int'>

Any fix?

@seang700
Copy link

does this also work for the balance sheet and cash flow statement? bumping up against the call requests

@seang700
Copy link

seang700 commented May 25, 2023 via email

@srujantaticherla
Copy link

Do you have any API's to extract the stock prices (current , history)..?

@seang700
Copy link

seang700 commented May 25, 2023 via email

@tjf2007
Copy link

tjf2007 commented Aug 16, 2024

How do you think about dealing with REVISIONS point-in-time, similar to the vintage problem that ALFRED tries to solve for economic data? We know the PIT when the data was released, given the accceptanceDateTime via the accession_number

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment