title: Google Sheet: IMPORTXML from Yahoo Finance
body: <p>I'm trying to import current stock price from yahoo finance. I used a formula from some website and it partially work. I only know how to tell it to look for a specific query and it worked fine for some other data point I need but the price change query changes from</p>
  <pre><code>&quot;Fw(500) Pstart(10px) Fz(24px) C($dataRed)&quot; 
  </code></pre>
  <p>to</p>
  <pre><code>&quot;Fw(500) Pstart(10px) Fz(24px) C($dataGreen)&quot; 
  </code></pre>
  <p>depending if the price is up or down for the day.</p>
  <p>How do I modify the formula I'm using below to use the &quot;or&quot; operator in this case? so that it will pull the price down whether the stock is up or down for the day. Thanks!</p>
  <p>Formula I'm using:
  <code>=IMPORTXML(&quot;https://finance.yahoo.com/quote/IBM&quot;,&quot;//span[@class='Fw(500) Pstart(10px) Fz(24px) C($dataRed)']&quot;)</code></p>