title: Excel VBA API call returning specific data only
body: <p>I would like to return data to Excel from a website (CoinMarketCap.com) similar to the example below:</p>
  
  <p><a href="https://stackoverflow.com/questions/48852376/vba-api-call-displayed-in-excel">VBA - API call displayed in Excel</a></p>
  
  <p>...except I need to limit the amount of returned data to only specific currencies (not the entire Ticker).</p>
  
  <p>The website requires an API Key (which I have) for these types of calls, but I don't understand how to format the url.
  The website provides this info:</p>
  
  <p><strong>Using Your API Key
  You may use any server side programming language that can make HTTP requests to target the Professional API. All requests should target domain <a href="https://pro-api.coinmarketcap.com" rel="nofollow noreferrer">https://pro-api.coinmarketcap.com</a>.</strong></p>
  
  <p><strong>You can supply your API Key in REST API calls in one of two ways:</strong></p>
  
  <p><strong>Preferred method: Via a custom header named X-CMC_PRO_API_KEY</strong></p>
  
  <p><strong>Convenience method: Via a query string parameter named CMC_PRO_API_KEY</strong></p>
  
  <p>But I can't make heads or tails from that. 
  Ultimately I would like to have the url return (for instance) 3 currencies, such as BTC, ADA, DASH along with the API Key (which for example purposes is "abc-xyz". </p>
  
  <p>Once I have the structure of the url I can work from there (in VBA), but I'm at a total loss as to how to format the url so that it will return only that specific data.</p>