Clean Data Extracted from SEC Website

The Securitiy and Exchange Commission in the U.S. publishes a lot of data that can be used in corporate finance.  This data includes financial reports, acquisitions, new securities issues and investor analyst presentations.  The SEC clean up file allows you to copy the data into an excel file and then it cleans up the data. The SEC clean up data file works with a macro that is somewhat like the read pdf to excel function.

To operate the clean up SEC system, you can download the file that includes the macros below. The file must be opened  after you copy data from the SEC website.  Once the file is opened, follow the instructions in the file.

Reading Financial Data From the SEC Website

The two videos below demonstrate how to operate the macro that cleans up the data downloaded from the SEC website.  Like any of the macros on this website, you can modify the macros yourself.