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.