Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vinrouge
 
Posts: n/a
Default "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   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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



  #3   Report Post  
Don Guillett
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function: New Web Query vinrouge Links and Linking in Excel 2 July 2nd 05 04:54 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Microsoft Query rejects "nz" function in Access Query Vaughan Excel Discussion (Misc queries) 0 May 4th 05 05:20 PM
Non-sequential VLOOKUP function -OR- sequential sort of web query Eric S Excel Worksheet Functions 1 February 28th 05 07:50 PM
mid function in ms query suhair Excel Discussion (Misc queries) 1 February 24th 05 04:51 PM


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"