If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Q: "Linked Queries" | MarkD | Running & Setting Up Queries | 4 | January 18th, 2005 08:12 PM |
Report of Queries link to other queries | Tom Tripicchio | Running & Setting Up Queries | 1 | January 14th, 2005 01:32 AM |
Bitwise And | Sam Hobbs | Running & Setting Up Queries | 44 | October 14th, 2004 04:19 AM |
Action queries changing when reopened in design view | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 12:34 AM |
Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |