With the risk of having this query rejected immediately - I've been using Google Sheets to scrape website information (but I think my question is ambigious to Excel and Sheets) - last prices of stocks - for a few years but have suddenly run in to issues.
I'm scraping using
Here's an example of a webpage I'm scraping from
Novo Nordisk B A/S (NOVO B) aktie
Where the latest price is listed under "Senast" in the top left corner
The xpath i'm getting from Chrome's inspector tool is
//*[@id='main-content']/div/div[1]/div/div/div[1]/div[2]/div/div[1]/div[1]/div/span
However, this returns a matrix/array:
Where I'm only interested in getting "696,4"
So, to my question:
What is the syntax to retrieve only 696,4?
Thank you!
I'm scraping using
Excel Formula:
=importxml("URL", "XPATH")
Here's an example of a webpage I'm scraping from
Novo Nordisk B A/S (NOVO B) aktie
Where the latest price is listed under "Senast" in the top left corner
The xpath i'm getting from Chrome's inspector tool is
//*[@id='main-content']/div/div[1]/div/div/div[1]/div[2]/div/div[1]/div[1]/div/span
However, this returns a matrix/array:
17:20:00 | · Nasdaq Copenhagen | |
696,4 |
So, to my question:
What is the syntax to retrieve only 696,4?
Thank you!