WTI price in Google Sheets

Question

Hi I'm trying to get the current WTI (West Texas Intermediate) price but GoogleFinance doesn't recognize it. Has anybody had luck with this?

Answer 1

Ok. Found a solution. Google Sheets has an add-on and you can add the Yahoo Finance and then run formula =YAHOOFINANCE("ticker") and pick up commodities such as WTI (CL=F).

Answer 2

With Yahoo, you can also get the information by decoding the json cntained in the web page. In A1 for instance =marketPrice("CL=F") and the script :

function marketPrice(code) {
  var url='https://finance.yahoo.com/quote/'+code
  var source = UrlFetchApp.fetch(url).getContentText()
  var jsonString = source.match(/(?<=root.App.main = ).*(?=}}}})/g) + '}}}}'
  var data = JSON.parse(jsonString)
  var regularMarketPrice = data.context.dispatcher.stores.StreamDataStore.quoteData.item(code).regularMarketPrice.raw
  return regularMarketPrice
}
Object.prototype.item=function(i){return this[i]};

Answer 3

Try

=GOOGLEFINANCE("NYSE:WTI","price")