Retrieve stock "change in percentage" in google spreadsheet with ImportXML()
I would like to retrieve stock data on Google Spreadsheet through the ImportXML() function.
Suppose I want to retrieve stock data of SHA:000001
To retrieve price, the formula to use is;
=ImportXML("https://www.google.com/finance?q=SHA:000001", "//span[@class='pr']")
What is the formula to use for retrieving "price change in percentage" for the day?
Solution
This worked for me:
=ImportXML("https://www.google.com/finance?q=SHA:000001", "//div[@class='id-price-change nwp']/span/span[2]")
- How to utilize date add function in Google spreadsheet?
- Adding clause of and/or to if statement
- How do I use offset within a forEach loop in google apps script
- How to use date with LIKE inside query?
- Remove empty rows in Google Sheets
- Export a Google Sheet to PDF file with Python requests
- Formula to convert matrix to rows in Google Sheets
- Google scripts on execution below code giving error as "exceeded maximum time"
- Attaching Files from Google Drive to Email sent in Google Sheets
- How to GetSheetByName using partial string in google apps script
- How to unnest data from one column to fit the entire dataset - Google Sheets
- Google Sheet Function Not Working as Expected
- How to use Google Cloud ADC to access Google Drive API from Python with personal account (not service account)
- How do I center my pdf download using app script?
- appscript to move checked rows to another sheet when clicked custom menu item in google sheets
- What is the GoogleJsonResponseException error when trying to get Drive.comments.list()?
- How to get last value from VLookup?
- Hide rows in google spreadsheet if Column A is empty?
- 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 can I write a Google Sheets script that will clear some cells while setting others to zero?
- how to show instruction with image after install google workspace extension
- 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?