SEC Edgar - Filing Date

Closed

Publicly traded companies report financial results with the Securities and Exchange Commission (SEC) on a regular basis (at least every quarter). All of these filings are publicly available for free on the SEC website.

Currently, I have a long list of publicly traded companies, both company names and unique identifier - Central Index Key (CIK) number. I also many fiscal period end dates for each company (both quarterly and annual filings). What I do not have, yet still need, is the date that the company filed the fiscal information with the SEC (ie – Filing Date).

I would like an Excel Macro which will take my data, download the filing information from the SEC search and then input the filing date for each period end date.

I suspect it is a simple project (and I also suspect someone else has already built it)

The following URL is the SEC company search page: [url removed, login to view]

On the right hand side is the Fast Search Option which searches through the filings by CIK number. Once you enter a CIK (example is Whirlpool, CIK = 0000106640), the website pulls up all company filings. Above the list of results is additional filtering options – I will need filing type “10-Q” (quarterly filings) and/or “10-K” (annual filing).

Examples of filtered results for two companies are below. Note the intuitive simplicity of the url – it incorporates the CIK number, the 10-Q and can also change the number of observations to 100.

Whirlpool (CIK = 0000106640) [url removed, login to view]

You can further change the search by limiting the search to either 10-Q or 10-K by limiting search to Filing Type =‘10’;

Apple (CIK = 0000320193) [url removed, login to view]

My list of data includes CIK number, company name, fiscal year, fiscal quarter and period end dates. The macro will need to identify unique CIK numbers from this list, search [url removed, login to view] for dates filed – pull the associated filing dates and link each period end date to the associated filing date. I had planned to download entire table (class=[url removed, login to view]) into excel, then link each filing date to my list. Unfortunately, I do not have the time to invest into building this macro and I’m certain that someone else can create it rather quickly.

My current list has over 100,000 company reporting periods, I selected only 2 companies in the attached example. To clarify – this is a macro that I intend to use on a recurring basis with other companies and periods in the future – so I need to macro not just the filing dates for the current list.

I have included a small subset of my data in the attachment (and the downloads from [url removed, login to view]).

Other items to consider: the filing date MUST come from will not occur until after the

Skills: Data Entry, Excel, Visual Basic

See more: edgar sec download excel data, what is date entry, what is data entry 10 key, what is a 10 key data entry, pull data from website into excel, macro to pull data from website, filing data entry, excel macro pull data from website, cgi companies, www data entry gov, website sec, type names (date entry), securities, sec, sec filings, fiscal, edgar, date entire, come up with 100 small, cik, excel recurring, filings, apple type project, download html table excel, sec filings download excel

Project ID: #5121845

Awarded to:

dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$166 USD in 10 days
(70 Reviews)
5.4

7 freelancers are bidding on average $211 for this job

LearningNew

A proposal has not yet been provided

$250 USD in 7 days
(2 Reviews)
3.7
inoussakabore

Aucune proposition n'a encore été fournie.

$250 USD in 3 days
(2 Reviews)
3.3
Rakhi1110

i can give 5-8 hrs per day for this job. good in Microsoft office. Software Engineer by profession. Good at all kind of internet and data entry obs. Honest towards my work.

$150 USD in 8 days
(0 Reviews)
0.0
Yanne1582

I am very interested to participate in this project. I will give my best to you, and the guarantee is this work will be ready on time. Hire me, please..

$155 USD in 10 days
(0 Reviews)
0.0
lovelife521

Hi, thank you for providing this great opportunity. As you can see both my working experience and degree are in finance area. I will do my best for this data entry. : ) If you have any questions please More

$244 USD in 8 days
(0 Reviews)
0.0
fattahaabdul

I can do this work easily. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level

$263 USD in 10 days
(1 Review)
0.0