LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
vinrouge
 
Posts: n/a
Default Function: New Web Query


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
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
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
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
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 06:35 PM.

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

About Us

"It's about Microsoft Excel"