Yahoo! Real-Time Quotes Problem

Discussion in 'Data Sets and Feeds' started by tacosplz, Dec 1, 2013.

  1. tacosplz

    tacosplz

    Since 2001 I have been using a $10/month subscription to Yahoo!'s real-time quotes with Excel web queries to update prices on several thousand stocks while I trade. The queries use URLs such as http://finance.yahoo.com/d/quotes.c...IO+ABM+ABMD+ABR+ABT+ABTL+ABX&f=l1p2vt1&e=.csv . It has always been a bit tricky to get the web queries to access the real-time quotes and not free delayed quotes. For example, for the last several years I've had to follow this procedure:

    1. Open IE (which I don't use for any other purpose) and go to yahoo.com.
    2. Log out of Yahoo! if I'm logged in.
    3. Close IE.
    4. Open IE, go to finance.yahoo.com and log-in.
    5. Get a quote on any stock and make sure it's real-time and not delayed. Do not navigate away from this quote before going to the next stp.
    6. Kill IE with the Windows task manager.

    As of the recent Yahoo! Finance makeover, neither the above procedure nor any variation of it that I can find is able to make Excel access my real-time quotes. I've tried all versions of IE since IE8 on both Windows XP and Windows 7. I'm wondering if anyone else uses Yahoo!'s real-time quotes in this manner and has been successful at Excel's web queries to access them.

    On the other hand, I'm wondering if there is a cheap alternative (I'd be willing to pay $100/month) to Yahoo! for real-time quotes. Of course the quotes I'd get in Excel were never "real-time", since it would take about a minute for a few dozen queries (each getting data on the maximum 200 ticker symbols allowed), but 1-minute delay was tolerable for my purposes. Getting quotes on several thousand stocks all at once with a delay of just a few seconds would be ideal.

    I'd consider using iMacros scrape the real-time quotes directly from Yahoo's pages, but that would slow the process down quite a bit.