Live stock quotes in JSON or XML format at no cost

Posted October 11, 2011 at 1:06 am by Akshay

I feel like I have finally found the holy grail of true free access to near-realtime structured stock quotes of almost any symbol across the world. Fellow programmers in search of this for a while must be aware that Yahoo! Finance lets you download near-realtime quotes for many exchanges across the globe in CSV format. However, few are aware of YQL (Yahoo Query Language) – yet another beautiful service from Yahoo! that lets you convert CSV data to JSON or XML on the fly!

You fuse these two services and what you get is a pure free API which lets you access near-realtime stock quotes! You may use this YQL console as a starting point …and here’s how the output looks like in JSON …and here’s how it looks like in XML:

Hope this helps developers like me who may not have enterprise level access to expensive data, but have the will to create cool apps given this access.

2 Comments

  1. Thanks for sharing!

    Per chance, do you know where to download some free historical tick-by-tick or 1 minute intraday data? I guess I could build a script to poll Yahoo’s realtime data every minute or so and build my own historical data after a while but it would be nice to just get a CSV somewhere.

    I need some historical data to backtest a daytrading script as you might have guessed.

  2. Let me try this, I have been looking for a solution like this.

    This eliminates my problem of having to wait for stock data. Real time stock data? Now, you are talking!

Leave a Comment