How to get updated Stock market data with Google Finance function with in 15 second

Google finance functions are the formula which is just used like Google lookup formula for getting updated stock market data . For applying this formula , you need only 15 second and then you can get the result .

Google Finance function


=GoogleFinance("symbol"; "attribute")

Symbol → stock / shares symbol of company

stock / shares symbol is just company brand name for selling shares

for google = GOOG
ICICI bank = icicibank
PNB =pnb
SBI bank = sbi

attribute → is price and volume of shares and stock

This stock data is updated after every 20 minutes .

For calculating value of shares of google updated

Go to google docs spreadsheet and

=Googlefinance("GooG","price") and then enter
If you want to get updated shares value of other shares in U.S. Stock exchange . Then following formula will apply

=Googlefinance("sbi","price") and then enter

=Googlefinance("pnb","price") and then enter

=Googlefinance("icicibank","price") and then enter

If want to get updated market capital value then


Write volume on the place of price and other attributes and stock symbols will be remain same and then press enter by keyboards . For Stock market brokers this formula is more useful and this is so simple .