Any good Finance API?

api google-api yql stockquotes
Otar picture Otar · Sep 8, 2010 · Viewed 11.1k times · Source

Yahoo! Finance feeds are pain in the ass.

Google Finance API seems OK but don't know why I can't retrieve stock quotes information for Dow Johnes, NASDAQ, S&P...

Works perfect with company quotes like YHOO, MSFT but don't gets full data for stock indexes.

There is an article at YQL blog on how to get this data from Open tables with YQL, but that table is missing in the list.

Can anybody recommend any good API, web service or a feed?

Best answer + vote up guaranteed.

Answer

Paul picture Paul · Sep 9, 2010

Yahoo provides a free API via http. You can get real-time informations & historical data in csv format.

For example to get the S&P historical data (^GSPC):
http://ichart.finance.yahoo.com/table.csv?s=^GSPC&ignore=.csv

or Dow Jones (^DJI):
http://ichart.finance.yahoo.com/table.csv?s=^DJI&ignore=.csv

URL syntax explained at:
http://www.gummy-stuff.org/Yahoo-data.htm

Related questions

Alternative to google finance api

I wanted to use Google Finance API to get stock data about the company but this API is deprecated since 2011/26/05. What do you use as free API to get stock data in real time?

Read More
How to use Google Translate API in my Java application?

If I pass a string (either in English or Arabic) as an input to the Google Translate API, it should translate it into the corresponding other language and give the translated string to me. I read the same case in …

Read More
Do Google refresh tokens expire?

I have used the refresh token several times in just a short period for testing purposes, but I wonder whether Google refresh tokens ever expire? Can I use the same refresh token to get another access token again and again …

Read More