1

I tried using this formula for cells to enter the opening and closing price for mentioned stocks in google sheets.

=INDEX(GOOGLEFINANCE(B2, "open", A2), 2, 2)

Column B has stock symbols mentioned.

but it is always showing

Error When evaluating GOOGLEFINANCE, the query for the symbol: 'RELIANCE.NS' returned no data.

or shows

#N/A

Tried these other different formulas but didn't worked.

=IMPORTXML("https://www.investing.com/equities/reliance-industries-historical-data", "//table[@id='curr_table']/tbody/tr[1]/td[2]")

=INDEX(IMPORTXML("https://www.moneycontrol.com/financials/relianceindustriesindianagrasp/opening-priceRI", "//div[@class='value_txtfl fl gL_10 uc']/span[1]"),1)
Mayukh Bhattacharya
  • 12,541
  • 5
  • 21
  • 32
ni9khil
  • 1
  • 5

2 Answers2

1

Can you try with the ticker name NSE:RELIANCE

enter image description here

rockinfreakshow
  • 15,077
  • 3
  • 12
  • 19
1

It seems that the error is related to the query: RELIANCE.NS

Comparing the sample usage from Google documentation, I've tested using NSE:RELIANCE and it worked.

=GOOGLEFINANCE("NSE:RELIANCE", "all", TODAY()-(3), TODAY(), "DAILY")

Reference:

Samuel Lopez
  • 116
  • 5