Live stock quotes in JSON or XML format at no cost
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.
Hi, My name is Akshay Raje. I am a self taught freelance web designer and developer. I love travel and am a great movie buff too. This blog is about my projects and experiments with web technologies.
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.
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!