Extracting financial statements from SEC to Excel spreadsheet

We require a python program where I enter a stock ticker symbol that is listed on the NYSE or NASDAQ and then the financial statements of the company are extracted into an excel spreadsheet. The python program must extract the data from SEC/ Edgar database, the information must be extracted directly from the SEC XBRL. The financial statement should have information for at least 10 years for the company. The python program must allow me to enter the ticker symbol for any company listed on NYSE/ NASDAQ. The excel spreadsheet must have four different sheets. This first sheet should be the income statement, the second sheet should be the balance sheet. The third sheet should be the cash flow statement. The fourth sheet should have specific financial ratios that are calculated automatically from the information in the financial statement.

The specific deliverables are:
- A python program that allows for the input of any ticker symbol that is listed on NYSE/NASDAQ
- The python program must extract financial statement data from the sec database SEC XBRL
- The financial statement must be extracted into an excel spreadsheet with four sheets
- The four sheets should be 1)Income Statement ; 2) Balance Sheet ; 3) Cash Flow Statement ; 4) Financial ratios
- The financial information must contain at least 10 years of financial information
- The program must continuously provide updated information that is extracted from the SEC
About the recuiter
Member since May 20, 2018
Stacey Robinson
from Echternach, Luxembourg

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions