title: Call Google Finance API in Excel
body: <p>I want to fetch stock price via Google Finance API in Excel.</p>
  
  <p>Resource: <code>https://finance.google.com/finance/info</code></p>
  
  <p>Method: <code>GET</code></p>
  
  <p>Parameters: </p>
  
  <ul>
  <li>client = ig</li>
  <li>q = <code>&lt;exchange code&gt;:&lt;stock code&gt;</code></li>
  </ul>
  
  <p>example:</p>
  
  <p><code>https://finance.google.com/finance/info?client=ig&amp;q=TPE:2330</code></p>
  
  <p>this request will get the stock price of Taiwan Semiconductor.</p>
  
  <p>Is there a solution, no matter doing some setting of worksheet or writing some VBA code, to reach my goal? </p>