google-sheetsstockgoogle-finance

How can I get NSE stocks only opening and closing price in Google sheet from Google finance?


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)

Solution

  • Can you try with the ticker name NSE:RELIANCE

    enter image description here