Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add or delete symbols Stock Quotes | Excel Discussion (Misc queries) | |||
getting stock quotes | Excel Discussion (Misc queries) | |||
How do I get stock quotes in Excel without text? | Excel Worksheet Functions | |||
msn stock quotes | Excel Discussion (Misc queries) | |||
Stock Quotes in Excel 2003 | Excel Discussion (Misc queries) |