EDGAR-CRAWLER: Extract Key Financial Data from SEC Filings Effortlessly 🚀

EDGAR-CRAWLER is the only open-source toolkit that downloads raw and unstructured financial SEC filings from EDGAR and converts them into structured JSON files in order to bootstrap financial NLP experiments.

EDGAR-CRAWLER has 2 core functionalities:

📥 Seamless downloading: Retrieve and download financial filings from all US publicly-traded companies based on your specified filters, like year, quarters, filing type, etc.
🔍 Structured JSON output: Extract and parse specific key sections from 10-K, 10-Q, and 8-K filings into a nice-and-easy standardized JSON format. (filings supported: 10-K, 10-Q, 8-K)

🚨 News

2024/10: We now support structured JSON output for 10-Q and 8-K filings. (@Bailefan)
2023/12: We had a Lightning Talk about EDGAR-CRAWLER at the 3rd Workshop for Natural Language Processing Open Source Software (NLP-OSS), hosted at EMNLP 2023, in Singapore.
2023/01: EDGAR-CORPUS, the biggest financial NLP corpus (generated from EDGAR-CRAWLER!), is available as a HuggingFace 🤗 dataset card. See Accompanying Resources.
2022/10: Updated documentation and fixed a minor import bug affecting older Python versions.
2022/04: EDGAR-CRAWLER is available for Windows systems too.
2021/11: We presented EDGAR-CORPUS, our "parent" project that started it all, at ECONLP 2021 (EMNLP Workshop) at the Dominican Republic. See Accompanying Resources for more details. An early/alpha version of EDGAR-CRAWLER was built for that project.

Example JSON Outputs

Other than downloading the raw filings, EDGAR-CRAWLER is the only open-source toolkit that converts the complex and unstructured SEC filings to structured JSON outputs for easier integration to your research and development. Below are examples of such outputs for each supported filing type:

10-K filing (Annual Report)

Original report: Apple 10-K from 2022

{
  "cik": "320193",
  "company": "Apple Inc.",
  "filing_type": "10-K",
  "filing_date": "2022-10-28",
  "period_of_report": "2022-09-24",
  "sic": "3571",
  "state_of_inc": "CA",
  "state_location": "CA",
  "fiscal_year_end": "0924",
  "filing_html_index": "https://www.sec.gov/Archives/edgar/data/320193/0000320193-22-000108-index.html",
  "htm_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/000032019322000108/aapl-20220924.htm",
  "complete_text_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/0000320193-22-000108.txt",
  "filename": "320193_10K_2022_0000320193-22-000108.htm",
  "item_1": "Item 1. Business\nCompany Background\nThe Company designs, manufactures ...",
  "item_1A": "Item 1A. Risk Factors\nThe Company’s business, reputation, results of ...",
  "item_1B": "Item 1B. Unresolved Staff Comments\nNone.",
  "item_1C": "",
  "item_2": "Item 2. Properties\nThe Company’s headquarters are located in Cupertino, California. ...",
  "item_3": "Item 3. Legal Proceedings\nEpic Games\nEpic Games, Inc. (“Epic”) filed a lawsuit ...",
  "item_4": "Item 4. Mine Safety Disclosures\nNot applicable. ...",
  "item_5": "Item 5. Market for Registrant’s Common Equity, Related Stockholder ...",
  "item_6": "Item 6. [Reserved]\nApple Inc. | 2022 Form 10-K | 19",
  "item_7": "Item 7. Management’s Discussion and Analysis of Financial Condition ...",
  "item_8": "Item 8. Financial Statements and Supplementary Data\nAll financial ...",
  "item_9": "Item 9. Changes in and Disagreements with Accountants on Accounting and Financial Disclosure\nNone.",
  "item_9A": "Item 9A. Controls and Procedures\nEvaluation of Disclosure Controls and ...",
  "item_9B": "Item 9B. Other Information\nRule 10b5-1 Trading Plans\nDuring the three months ...",
  "item_9C": "Item 9C. Disclosure Regarding Foreign Jurisdictions that Prevent Inspections\nNot applicable. ...",
  "item_10": "Item 10. Directors, Executive Officers and Corporate Governance\nThe information required ...",
  "item_11": "Item 11. Executive Compensation\nThe information required by this Item will be included ...",
  "item_12": "Item 12. Security Ownership of Certain Beneficial Owners and Management and ...",
  "item_13": "Item 13. Certain Relationships and Related Transactions, and Director Independence ...",
  "item_14": "Item 14. Principal Accountant Fees and Services\nThe information required ...",
  "item_15": "Item 15. Exhibit and Financial Statement Schedules\n(a)Documents filed as part ...",
  "item_16": "Item 16. Form 10-K Summary\nNone.\nApple Inc. | 2022 Form 10-K | 57"
}

10-Q (Quarterly Report)

Click to see a full structured output example of a 10-Q filing.

Original report: Apple 10-Q from Q1 2024

{
  "cik": "320193",
  "company": "Apple Inc.",
  "filing_type": "10-Q",
  "filing_date": "2024-05-03",
  "period_of_report": "2024-03-30",
  "sic": "3571",
  "state_of_inc": "CA",
  "state_location": "CA",
  "fiscal_year_end": "0928",
  "filing_html_index": "https://www.sec.gov/Archives/edgar/data/320193/0000320193-24-000069-index.html",
  "htm_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/000032019324000069/aapl-20240330.htm",
  "complete_text_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/0000320193-24-000069.txt",
  "filename": "320193_10Q_2024_0000320193-24-000069.htm",
  "part_1": "PART I - FINANCIAL INFORMATION\nItem 1. Financial Statements\nApple Inc.\nCONDENSED CONSOLIDATED STATEMENTS ...",
  "part_1_item_1": "Item 1. Financial Statements\nApple Inc.\nCONDENSED CONSOLIDATED STATEMENTS ...",
  "part_1_item_2": "Item 2. Management’s Discussion and Analysis of Financial Condition and ...",
  "part_1_item_3": "Item 3. Quantitative and Qualitative Disclosures About Market Risk\nThere have ...",
  "part_1_item_4": "Item 4. Controls and Procedures\nEvaluation of Disclosure Controls and ...",
  "part_2": "PART II - OTHER INFORMATION\nItem 1. Legal Proceedings\nDigital Markets Act Investigations\nOn ...",
  "part_2_item_1": "Item 1. Legal Proceedings\nDigital Markets Act Investigations\nOn March 25, 2024, ...",
  "part_2_item_1A": "Item 1A. Risk Factors\nThe Company’s business, reputation, ...",
  "part_2_item_2": "Item 2. Unregistered Sales of Equity Securities and Use of ...",
  "part_2_item_3": "Item 3. Defaults Upon Senior Securities\nNone.",
  "part_2_item_4": "Item 4. Mine Safety Disclosures\nNot applicable.",
  "part_2_item_5": "Item 5. Other Information\nInsider Trading Arrangements\nNone.",
  "part_2_item_6": "Item 6. Exhibits\nIncorporated by Reference\nExhibit\nNumber\nExhibit Description ..."
}

Note: part_1 and part_2 contain the full detected text for that Part. We provide that, since in some old 10-Q files, it is not possible to extract the information in item level.

8-K (Important Current Report)

Click to see a full structured output example of an 8-K filing.

Original report: Apple 8-K from 2022-08-19

{
  "cik": "320193",
  "company": "Apple Inc.",
  "filing_type": "8-K",
  "filing_date": "2022-08-19",
  "period_of_report": "2022-08-17",
  "sic": "3571",
  "state_of_inc": "CA",
  "state_location": "CA",
  "fiscal_year_end": "0924",
  "filing_html_index": "https://www.sec.gov/Archives/edgar/data/320193/0001193125-22-225365-index.html",
  "htm_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/000119312522225365/d366128d8k.htm",
  "complete_text_filing_link": "https://www.sec.gov/Archives/edgar/data/320193/0001193125-22-225365.txt",
  "filename": "320193_8K_2022_0001193125-22-225365.htm",
  "item_1.01": "",
  "item_1.02": "",
  "item_1.03": "",
  "item_1.04": "",
  "item_1.05": "",
  "item_2.01": "",
  "item_2.02": "",
  "item_2.03": "",
  "item_2.04": "",
  "item_2.05": "",
  "item_2.06": "",
  "item_3.01": "",
  "item_3.02": "",
  "item_3.03": "",
  "item_4.01": "",
  "item_4.02": "",
  "item_5.01": "",
  "item_5.02": "Item 5.02 Departure of Directors or Certain Officers; Election of Directors; Appointment ...",
  "item_5.03": "Item 5.03 Amendments to Articles of Incorporation or Bylaws; Change in Fiscal Year.\nOn August 17, 2022, Apple’s Board approved and adopted amended and restated bylaws ...",
  "item_5.04": "",
  "item_5.05": "",
  "item_5.06": "",
  "item_5.07": "",
  "item_5.08": "",
  "item_6.01": "",
  "item_6.02": "",
  "item_6.03": "",
  "item_6.04": "",
  "item_6.05": "",
  "item_7.01": "",
  "item_8.01": "",
  "item_9.01": "Item 9.01 Financial Statements and Exhibits.\n(d) Exhibits.\nExhibit\nNumber\nExhibit ...",
}

Install

Download EDGAR-CRAWLER locally via SSH or HTTPS:

# Method 1: SSH 
git clone https://github.com/nlpaueb/edgar-crawler.git 

# Method 2: HTTPS
git clone git@github.com:nlpaueb/edgar-crawler.git

Then, it's recommended to create a new virtual environment using Python 3.8 by installing and using Anaconda.

conda create -n edgar-crawler-venv python=3.8 # After installing Anaconda, create a venv with python 3.8+
conda activate edgar-crawler-venv # Activate the environment

Then, install the toolkit's dependencies via:

pip install -r requirements.txt # Install requirements for edgar-crawler

Usage

Before running any script, you should edit the config.json file, which configures the behavior of our 2 modules (one for downloading the filings of your choice, the other one for getting the structured output of them).
- Arguments for download_filings.py, the module to download financial reports:
  - start_year XXXX: the year range to start from (default is 2023).
  - end_year YYYY: the year range to end to (default is 2023).
  - quarters: the quarters that you want to download filings from (List).
    Default value is: [1, 2, 3, 4].
  - filing_types: list of filing types to download.
    Default value is: ['10-K', '8-K', '10-Q'].
  - cik_tickers: list or path of file containing CIKs or Tickers. e.g. [789019, "1018724", "AAPL", "TWTR"]
    In case of file, provide each CIK or Ticker in a different line.
    If this argument is not provided, then the toolkit will download annual reports for all the U.S. publicly traded companies.
  - user_agent: the User-agent (name/email) that will be declared to SEC EDGAR.
  - raw_filings_folder: the name of the folder where downloaded filings will be stored.
    Default value is 'RAW_FILINGS'.
  - indices_folder: the name of the folder where EDGAR TSV files will be stored. These are used to locate the annual reports. Default value is 'INDICES'.
  - filings_metadata_file: CSV filename to save metadata from the reports.
  - skip_present_indices: Whether to skip already downloaded EDGAR indices or download them nonetheless.
    Default value is True.
- Arguments for extract_items.py, the module to clean and extract textual data from already-downloaded reports:
  - raw_filings_folder: the name of the folder where the downloaded documents are stored.
    Default value s 'RAW_FILINGS'.
  - extracted_filings_folder: the name of the folder where extracted documents will be stored.
    Default value is 'EXTRACTED_FILINGS'.
    For each downloaded report, a corresponding JSON file will be created containing the item sections as key-pair values.
  - filings_metadata_file: CSV filename to load reports metadata (Provide the same csv file as in download_filings.py).
  - filing_types: list of filing types to extract.
  - include_signature: Whether to include the signature section after the last item or not.
  - items_to_extract: a list with the certain item sections to extract.
    e.g. ['7','8'] to extract 'Management’s Discussion and Analysis' and 'Financial Statements' section items for 10-K reports.
    By default, this list is empty, in which case all items are extracted.
  - remove_tables: Whether to remove tables containing mostly numerical (financial) data. This work is mostly to facilitate NLP research where, often, numerical tables are not useful.
  - skip_extracted_filings: Whether to skip already extracted filings or extract them nonetheless.
    Default value is True.
To download the raw financial reports from EDGAR, run python download_filings.py.
To clean and extract specific item sections from already-downloaded documents, run python extract_items.py.
- Reminder: We currently support the structured JSON output for 10-K, 10-Q and 8-K documents.
- Note: For older 10-Q filings, it might not be possible to extract any items for specific parts (Part 1 or Part 2). Because of this, we also include each full part in the output file as a separate entry.

Citation

An EDGAR-CRAWLER paper is on its way. Until then, please cite our relevant EDGAR-CORPUS paper published at ECONLP@EMNLP 2021 (Punta Cana, Dominican Republic).

@inproceedings{loukas-etal-2021-edgar-corpus-and-edgar-crawler,
    title = "{EDGAR}-{CORPUS}: {B}illions of {T}okens {M}ake {T}he {W}orld {G}o {R}ound",
    author = "Loukas, Lefteris  and
      Fergadiotis, Manos  and
      Androutsopoulos, Ion  and
      Malakasiotis, Prodromos",
    booktitle = "Proceedings of the Third Workshop on Economics and Natural Language Processing (ECONLP)",
    month = nov,
    year = "2021",
    address = "Punta Cana, Dominican Republic",
    publisher = "Association for Computational Linguistics",
    url = "https://aclanthology.org/2021.econlp-1.2",
    pages = "13--18",
}

Read the EDGAR-CORPUS paper here: https://aclanthology.org/2021.econlp-1.2/

Star History

Accompanying Resources

Here are some additional resources created by using EDGAR-CRAWLER:

EDGAR-CORPUS: The largest financial NLP corpus, 6+ billion tokens from annual reports (HuggingFace URL 🤗) | (Zenodo URL).
EDGAR-W2V: Financial Word2Vec embeddings, pre-trained on EDGAR-CORPUS (Zenodo URL)

Feedback for EDGAR-CRAWLER

Do you have any feature request? Tell us directly using this Google Form: (https://forms.gle/bpV8nxMqX8Sq2v5z8)!

Contributing

PRs and contributions are accepted. We use the Feature Branch Workflow.

Issues

Please create an issue on GitHub instead of emailing us directly so all possible users can benefit from the troubleshooting.

License

This software is licensed under the GNU General Public License v3.0, a license approved by the Open-Source Initiative (OSI).

Name		Name	Last commit message	Last commit date
Latest commit History 91 Commits
datasets		datasets
images		images
logs		logs
tests		tests
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
__init__.py		__init__.py
config.json		config.json
download_filings.py		download_filings.py
extract_items.py		extract_items.py
item_lists.py		item_lists.py
logger.py		logger.py
requirements.txt		requirements.txt

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

EDGAR-CRAWLER: Extract Key Financial Data from SEC Filings Effortlessly 🚀

🚨 News

Table of Contents

Example JSON Outputs

10-K filing (Annual Report)

10-Q (Quarterly Report)

8-K (Important Current Report)

Install

Usage

Citation

Star History

Accompanying Resources

Feedback for EDGAR-CRAWLER

Contributing

Issues

License

About

Releases

Packages

Contributors 4

Languages

License

nlpaueb/edgar-crawler

Folders and files

Latest commit

History

Repository files navigation

EDGAR-CRAWLER: Extract Key Financial Data from SEC Filings Effortlessly 🚀

🚨 News

Table of Contents

Example JSON Outputs

10-K filing (Annual Report)

10-Q (Quarterly Report)

8-K (Important Current Report)

Install

Usage

Citation

Star History

Accompanying Resources

Feedback for EDGAR-CRAWLER

Contributing

Issues

License

About

Topics

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Contributors 4

Languages

Packages