How to: Obtain historical stock prices from Yahoo finance (you can query them via Excel too) Part II

You may also like...

13 Responses

  1. Murray says:

    Hello again Juan,
    Could you please provide your link to part III (referred above para I) for the historic data
    Thank you

  2. wpace46 says:

    Juan, have you posted Part III regarding the use of Goggle Finance?

  3. R says:

    Hi Juan,
    Can you post a link example for a single equity (say:AAPL) historical daily base, including adjusted prices for a year?

  4. cvan says:

    hmm does not seem to be working for India index and stock. I used ^NSEI and INFY.NS with l1 as (f). I am not getting any results.

  5. richard says:

    Thank you for the work you have done. I played with the Google site and didn’t see any options other than the date range. This issue I found with Google and this remaining Yahoo interface is won’t provide data on Mutual Funds. The Yahoo site that was shutdown did. Any thoughts on options if you want historical pricing on a Mutual Fund?

    • deios says:

      Yes, you can use they provide Mutual Funds historical data + adjusted closes for them. And actually, it’s easy to switch from Yahoo Finance to EOD. Because they have very similar API, and basically, you just need to change url from… to That’s easy!

      • richard says:

        With regards to on the yahoo blog there were individuals questioning the validity of this site. Questions were: site appeared right around yahoo interface termination; ownership of site; source of data. This site needs to clear up those questions before I would register with them.

        • Ann says:

          Eoddata has been around for several years. I used them for several years before I switched to to the Yahoo! Finance addin. I will be using them again.

          • imxuwang says:

            I am also checking EOD, but not sure how long their history is. EOD’s domain registered last year.

  6. Andrew MacLean says:

    For historic data I have created a VBA/Excel workaround, a function call which takes the old ichart URL, converts it into something that works then fetches the data. Go to and follow the menu to EmulateURL. Its free.

  7. Tom Evers says:

    there is probably a way to specify the historical range, but you can get a year of historical data like so…

  8. Trish McConnell says:

    This worked at the beginning of November 2017 when I used it in Excel. On November 20 when I came back to my spreadsheet, I get a log in error to the web service of “restricted access”. It looks like Yahoo has restricted the service. I’m hoping they open it back up

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: