How can I get stock quotes using Google Finance API

Question

I m looking for access to financial data from Google services    I found this URL that gets the stock data for Microsoft   What are all the possible parameters that Google allows for this kind of HTTP request  I d like to see all the different information that I could get

User · Answer

I found this site helpful   http   benjisimon blogspot com 2009 01 truly-simple-stock-api html  It links to an API yahoo seems to offer that is very simple and useful   For instance   http   finance yahoo com d quotes csv s GOOG AAPL amp f snl1  Full details here   http   www gummy-stuff org Yahoo-data htm

User · Answer

The simplest way as you have explained is this link this is for   Dow Jones Industrial Average   Link 2 is for  NASDAQ-100   and for all related to NASDAQ link 3   I think this should be it  else you want same in JSON notations the same as Microsoft  Please refer this old post I think this will help   Update   To know the details of volume and other details  I have created a vbscript that is using IE object to fetch details from the link  and alerts the content in the particular id Create a  vbs file and run it    Set IE   CreateObject  InternetExplorer Application   while IE readyState   4  WScript Sleep 10  wend IE Navigate  https   www google com finance q INDEXNASDAQ 3ANDX amp sq NASDAQ amp sp 2 amp ei B3UoUsiIH5DIlgPEsQE  IE visible   true while IE readyState   4  WScript Sleep 10  wend dim ht ht  IE document getElementById  market-data-div   innerText msgBox ht IE quit   this will alert the values from page like this  3 124 54 0 00  0 00   Sep 4 - Close INDEXNASDAQ real-time data - Disclaimer Range       - 52 week 2 494 38 - 3 149 24 Open        - Vol     0 00   I am sure this will help

User · Answer

There s a whole API for managing portfolios   Link removed  Google no longer provides a developer API for this   Getting stock quotes is a little harder   I found one article where someone got stock quotes using Google Spreadsheets   You can also use the gadgets but I guess that s not what you re after   The API you mention is interesting but doesn t seem to be documented  as far as I ve been able to find anyway    Here is some information on historical prices  just for reference sake

User · Answer

The Google stock quote API has gone away  However  Investor s Exchange offers an API that s very easy to use for quote data

User · Answer

The Google Finance Gadget API has been officially deprecated since October 2012  but as of April 2014  it s still active    http   www google com finance info q NASDAQ GOOG http   www google com finance info q CURRENCY GBPUSD http   finance google com finance info client ig amp q AAPL YHOO   You can also get charts  https   www google com finance getchart q YELP  Note that if your application is for public consumption  using the Google Finance API is against Google s terms of service   Check google-finance-get-stock-quote-realtime for the complete code in python

User · Answer

This is no longer an active API for google  you can try Xignite  although they charge  http   www xignite com

User · Answer

Here is an example that you can use  Havent got Google Finance yet  but Here is the Yahoo Example  You will need the HTMLAgilityPack   Which is awesome  Happy Symbol Hunting   Call the procedure by using YahooStockRequest string Symbols    Where Symbols   a comma-delimited string of symbols  or just one symbol  public string YahooStockRequest string Symbols bool UseYahoo true                                          string StockQuoteUrl   string Empty                   try                                          Use Yahoo finance service to download stock data from Yahoo                     if  UseYahoo                                                string YahooSymbolString   Symbols Replace                                   StockQuoteUrl     http   finance yahoo com q s     YahooSymbolString     amp ql 1                                             else                                                 Going to Put Google Finance here when I Figure it out                                                Initialize a new WebRequest                      HttpWebRequest webreq    HttpWebRequest WebRequest Create StockQuoteUrl                          Get the response from the Internet resource                      HttpWebResponse webresp    HttpWebResponse webreq GetResponse                           Read the body of the response from the server                       HtmlAgilityPack HtmlDocument doc   new HtmlAgilityPack HtmlDocument                        string pageSource                      using  StreamReader sr   new StreamReader webresp GetResponseStream                                                   pageSource   sr ReadToEnd                                              doc LoadHtml pageSource ToString                         if  UseYahoo                                                string Results string Empty                            loop through each Symbol that you provided with a     delimiter                         foreach  string SplitSymbol in Symbols Split new char                                                                   Results  SplitSymbol           doc GetElementbyId  yfs l10     SplitSymbol  InnerText   Environment NewLine                                                    return  Results                                             else                                               return  doc GetElementbyId  ref 14135 l   InnerText                                                            catch  WebException Webex                                        return  SYSTEM ERROR DOWNLOADING SYMBOL      Webex ToString

User · Answer

Perhaps of interest  the Google Finance API documentaton includes a section detailing how to access different parameters via JavaScript   I suppose the JavaScript API might be a wrapper to the JSON request you mention above    perhaps you could check which HTTP requests are being sent

User · Answer

The problem with Yahoo and Google data is that it violates terms of service if you re using it for commercial use  When your site app is still small it s not biggie  but as soon as you grow a little you start getting cease and desists from the exchanges  A licensed solution example is FinancialContent  http   www financialcontent com json php or Xignite

User · Answer

In order to find chart data using the financial data API of Google  one must simply go to Google as if looking for a search term  type finance into the search engine  and a link to Google finance will appear  Once at the Google finance search engine  type the ticker name into the financial data API engine and the result will be displayed  However  it should be noted that all Google finance charts are delayed by 15 minutes  and at most can be used for a better understanding of the ticker s past history  rather than current price   A solution to the delayed chart information is to obtain a real-time financial data API  An example of one would be the barchartondemand interface that has real-time quote information  along with other detailed features that make it simpler to find the exact chart you re looking for  With fully customizable features  and specific programming tools for the precise trading information you need  barchartondemand s tools outdo Google finance by a wide margin

User · Answer

Building upon the shoulders of giants   here s a one-liner I wrote to zap all of Google s current stock data into local Bash shell variables   stock  1     Fetch from Google Finance API  put into local variables eval   curl -s  http   www google com ig api stock  stock  sed  s  lt   n lt  g   sed   data   d  s  data    g  s    gt     g  s  lt  GF  g   tee  tmp stockprice tmp log   echo   stock   date   Y- m- d   GF open  GF high  GF low  GF last  GF volume    Then you will have variables like  GF last  GF open  GF volume etc  readily available  Run env or see inside  tmp stockprice tmp log  http   www google com ig api stock TVIX amp output csv by itself returns    lt  xml version  1 0   gt   lt xml api reply version  1  gt   lt finance module id  0  tab id  0  mobile row  0  mobile zipped  1  row  0  section  0   gt   lt symbol data  TVIX   gt   lt pretty symbol data  TVIX   gt   lt symbol lookup url data   finance client ig amp amp q TVIX   gt   lt company data  VelocityShares Daily 2x VIX Short Term ETN   gt   lt exchange data  AMEX   gt   lt exchange timezone data  ET   gt   lt exchange utc offset data   05 00   gt   lt exchange closing data  960   gt   lt divisor data  2   gt   lt currency data  USD   gt   lt last data  57 45   gt   lt high data  59 70   gt   lt low data  56 85   gt   etc    So for stock  FBM   tmp stockprice tmp log   and your environment  will contain   GF symbol  FBM    GF pretty symbol  FBM    GF symbol lookup url   finance client ig amp amp q FBM    GF company  Focus Morningstar Basic Materials Index ETF    GF exchange  NYSEARCA    GF exchange timezone      GF exchange utc offset      GF exchange closing      GF divisor  2    GF currency  USD    GF last  22 82    GF high  22 82    GF low  22 82    GF volume  100    GF avg volume      GF market cap  4 56    GF open  22 82    GF y close  22 80    GF change   0 02    GF perc change  0 09    GF delay  0    GF trade timestamp  8 hours ago    GF trade date utc  20120228    GF trade time utc  184541    GF current date utc  20120229    GF current time utc  033534    GF symbol url   finance client ig amp amp q FBM    GF chart url   finance chart q NYSEARCA FBM amp amp tlf 12    GF disclaimer url   help stock disclaimer html    GF ecn url      GF isld last      GF isld trade date utc      GF isld trade time utc      GF brut last      GF brut trade date utc      GF brut trade time utc      GF daylight savings  false

User · Answer

Edit  the api call has been removed by google  so it is no longer functioning   Agree with Pareshkumar s answer  Now there is a python wrapper googlefinance for the url call    Install googlefinance   pip install googlefinance   It is easy to get current stock price    gt  gt  gt  from googlefinance import getQuotes  gt  gt  gt  import json  gt  gt  gt  print json dumps getQuotes  AAPL    indent 2             Index    NASDAQ         LastTradeWithCurrency    129 09         LastTradeDateTime    2015-03-02T16 04 29Z         LastTradePrice    129 09         Yield    1 46         LastTradeTime    4 04PM EST         LastTradeDateTimeLong    Mar 2  4 04PM EST         Dividend    0 47         StockSymbol    AAPL         ID    22144          Google finance is a source that provides real-time stock data  There are also other APIs from yahoo  such as yahoo-finance  but they are delayed by 15min for NYSE and NASDAQ stocks

User · Answer

Try with this  http   finance google com finance info client ig amp q NASDAQ GOOGL  It will return you all available details about the mentioned stock   e g  out put would look like below           id    694653    t     GOOGL    e     NASDAQ    l     528 08    l fix     528 08    l cur     528 08    s    0    ltt   4 00PM EST    lt     Dec 5  4 00PM EST    lt dts     2014-12-05T16 00 14Z    c     -14 50    c fix     -14 50    cp     -2 67    cp fix     -2 67    ccol     chr    pcls fix     542 58        You can have your company stock symbol at the end of this URL to get its details   http   finance google com finance info client ig amp q  lt YOUR COMPANY STOCK SYMBOL gt

[java] How can I get stock quotes using Google Finance API?

Examples related to java

Examples related to php

Examples related to javascript

Examples related to google-api

Examples related to google-finance