通过GOOGLEFINANCE检索CVE-WT的价格

Question

TSX上CVE的价格可以由=GOOGLEFINANCE("TSE:CVE", "price")在Google Sheets中检索。如何使用GOOGLEFINANCE获得CVE-WT的价格？

Answer 1

我在谷歌金融上找不到它。你可以通过雅虎检索：

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[code].regularMarketPrice.raw
return regularMarketPrice
}
function test() {Logger.log(marketPrice('CVE-WT'))}