NEPSE: Get Real Time Stock Price on Google Sheets

getCompanyName.js

/**
 * Returns the company name of a NEPSE stock.
 *
 * @param {string} stockSymbol - The stock symbol to retrieve the company name for.
 * @return {string} The company name of the specified stock.
 * @customfunction
 */
function getCompanyName(stockSymbol) {
  if (!stockSymbol) return '#SYMBOL_MISSING';
  const response = UrlFetchApp.fetch("https://nepse-test.vercel.app/api?symbol=" + stockSymbol);
  const responseData = JSON.parse(response.getContentText());
  return responseData.company_name ?? '#ERR';
}

getLTP.js

/**
 * Returns the last traded price (LTP) of a NEPSE stock.
 *
 * @param {string} stockSymbol - The stock symbol to retrieve the LTP for.
 * @return {number} The LTP of the specified stock.
 * @customfunction
 */
function getLTP(stockSymbol) {
  if (!stockSymbol) return '#SYMBOL_MISSING';
  const response = UrlFetchApp.fetch("https://nepse-test.vercel.app/api?symbol=" + stockSymbol);
  const responseData = JSON.parse(response.getContentText());
  return parseFloat(responseData.ltp) ?? '#ERR';
}