Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retieve Workbook Name via code | Excel Discussion (Misc queries) | |||
Retieve Workbook Name via code | Excel Discussion (Misc queries) | |||
lookup stock symbol on worksheet and return summary data | Excel Worksheet Functions | |||
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel | Excel Worksheet Functions | |||
How do I get real time stock quotes to my excel worksheet? | Excel Discussion (Misc queries) |