"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

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

Goto http://groups.yahoo.com/group/xltraders/
and look for author donalb36 and download my FREE files to do just this.


--
Don Guillett
SalesAid Software

"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