title: Importing stock price from Yahoo Finance in Google sheets
body: <p>I'm trying to import some Singapore stock prices from Yahoo finance in my Google sheets. I am using the code</p>
  <p><code>=IMPORTXML(&quot;https://finance.yahoo.com/quote/&quot; &amp; A2,&quot;//*[@id='quote-header-info']/div[3]/div[1]/div/span[1]&quot;)</code></p>
  <p>and put the ticker in A2. It works for some SGX stocks but not the others. Applying to STI constituents, I got something like</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Ticker</th>
  <th>Price</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>D05.SI</td>
  <td>28.4</td>
  </tr>
  <tr>
  <td>O39.SI</td>
  <td>11.61</td>
  </tr>
  <tr>
  <td>U11.SI</td>
  <td>#N/A</td>
  </tr>
  <tr>
  <td>Z74.SI</td>
  <td>2.41</td>
  </tr>
  <tr>
  <td>J36.SI</td>
  <td>#N/A</td>
  </tr>
  <tr>
  <td>A17U.SI</td>
  <td>3.05</td>
  </tr>
  <tr>
  <td>C38U.SI</td>
  <td>#N/A</td>
  </tr>
  <tr>
  <td>Y92.SI</td>
  <td>#N/A</td>
  </tr>
  <tr>
  <td>S68.SI</td>
  <td>#N/A</td>
  </tr>
  <tr>
  <td>C31.SI</td>
  <td>3.75</td>
  </tr>
  <tr>
  <td>...</td>
  <td>...</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have checked that for U11.SI and J36.SI, the XPATH of the price element is the same as for D05.SI. Below is the link to the Google sheet</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1Tp9leC43J1W3Jun3Z23K51zmbkZRhPOcM60ffBPOs90/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Tp9leC43J1W3Jun3Z23K51zmbkZRhPOcM60ffBPOs90/edit?usp=sharing</a></p>
  <p>Could anyone shed some light on what's going wrong here? Thanks!</p>