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.
This link - made up by following the StackOverflow reference posted by mokwit - returns a CSV, although apparently limited to the last 16 years: http://www.google.com/finance/historical?q=MSFT&startdate=Jan+01+1990&enddate=Aug+18+2017&output=csv Didn't test it at all, I'm quite certain the usual problems remains.
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®ion=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
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.