Excel web query does not import table (from yahoo finance) correct
 

Hi,

My excel web query doesn't seem to be working correctly.

I've been trying to use web query to import the historical price of a stock,
e.g, http://sg.finance.yahoo.com/q/hp?s=BN4.SI.

Using the web query, i check the table of historical prices and click on
import...however, excel doesn't import the table...it returns me the field
"First | Prev | Next | Last" which is at the bottom of the table instead.
I've tried this with other stocks and have even tried to import the whole
page, but the table just doesn't get imported.

I've used the same method to import the table on a friend's laptop and it
works without any problems. Are there some excel settings that are preventing
me from using web query?

Appreciate any advice. Thanks!

Excel web query does not import table (from yahoo finance) correct
 

After importing, edit your query and select the block in the far upper left
top corner for the whole table. Then import. Record a macro and then use
that for refresh or variables.

Send me your email address and I'll send you a free workbook of mine that
does this for you for whatever period you like and however many symbols
desired. Also graphs the history.

I will only respond to an OFF list request.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerome" wrote in message
...
Hi,

My excel web query doesn't seem to be working correctly.

I've been trying to use web query to import the historical price of a
stock,
e.g, http://sg.finance.yahoo.com/q/hp?s=BN4.SI.

Using the web query, i check the table of historical prices and click on
import...however, excel doesn't import the table...it returns me the field
"First | Prev | Next | Last" which is at the bottom of the table instead.
I've tried this with other stocks and have even tried to import the whole
page, but the table just doesn't get imported.

I've used the same method to import the table on a friend's laptop and it
works without any problems. Are there some excel settings that are
preventing
me from using web query?

Appreciate any advice. Thanks!