前日比の自動計算

// 前日比を計算して記入
  if (lastRow > 1) {
    var prevNI225Price = sheet.getRange(lastRow, 2).getValue();
    var prevMovingAverage5Days = sheet.getRange(lastRow, 3).getValue();
    var prevMovingAverage25Days = sheet.getRange(lastRow, 4).getValue();
    var prevMovingAverage75Days = sheet.getRange(lastRow, 5).getValue();

    sheet.getRange(newRow, 6).setValue(NI225Price - prevNI225Price);
    sheet.getRange(newRow, 7).setValue(movingAverage5Days - prevMovingAverage5Days);
    sheet.getRange(newRow, 8).setValue(movingAverage25Days - prevMovingAverage25Days);
    sheet.getRange(newRow, 9).setValue(movingAverage75Days - prevMovingAverage75Days);
  }