Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Function: under Data - Get External Data - New Web Query good day friends, i would like to query the stock quote copy to the data to the spread sheet by using the function "New Web Query" and link to the web page: http://finance.yahoo.com/q?s=msft msft = stock code, my question is: how can i make the stock code be a variable, or is it possible to prepare a stock code list to retrieve the data to spread sheet? thanks for your help -- vinrouge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
mid function in ms query | Excel Discussion (Misc queries) |