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
- How can I use Google Sheets Apps Script to Auto Generate today's date when an edit is made to a given column?
- IsDate ArrayFormula
- how to show instruction with image after install google workspace extension
- Formula to convert matrix to rows in Google Sheets
- Regular expression to extract valid cell references from a spreadsheet formula
- Is Google Sheets less or more accurate than Microsoft Excel?
- google sheet merge two column into one column with prefix words
- Get highest occurring row number of key?
- If checkbox checked set values
- Clarification on using the forEach() function
- Why is this ARRAYFORMULA + VLOOKUP() + REGEXEXTRACT() with multiple conditions not working?
- How can I make this formula more dynamic by including another criteria (cell F11) in the query?
- Add title row with ARRAYFORMULA in Google Sheets
- Rank based on which column is being sorted by in a Table
- Auto border to a Dynamic Data
- How can I determine if a respondent's email address is unique in a list?
- Combine IF for text with INDEX and MATCH? Or VLOOKUP? QUERY?
- Google Sheets - returning Nth result with multiple matching criteria
- Can a label in a Google Sheets Query be dynamic; can it reference a variable?
- Sum a number of range values; process and add to array
- Downloading a PDF version of the open spreadsheet in Google Drive via scripts
- exporting spreadsheet to pdf then saving the file in google drive
- How to get last number in a row on Google Spreadsheets
- A Script to Simplify Creating a SO Table
- Archive a row after a dropdown status is selected on multiple sheets
- How to extract URL from Link in Google Sheets using a formula?
- Create list of dates in Google Sheets based on day-of-month schedule
- Get Google Sheet by ID?
- Return Column Based on Column Headers
- Why does my Google Service Account not see files shared with it, but can see files created with it?