Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

Excel - Auto update of daily web data into excel

By k_rowewilson ·
Hi,

I want to set up an excel ssheet to automatically pull price data from a website into a cell. Furthermore, each day I want the new price to be added into the next available cell down from yesterday's update, in order for me to keep a historical record and graph it.

Eg. on 2 Jan I want the script to update the gold price from http://www.kitco.com/market/ to cell B5 and save. On 3 Jan I want it to update the price into cell B6 and save, without overwriting B5, and so on.

Is this possible (using a macro or something), and if so what must I do.

Please provide easy to follow steps as I'm clueless! (-;

Thanks,
Keith

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums