how can i retieve stock data in an excel worksheet?
How can i retrieve stock data from yahoo finance in an excell worksheet and
have it update dynamically? |
how can i retieve stock data in an excel worksheet?
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? |
how can i retieve stock data in an excel worksheet?
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 |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com