1
votes

Following is my query using YQL, data is fetched using Yahoo finance, I am using the symbols for the stocks traded on the Indian NSE, BSE

http://query.yahooapis.com/v1/public/yql?q=select  * from yahoo.finance.quotes where 
symbol in ("AIAENG.NS","ATULAUTO.NS")&env=http://datatables.org/alltables.env&format=json

Strange thing is this query always return null data (Invalid data) for all the fields, even when the symbol that I am using is correct and can be used on the Yahoo finance for querying the details. In fact same is for another Indian exchange BSE, with respective symbols AIAENG.BO, ATULAUTO.BO

However if I replace the with US Nasdaq symbols like "YHOO","AAPL","GOOG","MSFT", it works without an issue.

3

3 Answers

5
votes

If yahoo finance is not your compulsion, then you can use this project.

http://nsetools.readthedocs.org/en/latest/

This is well documented and uses NSE as a data source which is most reliable.

5
votes

If someone's still looking out, and not satisfied with nsetools (because lack of historical data), here is the latest link I found to be working:

https://query1.finance.yahoo.com/v8/finance/chart/CDSL.NS

Replace CDSL with appropriate symbol.

0
votes

Late in the game but adding my response just in case if anybody looking for an easiest way to get the near real time quote(up to 10 tickers) by using Google Finance REST call.

http://finance.google.com/finance/info?q=NSE:AIAENG,NSE:ATULAUTO

And the acronym description can be found here http://qsb-mac-plugins.googlecode.com/svn-history/r4/trunk/stock-quoter/trunk/StockQuoter.py