Create a simple macro enabled excel spreadsheet

Job ID: 36358886

Budget: $30 – $250 AUD

My project is to create a simple, macro-enabled excel spreadsheet. I need it to support basic data entry and calculations, as well as to be able to pull data from external sources. The spreadsheet does not need to be formatted but should be accessible and easy to use to any who comes across it. I need someone with excel skills to create this spreadsheet and make sure it works properly.

These are the three external data sources that the spreadsheet will pull data from;

• http://www.exchange-rates.org/history/CNY/USD/T
• http://www.96369.net/indices/125
• https://index.mysteel.com/xpic/detail.html?tabName=jiaotan

Attached is the formula that the spreadsheet needs to perform and produce a daily line graph indicating the indexed price change.

Thanks for considering this project.
Related categories: Visual Basic Data Processing Data Entry Excel