You want to get the "percentage change" element from a website using
IMPORTXML. You are using XPath of
//span[@dir='ltr'] but getting a number of values, including the individual element required.
When extracting the XPath, you need to drill down further into the HTML to identify the specific line for the element that you require. Use the "Developer Tools" provided by your browser (Chrome, Firefox and Edge each have the same set of tools), select the specific line, right click, Copy, Copy XPath.
- XPath for "percentage change":