Yahoo Historical Data - Did they change the URL recently?

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

  1. d08

    d08

    They did change their cookie methods once again, I believe for the 3rd time in the last months. It still works but it's more complex as cookies are banned after X amount of requests.
     
    #151     Aug 19, 2017
  2. inCom

    inCom

    #152     Aug 19, 2017
  3. mokwit

    mokwit

    Hi Mokwit,



    There you go:

    Link one return csv format and require crumb and cookie:

    https_query1.finance.yahoo.com_v7_finance_download_ stockSymbol ?period1=
    unixStartDate &period2= unixEndDate &interval= urlInterval &events urlEvents &crumb= crumb

    Link two return json format and not require crumb nor cookie:

    https_query2.finance.yahoo.com_v8_finance_chart_IBM
    ?formatted=true&lang=en-US&region=US
    &period1=***Phone Number Removed - Learn more***&period2=***Phone Number Removed - Learn more***&interval=1d&events=div%7Csplit&corsDomain=
    finance.yahoo.com


    Note: I git the URL's by pasting the Yahoo censored links into Google and seemed to end up on the stack overflow page the censored links were referencing

    This one is the Link one return csv format and require crumb and cookie:
    https://stackoverflow.com/questions/44034229/yahoo-finance-api-stopped-working

    This one Link two return json format and not require crumb nor cookie:
    https://stackoverflow.com/questions/44030983/yahoo-finance-url-not-working/44050039#44050039
     
    #153     Aug 19, 2017
  4. Ambler

    Ambler

    If you still need to download historical stock price data from Yahoo into Excel, you can still do it. I have written a program to emulate the old ichart URL. There is VBA code and sample spreadsheets at signalsolver.com, follow the menu item to EmulateURL. You can get daily, weekly, monthly, dividend and split data. Its all free, no strings.

    Moderator please note--I am promoting my site by giving away something genuinely useful to readers of this thread. Apologies if it is an abuse of the terms of use. Just thought I could help.
     
    #154     Sep 14, 2017