Prev Previous Post   Next Post Next
  #1   Report Post  
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.
 
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 05:18 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"