title: IMPORTXML Formula in Google Sheets
body: <p>I'm having trouble pulling the financial data from 'Book Value Per Share' using Google Sheet's IMPORTXML function</p>
  <p>=ImportXML(&quot;https://stockanalysis.com/stocks/bby/statistics/&quot;, [Xpath])</p>
  <p>Xpath:
  //*[@id=&quot;main&quot;]/div[2]/div[2]/div[4]/table/tbody/tr[6]/td[1]/span</p>