英文:
How can I get NSE stocks only opening and closing price in Google sheet from Google finance?
问题
=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 work.
=IMPORTXML("https://www.investing.com/equities/reliance-industries-historical-data", "//table[@id='curr_table']/tbody/tr1/td2")
=INDEX(IMPORTXML("https://www.moneycontrol.com/financials/relianceindustriesindianagrasp/opening-priceRI", "//div[@class='value_txtfl fl gL_10 uc']/span1"),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)
答案1
得分: 1
你可以尝试使用股票代码NSE:RELIANCE
答案2
得分: 1
似乎错误与查询有关：RELIANCE.NS
与Google文档中的示例用法进行比较，我已经测试了使用NSE:RELIANCE，它有效。
=GOOGLEFINANCE("NSE:RELIANCE", "all", 今天()-(3), 今天(), "DAILY")
参考链接：
英文:
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:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论