title: importXML in Google Spreadsheets from YahooFinace
body: <p>I want to import the <em>Beta</em> of a stock, e.g. the <em>Facebook</em> stock, from Yahoo Finance into a cell within a Google Spreadsheets document.</p>
  
  <p>Here is the Facebook page in Yahoo Finance: <strong><code>http://finance.yahoo.com/q?s=FB</code></strong></p>
  
  <p>Here is the XPath of the <em>Beta</em> element within that page: <strong><code>//*[@id="table1"]/tbody/tr[6]/td</code></strong></p>
  
  <p>(which I obtained using <strong>Inspect element</strong> within Google Chrome, then right-clicking on the element's code and clicking on <em>Copy Xpath</em>)</p>
  
  <p>Thus in the Google Spreadsheet cell I am entering:</p>
  
  <pre><code>**=ImportXML("http://finance.yahoo.com/q?s=FB", "//*[@id="table1"]/tbody/tr[6]/td")**
  </code></pre>
  
  <p>However, I get: <strong>#ERROR</strong>, and when I hover over the cell I read: <strong>error: Parse error</strong></p>
  
  <p>My locale in Google Spreadsheets is set to US, just in case.</p>