Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot tables interface with queries | Excel Worksheet Functions | |||
Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
Show queries | Excel Discussion (Misc queries) | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) | |||
Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) |