【GAS】(無料)スプレッドシートで仮想通貨の自動売買｜bitFlyer

1gcUUTZ9pMYAHHK0_3wxVlcMBm9KwZO5G_zd25fkJWhweZKlSjN3mXwwr

function getTicker(){
  let BF = bitFlyer.factory()
    let sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("ticker")
    let lastRow=sh.getLastRow()
    
    let res= BF.getticker()
    let keys = Object.keys(res)
    let data
    if(lastRow==0){
      data=[keys]
    }else{
      data=[]
    }
    let temp=[]
    for (let key of keys){
      temp.push(res[key])
    }
    data.push(temp)

    sh.getRange(sh.getLastRow()+1,1,data.length,data[0].length).setValues(data)
    SpreadsheetApp.flush()
}

const APP_KEY="bitFlyerのAPI key"
const APP_SECRET="bitFlyerのAPI secret"

function main(){
  let sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("main")
  let auto  = sh.getRange("C13").getValue()

  getTicker()

  if(auto===true){
    autoTrade()
  }
}

// 自動売買
function autoTrade(){
  let sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("main")
  let log_sh=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("log")
  
  let lastPrice    = sh.getRange("C3").getValue()  // 最終取引価格 
  let bb_flg       = sh.getRange("C4").getValue()  // ボリンジャーバンド取引フラグ
  let rsi_flg      = sh.getRange("C5").getValue()  // RSI取引フラグ
  let bb_req       = sh.getRange("C17").getValue() // ボリンジャーバンド条件使用フラグ
  let rsi_req      = sh.getRange("C18").getValue() // RSI条件使用フラグ
  let simulate_flg = sh.getRange("C22").getValue() // シミュレートモード
  let next_mode    = sh.getRange("C14").getValue() // 購入or売却
  let amount       = sh.getRange("C12").getValue() // 取引量

  let res 

    if(bb_req && rsi_req){
      if(bb_flg===next_mode && rsi_flg===next_mode){
        if(simulate_flg===false){
          res = sendchildorder(amount,next_mode)
        }else{
          res="simulate"
        }
      }
    }else if(bb_req && bb_flg===next_mode){
      if(simulate_flg===false){
        res = sendchildorder(amount,next_mode)
      }else{
        res="simulate"
      }
    }else if(rsi_req && rsi_flg===next_mode){
      if(simulate_flg===false){
        res = sendchildorder(amount,next_mode)
      }else{
        res={message:"simulate"}
      }
    }
  
  if(res !==undefined){
    console.log(res)
    sh.getRange("B27").setValue(res)
    if(res !=="" && res["error_message"] ===undefined){
      let day = new Date()
      let data = 
      log_sh.getRange(log_sh.getLastRow()+1,1,1,4).setValues([[day,amount,lastPrice,next_mode]])
      if(next_mode==="BUY"){
        sh.getRange("C14").setValue("SELL")
      }else {
        sh.getRange("C14").setValue("BUY") 
      }
    }
  }



}

//取引リクエスト
function sendchildorder(amount,mode){
  BF = new bitFlyer.factory(APP_KEY,APP_SECRET)
  let params = {
            "product_code": "BTC_JPY",
            "child_order_type": "MARKET",
            "side": mode,
            "size": amount,
            "minute_to_expire": 10000,
            "time_in_force": "GTC"
        }
   return BF.sendchildorder(params)

}