Googleシート：価格の取得 → テクニカル指標の自動計算 → データの保存

function _getCsv(URL) {
  var response = UrlFetchApp.fetch(URL)
     ,data = {
       contentString : response.getContentText().toString()   
      ,responseCode : response.getResponseCode()
     };
  return data;
}

function _CSVToArray( strData, strDelimiter ){
  strDelimiter = (strDelimiter || ",");
  var objPattern = new RegExp(
    (
      "(\\" + strDelimiter + "|\\r?\\n|\\r|^)" +
      "(?:\"([^\"]*(?:\"\"[^\"]*)*)\"|" +
      "([^\"\\" + strDelimiter + "\\r\\n]*))"
    ),
    "gi"
  );
  var arrData = [[]];
  var arrMatches = null;
  while (arrMatches = objPattern.exec( strData )){
    var strMatchedDelimiter = arrMatches[ 1 ];
    if (
      strMatchedDelimiter.length &&
      (strMatchedDelimiter != strDelimiter)
      ){
        arrData.push( [] );
      }
    if (arrMatches[ 2 ]){
      var strMatchedValue = arrMatches[ 2 ].replace(
        new RegExp( "\"\"", "g" ),
        "\""
      );

    } else {
      var strMatchedValue = arrMatches[ 3 ];
    }
    arrData[ arrData.length - 1 ].push( strMatchedValue );
  }
  return( arrData );
}

// moment.jsのコードをコピペ

function GET_AND_CALC_TFX(){

  var GV = {
    address     : ""
    ,mail_title : "スクリプトを稼働しました"

    ,SS  : SpreadsheetApp.getActiveSpreadsheet()
    ,ROW : 2

    ,SYM_TFX       : ["USD/JPY","EUR/JPY","GBP/JPY"]
    ,SYM_TFX_NUM   : [1        ,2        ,3        ]
    ,SYM_TFX_round : [4        ,4        ,4        ]

    ,ITEM_TFX     : ["Date","Source","Symbol","Open","High","Low","Close","SettlementPrice","SwapPoint","TradingVolume","OpenInterest"]
    ,ITEM_TFX_NUM : [1     ,""      ,3       ,6     ,8     ,10   ,12     ,14               ,16         ,17             ,18            ]

    ,ITEM_TECH    : ["TR","ATR14","ATR20","EMA5","EMA20","EMA-Signal"]

    ,ABC : ["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM"]
  };
  GV["YEST"]  = moment().subtract(1 ,"days").format("YYYYMMDD");
  GV["URL"]   = "http://www.tfx.co.jp/kawase/document/PRT-010-CSV-003-"+GV.YEST+".CSV";
  GV["SHEET"] = (function(sym_tfx){
    var result = new Array();
    for(var i=0 ,len=sym_tfx.length; i<len; i++){
      result.push(GV.SS.getSheetByName(sym_tfx[i]));
    }
    return result;
  })(GV.SYM_TFX);

  try{
    var
     items      = GV.ITEM_TFX.concat(GV.ITEM_TECH)
    ,arraySS    = new Array()
    ,arraySS_b4 = new Array()
    ,preDate
    ,getCsv     = _getCsv(GV.URL)
    ,csvData    = _CSVToArray(getCsv.contentString,",")
    ;

    for(var i=0 ,symLen=GV.SYM_TFX.length; i<symLen; i++){
      arraySS[i] = new Array();
      if(csvData[i].indexOf("�|�|�|")==-1){

        for(var j=0 ,itmLen=GV.ITEM_TFX.length; j<itmLen; j++){
          if(j==0){
            preDate       = csvData[GV.SYM_TFX_NUM[i]][GV.ITEM_TFX_NUM[j]]
            arraySS[i][0] = preDate.slice(0,4)+"/"+preDate.slice(4,6)+"/"+preDate.slice(6);
          }else if(j==1){
            arraySS[i][1] = "TFX";
          }else if(j==2){
            arraySS[i][2] = GV.SYM_TFX[i];
          }else{
            arraySS[i][j] = (csvData[GV.SYM_TFX_NUM[i]][GV.ITEM_TFX_NUM[j]] || "\'\'");
          }
        }

      }else{
        arraySS[i][0] = "休場"
      }

      var
       lastRow = GV.SHEET[i].getLastRow()
      ,lastCol = GV.SHEET[i].getLastColumn()
      ;
      arraySS_b4[i] = GV.SHEET[i].getRange(lastRow ,1 ,1 ,lastCol).getValues()[0];

      var isNewDate  = moment(arraySS[i][0] ,"YYYY/MM/DD").isAfter(moment(arraySS_b4[i][0]) ,"days");
      if(isNewDate && arraySS[i][0]!=="休場"){

        var
         abcHigh    = GV.ABC[items.indexOf("High")]  
        ,abcLow     = GV.ABC[items.indexOf("Low")]   
        ,abcClose   = GV.ABC[items.indexOf("Close")]
        ,abcTR      = GV.ABC[items.indexOf("TR")]    
        ,abcATR14   = GV.ABC[items.indexOf("ATR14")]
        ,abcATR20   = GV.ABC[items.indexOf("ATR20")]
        ,abcEMA5    = GV.ABC[items.indexOf("EMA5")]
        ,abcEMA20   = GV.ABC[items.indexOf("EMA20")]  
        ,abcEMA_Sig = GV.ABC[items.indexOf("EMA_Signal")]  
        ,row        = (lastRow+1)
        ,row_1      = lastRow
        ,round      = GV.SYM_TFX_round[i]
        ,formulas = [[
          '=round(max(abs('+abcHigh+row+'-'+abcLow+row+'),abs('+abcHigh+row+'-'+abcClose+row_1+'),abs('+abcLow+row+'-'+abcClose+row_1+')),'+round+')'
          ,'=round(('+abcATR14+row_1+'*13+'+abcTR+row+'*2)/15,'+round+')'    
          ,'=round(('+abcATR20+row_1+'*19+'+abcTR+row+'*2)/21,'+round+')'    
          ,'=round(('+abcEMA5+row_1+'*4+'+abcClose+row+'*2)/6,'+round+')'    
          ,'=round(('+abcEMA20+row_1+'*19+'+abcClose+row+'*2)/21,'+round+')'
          ,'=if('+abcEMA5+row+'='+abcEMA20+row+',0,if('+abcEMA5+row+'>'+abcEMA20+row+',1,-1))'
        ]]
        ;
        if(isNewDate){
          var arLen = arraySS[i].length;
          GV.SHEET[i].getRange(lastRow+1 ,1 ,1 ,arLen).setValues([arraySS[i]]);                  
          GV.SHEET[i].getRange(lastRow+1 ,arLen+1 ,1 ,formulas[0].length).setFormulas(formulas);

          GV.SHEET[i].getRange(lastRow ,1 ,1 ,arraySS_b4[i].length).setValues([arraySS_b4[i]]);  
          GV.SHEET[i].deleteRow(GV.ROW);
        }
        Logger.log(
          GV.SYM_TFX[i]+"の"+arraySS[i][0]+"のデータを追加しました。\n"
          +arraySS[i]+"\n"
          +formulas+"\n"
        );

      }else{
        Logger.log(GV.SYM_TFX[i]+"の新たなデータはありませんでした。")
      }
    }

  }catch(e){
    if(GV.address!==""){
      MailApp.sendEmail(
        GV.address
        ,("【エラー】"+GV.mail_title)
        ,e+"\n\n\n"+Logger.getLog()
      );
    }
    return;
  }

  if(GV.address!==""){
    MailApp.sendEmail(
      GV.address
      ,GV.mail_title
      ,Logger.getLog()
    );
  }
}