I would like to get “Selling Shareholders/Stockholders” or “Principal Shareholders/Stockholders” or “Principal and Selling Shareholders/Stockholders” table in “424” and “144”for 155 companies from SEC official website at [url removed, login to view]
Besides the table, other relevant information (such as filing date) is also needed. I have put the data I collected and organized in the spreadsheet called [url removed, login to view] . You can have get a feel by looking at the DemoMastersheet Tab in Demo.xls.
The complete list of company whose information I need is on the On CompanyList Tab, you will see the complete list of companies’ ticker symbol. You will use them to pull out data from SEC website.
There are 5 steps to get this result. I have put detailed illustration in the attachment of [url removed, login to view] and a sample output in [url removed, login to view]
Please do a small sample work of 6 for me to evaluate the quality of your work: company of AHL ("144" filed on 2006-09-01) DEX ("424B4" filed on 2004-07-22, "424B3" filed on 2004-08-17) and HERO ("424B4" filed on 2006-11-14, "424B5" filed on 2009-09-23) for me to evaluate your quality of work. I will not award the project without seeing the small sample work.
Let me know if you have any questions.
The date information in the Demo424144_20130212.xls is in the wrong format. Please use Demo424144_20130213.xls I attached below.