Write a web query for Excel

Write a web query for Excel

Closed - This job posting has been filled and work has been completed.

Job Description

Hello

I need an Excel web query/macro that does the following:

- extracts data from the attached web page
- inserts it into a sheet in an Excel document
- runs every 5 minutes
- sends out email (other notification) alerts for when certain conditions are satisfied (including when there has been a failure to update, or some software glitch)

Preferably this would be done in OS, but we can accommodate Windows also.

NB - if the web query is done in PC - the website that has the data can only handle Chrome and Safari browsers.

This is a reworking of a previous job -apologies to previous applicants - have decided that this should be sufficient.

Open Attachment