View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerome Jerome is offline
external usenet poster
 
Posts: 20
Default 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!