Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"New Web Query" function
good day, are there any friends use New Web Query fuction under Data - import external data? My objective is to export (a list of stocks info) from web page to Excel spread sheet. e.g. the is is Microsoft's stock details (stock code: MSFT) http://finance.yahoo.com/q/ae?s=MSFT i can use "New Web Query" function to link this page to spread sheet. Question: how can I define a list of stocks (let say 10 different stocks) that I want to monitor apart from creating 10 different separate spreadsheets link with each individual stock code? any ideas are welcome thanks for your help. -- vinrouge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function: New Web Query | Links and Linking in Excel | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
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) |