How can i retrieve stock data from yahoo finance in an excell worksheet and
have it update dynamically?

Look at the Web Query feature in Excel....

http://msdn.microsoft.com/library/de...keptSecret.asp

--
Charles
www.officezealot.com
"cv503" wrote in message
...
How can i retrieve stock data from yahoo finance in an excell worksheet
and
have it update dynamically?

You can make a macro which uses the web query feature or do it
manually. Make a new web query: DATA IMPORT EXTERNAL DATA NEW
WEBQUERY 'Enter an URL'
Use a made existing web query: DATA REFRESH DATA
Pleas take a look in Excel or VBA help for more info.
Hope this helps!

- Bas