Why does Google Finance display the wrong price for IOC (Indian Oil Corporation) in Google Sheets?
-
price
shows real-time of a particular stock. To get closing price useclose
. - 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: