Closed

Web-scraping of Company Press Releases

I am looking for two web-scraping codes, written in excel.

i) Collect all available historical press releases

I am looking for a web-scraping code to collect the historical press-releases from around 40 different company websites.

I would like the press releases downloaded into an excel spreadsheet, using the column headings below.

I would like the code to be written clearly for each company, so I can alter the company website address etc at a later date if required.

ii) Collect last month’s press releases

I would like a separate web-scraping code to capture all the press releases between two dates that I am able to change (say, 1 January 2017 to 30 April 2017).

This would then be downloaded into a separate tab of the same spreadsheet, under the same format.

Excel file format

The excel file should be structured under the following column headings:

>Date

>Company

>Press Release Hyperlink

>Press Release Title

>Press Release body (all the text)

Company population

For both codes, I would like the population of companies to include the following list. Each organises its historical contracts in a separate way, but rarely change.

* Technip

* TechnipFMC

* FMC Technologies

* Saipem

* Subsea 7

* Petrofac

* McDermott

* Wood Group

* Amec Foster Wheeler

* Schlumberger

* Halliburton

* Baker Hughes

* Weatherford

* Oceaneering

* SBM Offshore

* Modec

* National Oilwell Varco

* Aker Solutions

* Core Labs

* Hunting

* Tecnicas Reunidas

* Worley Parsons

* Tenaris

* Vallourec

* TMK

* Seadrill

* Transocean

* Diamond Offshore

* Ensco

* Atwood Oceanics

* Rowan Companies

* Pacific Drilling

* Helmerich & Payne

* Nabors

* Patterson

* Franks International

* TGS

* Fugro

* CGG

* PGS

Skills: Data Entry, MySQL, PHP, Software Architecture, Web Scraping

See more: scrape mls listings, free article scraper, scraping mls data, is baker hughes a good company to work for, software company agile web development, technology company cms web template, web baker template, software company buys web ideas, symbol company lookup web service, suggest company name web, web baker templates, website scraping web services, biggest company india web development, marketing company promote web site, screen scraping web free java

About the Employer:
( 0 reviews ) London, United Kingdom

Project ID: #14409431

1 freelancer is bidding on average £250 for this job

hwanghendra

Hired by the Employer

£250 GBP in 7 days
(500 Reviews)
7.6