PC Review


Reply
Thread Tools Rate Thread

Basic question about web queries

 
 
=?Utf-8?B?RGF2aWQ1NQ==?=
Guest
Posts: n/a
 
      6th Dec 2005
I'm trying to figure out how to create a web query that can have
substitutable parameters in it, where the parameters come from cells that are
referenced by the query.

For example:
suppose the following web query:
http://www.quoteserver.com?symbol=MS...5&format=close
returns the closing price for Microsoft on December 5th.

In my spreadsheet, Column A has a list of tickers, column B has a list of
dates, and I want the query to fill in column C with the closing price for
each ticker and date combination.

I don't want to have to write each web query separately since the list of
tickers I track changes; I want to have one query that can reference the
tickers and dates in columns A and B, and then look up the closing price.

Is this possible? Can anyone tell me how to do this or point me to an
example spreadsheet I can study?

Thanks in advance.
- David
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Basic performance and good design question abt forms/subforms queries Veli Izzet Microsoft Access 3 29th Aug 2005 07:49 AM
basic queries about overclocking Jon D DIY PC 11 25th Jul 2005 03:50 PM
basic queries about overclocking Jon D Computer Hardware 11 25th Jul 2005 03:50 PM
Basic Question About Queries Tab =?Utf-8?B?VGhlIHBhcmF3b24=?= Microsoft Access Queries 2 24th Feb 2005 10:23 AM
basic queries on moviemaker inquirer Windows XP MovieMaker 3 10th Aug 2004 11:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:22 AM.