My function for Google App Script to grab tickers

updateclosing.js

function updateClosingPrice() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var positions = spreadsheet.getRangeByName('positions')
  var values = positions.getValues();
  var numRows = positions.getNumRows();
  
  // Collect all of the symbols
  var symbols = [];
  for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[1] != 'Stock') continue;
    var stockSymbol = row[2];
    symbols.push('"'+stockSymbol+'"');
  }
  
  // Fetch the data
  var params = [
    'format=json',
    'q='+encodeURIComponent('select symbol,Change,LastTradePriceOnly from yahoo.finance.quotes where symbol in ('+symbols.join(',')+')'),
    'env='+encodeURIComponent('store://datatables.org/alltableswithkeys'),
  ]
  var url = "http://query.yahooapis.com/v1/public/yql?"+params.join('&');
  var response = JSON.parse(UrlFetchApp.fetch(url).getContentText()).query.results.quote;
  
  // Turn it into a map
  symbols = {};
  for (var i = 0; i < response.length; i++) {
    var data = response[i];
    data.Change = data.Change.replace('+','');
    symbols[data.symbol] = data;
  }
  
  // Update the spreadsheet
  for (var i = 0; i <= numRows - 1; i++) {
    var row = values[i];
    if (row[1] != 'Stock') continue;
    
    var stockSymbol = row[2];
    var stockInfo = symbols[stockSymbol];
    
    Logger.log('Updating price of ('+stockSymbol+') from ' + row[7] + ' to '+stockInfo.LastTradePriceOnly);
    spreadsheet.getRange('positions').getCell(i+1, 8).setValue(stockInfo.LastTradePriceOnly);
    Logger.log('Updating change of ('+stockSymbol+') from ' + row[9] + ' to '+stockInfo.Change);
    spreadsheet.getRange('positions').getCell(i+1, 10).setValue(stockInfo.Change);
  }
}

if github only let me leave inline gist comments, I could nitpick about missing a ; on L3 :) nice work.