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 http://www.sec.gov/edgar/searchedgar/companysearch.html
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 Demo.xls . 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 ProjectDescription.doc and a sample output in Demo424144_20130212.xls
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.
Additional Project Description:
02/13/2013 at 20:45 EAT
The date information in the Demo424144_20130212.xls is in the wrong format. Please use Demo424144_20130213.xls I attached below.