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: web baker template, suggest company name web, web baker templates, company tender web design

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