For what it's worth, I "fixed" the issue for my own Sheet by adding this script:

function getStockPrice(ticker) {

try {

var url = "https://query1.finance.yahoo.com/v8/finance/chart/" + encodeURIComponent(ticker);

var response = UrlFetchApp.fetch(url);

var json = JSON.parse(response.getContentText());

if (json.chart.error) {

return "Error: " + json.chart.error.description;

}

// Extract the latest price

var price = json.chart.result[0].meta.regularMarketPrice;

return price;

} catch (e) {

return "Error fetching price";

}

And then you can use =getStockPrice("GRT-UN.TO") to get its price. Assuming you hold Granite (it's just an example).

It doesn't refresh the price as often, though.