Why does Google Finance display the wrong price for IOC (Indian Oil Corporation) in Google Sheets?

  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