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

[Jerome]

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!

 

[Don Guillett]

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.

 

[thepcer]

May be a bit late, but this website has an Excel spreadsheet to download stock quotes from Yahoo: http://investexcel.net/218/importing-historical-stock-prices-from-yahoo-into-excel/