Google Apps Script Gistfile1.js

gistfile1.js

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [ {name: "Get Stock", functionName: "getStock"}];
  ss.addMenu("Finance", menuEntries);
}

function getStock() {
  var sheet = SpreadsheetApp.getActiveSheet();

  sheet.getRange(1, 1).setValue("Symbol");
  sheet.getRange(1, 2).setValue("Name");
  sheet.getRange(1, 3).setValue("Exchange");
  sheet.getRange(1, 4).setValue("TradeTime");
  sheet.getRange(1, 5).setValue("Price");
  
  var row = 2;
  while (true) {
      var symbol = sheet.getRange(row, 1).getValue();
      if (!symbol) break;
      Logger.log("Updating symbol: " + symbol);
      var stockInfo = FinanceApp.getStockInfo(symbol);
      sheet.getRange(row, 2).setValue(stockInfo.name);
      sheet.getRange(row, 3).setValue(stockInfo.exchange);
      sheet.getRange(row, 4).setValue(stockInfo.tradetime);
      sheet.getRange(row, 5).setValue(stockInfo.price);
    row++;    
  }
}