LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling stock quotes from Yahoo Finance into a spreadsheet [email protected] Excel Discussion (Misc queries) 1 November 8th 06 10:09 AM
Yahoo historical quotes quit working with web query Roy Excel Discussion (Misc queries) 0 July 22nd 06 10:30 PM
access query to import to excel jazzydwit Excel Worksheet Functions 0 July 17th 06 02:03 AM
How to import Yahoo historical data directly into spreadsheet? [email protected] Excel Discussion (Misc queries) 0 March 24th 06 08:05 AM
Web queries & Yahoo! Finance cwhaley Excel Discussion (Misc queries) 1 February 2nd 06 12:31 AM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"