customFunctions.gs

/**
 * Gets LTP from ICICI Direct.
 *
 * @param {string} symbol Symbol for this Last Traded Price is required
 * @return {string} ltp Current LTP from ICICI Direct
 * @customfunction
 */
function ILTP(symbol) {
  var url = 'https://secure.icicidirect.com/IDirectTrading/Trading/trading_stock_quote.aspx?Symbol=' + symbol
  console.log('URL :' + url);
  var response = UrlFetchApp.fetch(url);
  console.log(response.getAllHeaders());
  var html = response.getContentText();
  var ltpRegex = new RegExp(/(LAST TRADE PRICE)([\stdh<>\/]+)([\salign="]+[right|left|center]+[">\s]+)(NA|[0-9,]+.[0-9]+)[\stdh<>\/]+/gm)
  var ltp = ltpRegex.exec(html);
  console.log(ltp)
  return ltp[4];
}

function _debug_iltp() {
  console.log(ILTP('ICINEX'))
}