daverich204

function yahooF(ticker) {
  const url = `https://query1.finance.yahoo.com/v8/finance/chart/${ticker}`;
  
  const res = UrlFetchApp.fetch(url, {muteHttpExceptions: true});  
  const contentText = res.getContentText();
  const data = JSON.parse(contentText);
 
  // Check if the result exists and has data
  if (data && data.chart && data.chart.result && data.chart.result.length > 0) {
    const regularMarketPrice = data.chart.result[0].meta.regularMarketPrice;