Is there an API that I can use to get historical and recent EOD stock quotes?

Question

Hey I just need the link for the API that Google/Yahoo have (I know they have it but I cant find the link) that I can use to get historical and recent End of day stock quotes. For example I want to be able to query the quote for MSFT on Jan 15,2009 and get the moving averages and 52 week highs, etc. Can anyone point them out to me? Thanks!!

Answer 1

http://www.gummy-stuff.org/Yahoo-data.htm

Answer 2

You can get historical prices from both Google and Yahoo by simply modifying the URL. I've written a couple of blog posts about it.

Google

• Posts the EOD data earlier than Yahoo (2-3 hours before Yahoo posts the data).
• Sample URL: http://www.google.com/finance/historical?q=NYSE:GOOG&output=csv
• Has a limit on how many requests you can make per minute (don't know the exact figure, but if you request data too often google will block you for a period of time).
• Good if you download the data manually and automatically (at low frequency).

Yahoo

• Posts the EOD data a little later (around 7:00 p.m. CST).
• Sample URL: http://ichart.finance.yahoo.com/table.csv?s=YHOO&d=3&e=23&f=2010&g=d&a=3&b=12&c=1996&ignore=.csv
• Has no limit on how many requests you can make at all!
• Good if you download the data both manually and automatically (no frequency limit).

As mentioned, the gummystuff web site is a great resource!

Answer 3

The Mergent Historical Securities Data API at http://www.mergent.com/servius should have exactly what you're looking for.