Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    I'm using the Importing External Data feature (or at least trying to) with this financial site:

    http://quote.morningstar.com/Option/Option...&ticker=ABT

    I've selected the Calls and Puts tables, but when I try to import, I get an error saying that web query has no data.

    What am I doing wrong?

    Kevin

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I get the same error message; it must be the way the web page is organized.

    Other than copying or pasting the table into Excel, or writing very complicated VBA code to read the web page I don't see a solution.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I looked at the html source of that page and it appears the "table" isn't posted as a HTMl table, but rather rendered by JavaScript on the client. The data is inside the file in this shape:

    var strOptions = "40.00,NNN,ABTJH,8.90,10.00,10.20,10.00,10.20,16,1 14.0000,114.0000,ooo,ABTVH
    ,0.02,0.05,0.05,0.05,0.05,5,1362.0000,1362.0000|41 .00,NNN,ABTJO,7.90,9.00,9.20,9.
    00,9.20,1,20.0000,20.0000,ooo,ABTVO,0.02,0.05,0.05 ,0.05,0.05,100,695.0000,695.000
    0|... (remaining rows omitted)"
    and the table is rendered when the javascript is executed, which Excel cannot do.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •