#1   Report Post  
Old March 16th 05, 03:41 AM
Adam
 
Posts: n/a
Default Web Queries

I am trying to set up a sheet to access stock quotes. I know the site and
table, but I want to list a column of stock codes from which a web query
grabs the code and runs to download the stock quote. I know how to select the
parameters for a conventional query, but can anyone suggest a quick way that
I can expand the query down the sheet quickly as you would a formula with
cell references so that I can have a row of stock code, then the query
referencing the code in that row returning the quote.

  #3   Report Post  
Old March 18th 05, 01:53 AM
Adam I
 
Posts: n/a
Default

grabbing a stock code from a column, e.g.
IBM
TW
RHD
MMM etc
going to http://finance.yahoo.com/q?s=XXX, where XXX is the required stock
code
Select no formatting and only Table 11 of the web page and you get the stock
name and price retrieved to 2 Excel cells

"Don Guillett" wrote:

Give complete detail as to url & list etc. OR

Try yahoo instead or go here and get my FREE excel file for quotes or
history. Look for donaldb36 as author.



--
Don Guillett
SalesAid Software

"Adam" wrote in message
...
I am trying to set up a sheet to access stock quotes. I know the site and
table, but I want to list a column of stock codes from which a web query
grabs the code and runs to download the stock quote. I know how to select

the
parameters for a conventional query, but can anyone suggest a quick way

that
I can expand the query down the sheet quickly as you would a formula with
cell references so that I can have a row of stock code, then the query
referencing the code in that row returning the quote.






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
pivot tables interface with queries biviluv Excel Worksheet Functions 0 March 15th 05 08:15 PM
Parameters are not allowed in queries that can't be displayed grap Flora Tzeng Excel Discussion (Misc queries) 1 March 15th 05 10:34 AM
Show queries Brett Excel Discussion (Misc queries) 1 March 7th 05 05:31 PM
Excel 2003 This Workbook contains queries to external data Puzzled of Springburn Excel Discussion (Misc queries) 0 February 8th 05 03:21 PM
Layout/Formatting problems of Data Queries in Excel? Andrew Harding Excel Discussion (Misc queries) 0 December 23rd 04 03:51 AM


All times are GMT +1. The time now is 10:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017