Many traders/investors how do not have access to trading terminal during market hours due to office blockage or network issues can use google docs to see live prices of stocks and nifty.
How To use the Google Finance
- Enter the formula into the desired spreadsheet cell: =GoogleFinance(“Symbol”, “Attribute”) where “symbol” represents the stock symbol of the company or mutual fund you’re looking for and “attribute” represents the type of market data that you want information about. If attribute is left blank, the stock price is populated into the cell by default.
For example, if I wanted to find out the 52-week price high for Procter & Gamble stock, I’d enter =GoogleFinance(“PG”, “high52”). Make sure to put quotation marks around both the symbol and the attribute in order for the formula to compute properly.
Here are a few more examples of attributes you can access using the GoogleFinance function:
- price: market price of the stock.
- priceopen: the opening price of the stock for the current day.
- high: the highest price the stock traded for the current day.
- low: the lowest price the stock traded for the current day.
- volume: number of shares traded of this stock for the current day.
- marketcap: the market cap of the stock.
- tradetime: the last time the stock traded.
- datadelay: the delay in the data presented for this stock using the googleFinance() function.
- volumeavg: the average volume for this stock.
- pe: the Price-to-Earnings ratio for this stock.
- eps: the earnings-per-share for this stock.
- high52: the 52-week high for this stock.
- low52: the 52-week low for this stock.
- change: the change in the price of this stock since yesterday’s market close.
- beta: the beta value of this stock.
- changepct: the percentage change in the price of this stock since yesterday’s close.
- closeyest: yesterday’s closing price of this stock.
- shares: the number of shares outstanding of this stock.
- currency: the currency in which this stock is traded.
- With the help of these information you can track almost all stocks on real time.
How to fetch mutual funds data in Google Sheets ?
how to track 15 minutes current price high and low for a stock by using Google finance in google sheets
It is observed that googlefinance() does not take into account the price variations due to issue of bonus shares
For example,Wipro issued 1:1 bonus shares with ex date as 14 June, 2017
An extract from NSE website on price movement is quoted here
Symbol Series Date Prev Open High Low Last Close
Close Price Price Price Price Price
WIPRO EQ 09-Jun-17 545.9 544.05 544.05 531.6 537 536.95
WIPRO EQ 12-Jun-17 536.95 535.6 535.6 520.65 524.4 526.35
WIPRO EQ 13-Jun-17 526.35 260 266.7 256.75 258.85 259
WIPRO EQ 14-Jun-17 259 261.3 261.3 252.3 256.9 256.1
WIPRO EQ 15-Jun-17 256.1 260 261.9 255.05 260.1 260.85
The same values returned by googlefinance() is quoted below
=googlefinance(“nse:wipro”,”close”,date(2017,6,9),date(2017,6,15),”daily”)
Date Close
09/06/2017 15:30:00 268.5
12/06/2017 15:30:00 262.2
13/06/2017 15:30:00 258.85
14/06/2017 15:30:00 256.9
15/06/2017 15:30:00 260.1
I would like to have your opinion on this.
thats correct..
Hi Bramesh,
Is it possible to get intraday stock prices by using Google finance with a given time period.
For example if I want to get stock prices of maruti for past date lets say 20th April and track its movement during that day at a interval of 15 mins.
Looking forward to hear from you.
Intraday i do not think we can get..
MarketXLS works for me just fine for this. It’s great.
Mr. BRamesh,
How to get real time data of NIFTY Future price for current month contract in NSE Indian market?
Because, the following link gives cash / spot price only
https://www.google.com/finance?q=NSE:.NSEI
Instead of cash/spot price, I would like have FUTURE CONTRACT price
Can you please help me?
Thanks in advance
Kiran
Nope
real only always win
Hi,
Is it possible to get NIFTY future rates for specific month via formula string in Google sheet?
Similar to below.
=googleFinance(“BHEL”, “price”)
Nitin
No idea on google docs but can be done in excel
Did you ever try this on Google spreadsheet for NSE. It does not work for symbols/stock codes like NSE:TCS or NSE:BANKINDIA which you have written above. It works if you put the number for BSE codes like 500325 which is a BSE code for Reliance Industries limited. Whatever BSE codes i entered worked without the BSE written in front i.e. BOM:500325 won’t work whereas 500325 works. Also the nse codes for which there are no US code i.e. if you just use reliance it works whereas if you use NSE:RELIANCE it does not work.
If you have used Google Finance Realtime Charts, then the function GOOGLEFINANCE follows the same ‘stock code’. The ‘stock code’ is entered as follows:
1) For Nifty – https://www.google.com/finance?q=NSE:.NSEI
2) For NSE stock e.g. Bank of India – https://www.google.com/finance?q=NSE:BANKINDIA
3) For Sensex – https://www.google.com/finance?q=INDEXBOM:.BSESN
4) For BSE stock e.g. HDFC – https://www.google.com/finance?q=BOM:500010
If you enter the ‘stock code’ after …?q= above in your googlefinance function, the price will show in your Google Docs sheet. e.g.
1)=googlefinance(“NSE:.NSEI”,…)
2)=googlefinance(“NSE:BANKINDIA”,…)
3)=googlefinance(“INDEXBOM:.BSESN”,…)
4)=googlefinance(“BOM:500010”,…)
please note that the codes don’t have to be entered in capital letters but they read better that way. The ‘realtime’ quotes in Docs are like 20 minutes behind as per their notes. Hope that helps.
I am using it on an excel, its not working. After i enter the details, I am getting this remark. #Name?. Can any body help, if its working for you all. kindly advise.
you have to use in google docs not excel
Can you find realtime option pricing of NSE with this.
can you post a dummy excel for this? thanks in advance