How to Access Stock Quotes Realtime through Google Finance

Google Finance is a product of Google, that tracks everything related to the Stock market and manage your Portfolio etc. It has access to realtime data of various stock exchanges around the world like NASDAQ, NSE of India etc. We can use this to get realtime data of stocks for programatically accessing the value of a stock.

Tell me already, Where are the quotes? The above URL gives us the latest quote for Google Shares. The Google Finance URL structure is pretty simple. The Query string q= requires the symbol of the stock you are interested in. It is of the format Exchange:Symbol. Some examples of these query strings are
  • Microsoft : NASDAQ:MSFT
  • Apple : NASDAQ:AAPL
  • Yahoo : NASDAQ:YHOO
  • Reliance (NSE of India) : NSE:RELIANCE
  • Pearson (London Stock Exchange) : LON:PSE
The response for the above URL is as follows // [ { "id": "694653" ,"t" : "GOOG" ,"e" : "NASDAQ" ,"l" : "581.84" ,"l_cur" : "581.84" ,"s": "0" ,"ltt":"4:00PM EDT" ,"lt" : "Mar 30, 4:00PM EDT" ,"c" : "+0.11" ,"cp" : "0.02" ,"ccol" : "chg" } ] Getting the Quotes from the above response is much simpler than scrapping a page. UPDATE:,NASDAQ:YHOO

You can get multiple quotes in a single request by comma separating the symbols on q parameter.

Will come back soon with a script that does something based on this realtime data from Google Finance.


The Code in Python

import urllib2 import json import time class GoogleFinanceAPI: def __init__(self): self.prefix = "" def get(self,symbol,exchange): url = self.prefix+"%s:%s"%(exchange,symbol) u = urllib2.urlopen(url) content = obj = json.loads(content[3:]) return obj[0] if __name__ == "__main__": c = GoogleFinanceAPI() while 1: quote = c.get("MSFT","NASDAQ") print quote time.sleep(30)

The above code prints the Quote for Microsoft stock on NASDAQ every 30 seconds.

Meanwhile all ye mates try something interesting with the stock quotes
(Than making profits and losses :) )

Dont forget to ping me on your updates. Post a comment.
Thank you Google.

31 Mar, 2011
Comments (15)
  • Watch out!

    This service is going down in October, 2012.

    By Good Samaritan on 23 Apr, 2012
    • This is not exactly API,

      This is not exactly a documented API, but something the Google finance website uses. So I suppose we should be safe.

      By digitalpbk on 24 Apr, 2012
  • HI Arun

    How can i fetch the GOLD price from google finance.
    when i go for
    "" it will give me price of company name with GOLD.

    I want price of Gold metal.
    please help.
    Thanks in advance.

    By Ankur on 05 Apr, 2012
  • Sir,
    A lot of thanks for this post.It is really useful.I have a doubt.How can we get days open,high,low,and last price and volume in between trading hours?
    may you help me
    With thanks
    Gilari Decosta

    By gilari decosta on 05 Mar, 2012
  • Dear arun, how to redirect that data to mysql... in a realtime basis..

    By kannan on 13 Feb, 2012
  • This is awesome, it is exactly what I have been looking for. But I want to modify it to show stock options quotes, not just the primary equity quote. (I know C, and a bit of Ruby, so I should be able to modify the code.) But I need to know what the URL looks like to get an options quote, do you know that? Please share! Thanks!

    By Anonymous Coward on 27 Dec, 2011
  • Gold ounce price

    How can i get the current gold ounce price like ?

    By Anonymous on 11 Sep, 2011
    • look up an equivalent Gold ETF

      Look for the price of an equivalent Gold ETF fund price on google for your country.
      By digitalpbk on 12 Sep, 2011
  • PHP Version

    Here's how to collect stock prices using PHP : <?php //Obtain Quote Info - This collects the Microsoft Stock Info $quote = file_get_contents(''); //Remove CR's from ouput - make it one line $json = str_replace("\n", "", $quote); //Remove //, [ and ] to build qualified string $data = substr($json, 4, strlen($json) -5); //decode JSON data $json_output = json_decode($data, true); //Un-remark print_r to see all array keys //print_r($json_output); //Output Stock price array key. echo "\n".$json_output['l']; ?>
    By WH101 on 24 Aug, 2011
  • PHP

    Can this script be run in PHP using the Python in PHP (PiP)?


    By TRH on 09 Aug, 2011
    • Can easily port the code

      You can easily port the code to PHP, not sure why you want to run python inside php.
      By digitalpbk on 10 Aug, 2011
  • Is there some way to get

    Is there some way to get Volume also?

    By Piyush Daga on 13 Jul, 2011
    • Were you able to get the Vol as well ?


      By Chen on 16 Feb, 2012
  • Programming Language

    Thanks. Your URL to Google is exactly what I've been looking for. What language is "The Code" written in?

    By Anonymous on 20 Jun, 2011
    • Python

      Ooops totally missed out that I guess. The code for getting realtime stocks from google was written using Python.
      By digitalpbk on 20 Jun, 2011
You may also like
On Facebook
Email Newsletter