stock quotes

[sctroy]

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

[R.VENKATARAMAN]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>