title: Google Sheets - IMPORTXML from livecoinwatch.com (Which XPath?)
body: <p>I cannot seem to find the correct XPath to get the data from 1h and 24h price change @<a href="https://www.livecoinwatch.com" rel="nofollow noreferrer">https://www.livecoinwatch.com</a></p>
  
  <p>As far as I can see, the XPaths are;</p>
  
  <p>1h</p>
  
  <pre><code>//*[@id="btchpc"]
  </code></pre>
  
  <p>24h</p>
  
  <pre><code>//*[@id="btcdpc"]
  </code></pre>
  
  <p>But, using the syntax (1h);</p>
  
  <pre><code>=IMPORTXML("http://www.livecoinwatch.com/","//*[@id='btchpc']")
  </code></pre>
  
  <p>Returns an error; "Imported content is empty".</p>
  
  <p>Changing it to</p>
  
  <pre><code>=IMPORTXML("http://www.livecoinwatch.com/","//span[@id='btchpc']")
  </code></pre>
  
  <p>... doesn't work either.</p>
  
  <p>I have another IMPORTXML function which works pefectly. It's for 24h change as well, from coinpuffs.com;</p>
  
  <pre><code>=IMPORTXML("https://coinpuffs.com/coin/BTC","//span[@id='coin-pct-change-value']")
  </code></pre>
  
  <p>Sorry if the above sounds completely ridiculous - I've only just started using the IMPORTXML function and I'm not really good at HTML and XML structures.</p>
  
  <p>Thank you!</p>
  
  <p>EDIT#1;</p>
  
  <p>Further investigations are getting me closer to the target.
  Instead of working out of the front page, I got into the respective coin's page, e.g. BTC and found the XPaths to the 1h, 24h and also 7d and 30d(!);</p>
  
  <p>1h:</p>
  
  <pre><code>//*[@id="hpc"]
  </code></pre>
  
  <p>24h:</p>
  
  <pre><code> //*[@id="dpc"]
  </code></pre>
  
  <p>7d:</p>
  
  <pre><code>//*[@id="wpc"]
  </code></pre>
  
  <p>30d:</p>
  
  <pre><code>//*[@id="mpc"]
  </code></pre>
  
  <p>Now, using the new URL and XPaths, I actually get some results, put they are parsed quite funny;</p>
  
  <p>When I use the syntax (1h); in cell A1</p>
  
  <pre><code>=IMPORTXML("https://www.livecoinwatch.com/price/Bitcoin-BTC","//*[@id='hpc']")
  </code></pre>
  
  <p>The result gets parsed into cell A3 and B1. What's going on?</p>