ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Basic question about web queries (https://www.excelbanter.com/excel-programming/347414-basic-question-about-web-queries.html)

David55

Basic question about web queries
 
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...form at=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


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com