What are the 10 most frequent SEC filing types and how to find out?
1. Read the filing index
First we need to read a large bunch of data from the filing index. I am not going to cover here the details of downloading the filing index data, because it is described here at the https://www.sec.gov homepage. Instead let’s assume we have the full filing index files for Q3, Q4, Q1 and Q2 downloaded and saved as files like this:
To illustrate and help the further understanding, here is an example of what such a filing index files looks like:
The filings array is the source of data we are going to use for the further analysis.
2. Build a histogram data structure for the different filing form types
The histogram is stored in an object. The property names are the filing form types and the property value represent the count of this form type in the given quarters. Each entry from the filings array gets analyzed by a little function:
I keep this super simple, but it is sufficient to get a good overview of how often the different filing form types occur. I am using ascii-histogram which you can find on npm. Important is that you turn the sort feature on to get a properly sorted histogram.