Who I am looking for
I am looking for an experienced VPS, web scraper/parser, mysql & VBA excel macro expert… You MUST have an expertise in all these fields.
I have a vps which I would like to run an excel macro workbook from but it requires a web scraper/parser to get the data and extra coding to insert that data into the correct sheet on the macro workbook.
The general idea
I would like you to create a web scraper/parser that will gather data from a website and input into tables on a mysql database (that you will create). Then the program/coding needs to insert certain date from the tables into specific sheets on the macro workbook. Plus you will need to create the correct coding on the vps to run the macros on the workbook.
The web scraper you create will also need to be set up as a cron job and will need to run after midnight each day, as the data I require changes daily, you will also need to create a simple way of the user (me) been able to run the web scraper as and when I want, this is just in case the website has not updated or has downtime.
The website is a password protected website, so you would first have to sign up for free to evaluate