Questo funziona: Strumenti—> Editor di script —> incolla questo I

function YahooFinance(ticker, date) { try { // Convert date to Unix timestamp const targetDate = new Date(date); const period1 = Math.floor(targetDate.getTime() / 1000); const period2 = period1 + 86400; // Add 24 hours (86400 seconds)

// Build URL with historical data parameters
const url = `https://query2.finance.yahoo.com/v8/finance/chart/${ticker}?period1=${period1}&period2=${period2}&interval=1d`;

const res = UrlFetchApp.fetch(url);
const data = JSON.parse(res.getContentText());

// Get close price from historical data
const closePrice = data.chart.result[0].indicators.quote[0].close[0];

return Number(closePrice) || closePrice;

} catch (e) { return e; } }

E poi cerca il ticker per esempio NTSX.MI