I have a list of Fortune 1000 companies.
I want a script where I can upload that list, and it will extract a list of their corporate officers from Reuters.com.
It should search [url removed, login to view] for the company name, select the link that says "Stock Result" by the company name in the search results, and then go to the page that says "Officers and Directors".
And then scrape from the page all under the columns "name" and "current position" and store it in a spreadsheet easy to download.
The spreadsheet should have these columns:
COMPANY NAME POSITION
I have PHP and MYSQL.