2

I am using Google Sheets for fetching EOD prices of Indian stocks, using the function

=GOOGLEFINANCE("IOC","price")

Google is returning 19.51 but the closing price for IOC on 11-11-2019 is INR 135.40.

Joe
  • 41,484
  • 20
  • 104
  • 125
Pawan Kumar Pandey
  • 29
  • 1
  • 2

3 Answers3

3
  1. price shows real-time of a particular stock. To get closing price use close.
  2. Use complete ticker symbol from Google Finance. "NSE:IOC" for Indian Oil.

For example:

=GOOGLEFINANCE("NSE:IOC","close",DATE(2019,11,11))

For more information you can visit the documentation.

See this image as a working example: enter image description here

Rishabh Agarwal
  • 1,988
  • 1
  • 16
  • 33
0

I found a workaround:

=ROUND(IF(MIN(GOOGLEFINANCE(A1,"marketcap")/GOOGLEFINANCE(A1,"shares"),GOOGLEFINANCE(A1,"price"))=0,GOOGLEFINANCE(A1,"marketcap")/GOOGLEFINANCE(A1,"shares"),MIN(GOOGLEFINANCE(A1,"marketcap")/GOOGLEFINANCE(A1,"shares"),GOOGLEFINANCE(A1,"price"))),3)

Haven't fully tested it yet but works so far.

pkamb
  • 33,281
  • 23
  • 160
  • 191
Gordon Pearson
  • 9
  • 2
0

First of All Google Finance function is not designed to be used for only Indian Markets hence this problem is occuring. When you search for the live prices of IOC (Indian Oil Corporation as is yours case) its showing the prices of a scrip named IOC (Itochu Corp a Japanese Company listed on Frankfurt Stock exchange)Price of IOC as FRA stock

So to Get the Price of Indian Oil Corporation you have to use the script name as NSE:IOC instead of just IOC

Goutam Hebbar
  • 1
  • 3