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 |
#2
|
|||
|
|||
in indian portal yahoo finance there is a provision for your own portofilio
I am sure you can also dothat. then you can have get external data any no. of time each day. bsed on that you can have your own other workhsheets to manipulate this data. I am doing it for my small no. of stocks. -- remove $$$ from email addresss to send email vinrouge wrote in message ... 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 |
Reply |
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) |