Impossible to import Yahoo! data within Excel

Discussion in 'Data Sets and Feeds' started by VirtualReal, Apr 30, 2009.

  1. VirtualReal

    VirtualReal

    Hello all,

    Using Excel's web query I import Yahoo! data on a daily basis. Since today it seems impossible, both manually as automatically(VBA), to fetch any data. Here's a sample query:

    Code:
    Web
1
[url]http://download.finance.yahoo.com/d/quotes.csv?s=AAP&f=a2b2b3b4c1dee7e8e9ghjj1j4j5j6kk4k5l1m3m4m5m6m7m8op2p6rr5r6r7s7t8vy[/url]
    Things I tried:

    -Checking the URL via a tracert-command. Works fine.
    -Entering the URL in my browser. Works fine, the .csv file will be downloaded.
    -Tried a standard web query included in the Excel installation ('MSN MoneyCentral Investor Stock Quotes.iqy'), works fine.
    -Reinstalled MS Excel (v2003), problem not solved.

    Has anyone the same problem. Can someone try to fire attached web query within Excel?

    Thanks for any help,

    Jim
     
    #1     Apr 30, 2009
    Share