stock quotes
How can I build a work sheet to get stock quotes and put the quote in a different cell A5, A6, A7 every day. Can this worksheet update itself daily? sctroy -- sctroy ------------------------------------------------------------------------ sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928 View this thread: http://www.excelforum.com/showthread...hreadid=482265 |
stock quotes
yes it can be done
you need the url of the webpage from which you can download into Excel sheet(use data-get external data (or import data) (web query) and then you copy the relevant cell to some otehr cells preferably to some other sheet.-e.g. sheet2 next day you delete the previous days downloaded data and download fresh data and copy. you can create a vba for the whole process -- remove $$$ from email addresss to send email ================== "sctroy" wrote in message ... How can I build a work sheet to get stock quotes and put the quote in a different cell A5, A6, A7 every day. Can this worksheet update itself daily? sctroy -- sctroy ------------------------------------------------------------------------ sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928 View this thread: http://www.excelforum.com/showthread...hreadid=482265 |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com