Yahoo Historical Data - Did they change the URL recently?

Discussion in 'Educational Resources' started by Rationalize, May 16, 2017.

  1. ET180

    ET180

    Well...for it to be free means that someone has to do the work for nuttin.

    There are two pieces of data returned in the yahoo CSV data. One is adjusted and one is un-adjusted. I was using the un-adjusted as the adjusted seems to include dividend yield or something else in addition to correction for the splits. I agree with you that it's less than ideal, but I augment it with the IB data (use as much IB data as possible, but fill in more history with yahoo data). I don't have a problem with pacing for historical EOD quotes. But to pull the interesting part of a few option chains can take longer than 30 seconds. Threading helps a little, but seems that there's a hard limit on how much data can be returned over a period of time. Not a big issue for me. I just let it run over night. I'm more interested in the historical implied vol, but I like to overlay a few option deltas on my charts.
     
    #61     May 20, 2017
  2. I'm not sure but recall reading somewhere that it was related to counting odd lots: some say that the IB data does not contain the volume of odd lots.
     
    #62     May 20, 2017
  3. Bob111

    Bob111

    Thanks!

    question to IB experts. if I understand things correctly, after one collect daily data from IB, updating them by the end of the day shouldn't be a problem (talking about 15 seconds time restrictions between requests), if I request real time data for each stock RTH only. It should return all the data for the day? And I can request 100 tickets per shot? Im wrong?

    Thank you!
     
    #63     May 20, 2017
  4. What do you mean by "15 seconds time restrictions between requests"?
    If you are requesting live market data you can do so for 100 tickers in parallel, at the same time (unless your account size is large, or paid for a larger quantity of tickers, then you can do more). If you are asking for historical data you can request 60 items per 10 minute period, is what their documentation states. However, lately some people reported that they were able to download more than that limitation.
     
    #64     May 20, 2017
  5. d08

    d08

    Keep in mind that when you append to the previous data, it won't be adjusted for splits.

    Yahoo data isn't adjusted for dividends any longer. The unadjusted close is completely useless now, it's actually multiplied by the wrong multiplier, *2 instead of *0.5 for a 2:1 split. Amateur hour over at Yahoo. On top of that, many splits are missing as I've recently discovered.
     
    #65     May 20, 2017
    gkishot likes this.

  6. @d08 Are you saying that if you request historical data on a stock with contract.m_exchange = "SMART" and contract.m_primaryExch = 'primary exchange' that it will give you:

    1) open = primary exchange opening auction
    2) high = consolidated high
    3) low = consolidated low
    4) close = primary exchange closing auction

    That's great if so, but my understanding was that the only way to get the primary open/close was set both contract.m_exchange and contract.m_primaryExch = 'primary exchange'.
     
    #66     May 20, 2017
  7. d08

    d08

    The opening price appears to be the first print after 9:30, not the auction price necessarily (except for NASDAQ where it typically is). Yet now it seems the closing auction is included in the daily bar, I don't remember it being so before. Best to just verify by looking at the data and comparing to time and sales.
     
    #67     May 20, 2017
  8. Man - that was one of the nice things about it. I also have TOS/IB and Google as an alternative but neither are dividend adjusted either. Are there any providers out there that are?
     
    #68     May 20, 2017
  9. d08

    d08

    I don't think so. It's not that hard to adjust for the data yourself but there's obviously some programming involved.
     
    #69     May 20, 2017
    bellman likes this.
  10. ET180

    ET180

    Yes, I am able to download more than the limitation although I'm only requesting a couple days usually since I run the same request every night and keep a history. Historical bars update quick, but pulling options chains really slows things down. My pulls are threaded, but the threading does not seem to improve performance, I still only get one symbol at a time. Maybe there's a bottleneck. Need to look into this more, but haven't found the need yet.
     
    #70     May 20, 2017