ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can i retieve stock data in an excel worksheet? (https://www.excelbanter.com/excel-programming/311817-how-can-i-retieve-stock-data-excel-worksheet.html)

cv503

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?

Charles Maxson

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?




Bas Mekel

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