Web Query takes up 2 cells

[brinded]

I've got a very simple web query running via an external text file.
The query has been assigned to run in one particular cell, say C33, but
the operation seems to have grabbed the cell below it as well, C44. The
trouble is I'm trying to run another Web Query from C44 but its entry
is blocked. For the time being I'm just leaving blank rows in between
queries but I'd like to tidy this up to get more data on a page.
Any suggestions?

Thanks, David

The typical query runs:

WEB
1
http://finance.yahoo.com/d/quotes.csv?s=SIT.L&f=sl1

 

[Jim Gordon MVP]

Hi,

When a web query is returned the result is a table.

Excel automatically recognizes where tables exist on worksheets. The
definition of a table is that the range of cells that comprise a table
is surrounded on each border by at least one empty row and empty column.

Only one query can exist within each table, although you can have lots
of tables on a given worksheet.

Hence, you must have at least one empty row between the queries because
in order for Excel to know where one table ends and the next begins
there has to be an empty row.

-Jim

 

[brinded]

Thanks - that makes sense.

So perhaps instead of having multiple queries I should create a single
query that contains all the quotes I need and stacks them into a
column.

In which case, I'm embarrassed to ask, how do I do that? Or perhaps it
would be easier to point me to a rough guide for using the language
(html?) and I'll be able to figure it out.

I've played with the line:
http://finance.yahoo.com/d/quotes.csv?s=SIT.L&f=sl1
but I don't really understand the construction, particularly the end
sequence after the stock ticker. Is there an example of a similar line
with several tickers together? If I had that I could extend it I think.

Again, thanks for your patience and help. David

 

[Jim Gordon MVP]

Hi,

I've put some links to information about web queries on my web site:
http://www.agentjim.com/MVP/Excel/ExcelHome.htm

If you want to make a single table from a bunch of queries then you
could make a macro that copies the data and pastes it somewhere else.
The trigger could be whenever you refresh the data.

-Jim Gordon
Mac MVP

 

[brinded]

Thanks Jim,

I've got the following working for anyone else interested:

http://finance.yahoo.com/d/quotes.csv?s=ORCL&s=CSCO&s=COHR&f=sl1

It works quite well - puts the data in a single column - just what I
needed.

regards, dg

 

[Jim Gordon MVP]

Thank you for providing that example.

Please feel invited to post regularly.

-Jim

 

[Mark Staples]

Jim:
I'm sorry to be a pest, as I have seen this issue posted many times and try
as I might, I can't get the result I'm looking for. Back in May, 2005 you
responded to someone named Vijay on this point:

I'm converting from PC to MAC and finding the only missing functionality is
the capability that the MSN addin for excel provides. When I use the Web
query in Excel 2004 I get an entire table of data from the website. All I
want is to closing price for a stock whose ticker symbol is in a cell on my
spreadsheet. Just that value, nothing else.

I don't know enough about web queries to get this right, although I think
the solutions resides in the 'selection' function of the web query. Try as
I might, I can't get this resolved.

Can you help? I'd be grateful.
Mark