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
- ARRAYFORMULA option for checking for cell values on each row of Google Sheet
- Filter a range by array
- Google Sheet Table in one row
- Google Sheets Import CSV popup
- Calculating Average of last 10 Data Entries while Omitting Zeros
- Fastest way to search for a row in a large Google Sheet using/in Google Apps Script
- Google Apps Script showing previous day
- Automatically transfer data from the same cell in different sheet tabs to one table
- How to use the function .getLastRow() in google script
- Updating appscript dropdown in sidebar after a successful operation
- Getting Range not found when using getRange()
- How to generate an uuid in google sheet?
- Improve performance of onEdit simple trigger
- Query and Importrange function with conditions
- Google Apps Script attempting to utilize OAuthScopes is giving an error with no details and prevents saving
- Why can't I format my dates after they are returned from this function?
- Appscript Google sheets returns null
- RegExtract a value from a comma-separated string
- Conditional formatting if a cell is a duplicate value
- Google Sheets Image() function now requires users to hit Allow Access
- Can I use Google Apps Script instead of Formulas for doing calculations on a spreadsheet?
- Is it possible to display an iframe or webview in google sheets
- In the same Google Sheet Workbook, can you extract the info from a cell in Sheet A to a cell in Sheet B, and link it back to the same cell in Sheet A?
- GSPREAD bulk export of dataframes on separate sheets without triggering API write request limits
- How do I configure Apps Script time-based Triggers to execute successfully?
- Write the count files in folder to a spreadsheet
- Adding message to email when using addEditor()
- Regular expression for Unique Sort finding phone extensions from a multicolumn list
- Spreadsheet formulas calculation control
- Is there a way to keep two sheets synchronized?