function copyValue(int a,b) {
  var ss = SpreadsheetApp.openById('1HTEuyd7po43VKM37nmzCvPgLEVESgcN5YpAu2VRTiFI');
  var sheet =  ss.getSheetByName("Total");
  var cell = sheet.getRange(a,b);
  var c = cell.getValue();
  return(c);
}

Missing ) after formal parameters. (line 1)

That error is just because it is attempting to parse the return JSON from Poloniex incorrectly...


This code is assuming that the "parameter" and/or "subparam" that you pass into the poloniex() function is one of the keys that comes back in the JSON return string from Poloniex... however, the example output that the API docs give for a "buy" command is:

So the "keys" are "orderNumber" and "resultingTrades"... resultingTrades has subkeys of "amount","date","rate","total","tradeID" and "type".

What has likely happened is that your BUY order has probably been placed, but your script just failed to read the result from Poloniex... as it was trying to find a key called ["BTC_ZEC"] with subkey ["0.01"] which won't exist. Check your poloniex order history and see if it got placed.

To fix the error, you'd need to put in some code that returns something that SHOULD be returned by a successful API "buy" call... Also, you should probably put some error checking in that checks to see if the API response was an error code:
I'm not sure what data from the response you actually want to display, so I just picked the "orderNumber"...



Instead of using the "named" parameters (command,parameter,subparam) listed in the function definition... I just used arguments[0], arguments[1], arguments[2], arguments[3]... and check that the "command" is "buy", so therefore there should be 4 "arguments" (0,1,2 and 3) passed in to the function.

Can you please provide the value of variable payloadEncoded.

Also it will be helpful to put the following

before calling  UrlFetchApp.fetch(uri, params); and to provide the value of variable req

It's hard to see where the appropriate values are being set... ie. "currencyPair", "rate", and "amount". Have you tried debugging the value of payloadEncoded? As this would appear to be where the values for the "currencyPair", "rate" and "amount" values are being set (I assume from cells in the spreadsheet? ):


Can you dump the value of payloadEncoded to the console and make sure that your parameters are actually being included properly...

Also, your "poloniex" function only takes 3 parameters... but you're sending 4?

function poloniex(command,parameter,subparam)
vs
=poloniex("buy","BTC_ZEC",0.01,2)

Try the following (code changes in green):


Note that you now have to call buy, sell, differently.

eg. you should now be able to call buy like this:


The parameter names within the object {} correspond directly to the expected poloniex API POST parameters.

I haven't actually run it, but send me a PM if it works and you feel like tipping me.

with you being a newbie AND non-user of the product - you would say that ...

with me / us being a veteran in the crypto industry AND using the product - i can assure you that you are completely wrong ...

resellers can promote the bot - because they KNOW it works ... if you are stupid with ANY bot - then you will lose ... if you are careful and invest wisely ... you can win ...

ALL bots do what you ask them to do ... so be wise when you set your bot up - IF you ever get into it ...

i / we are NOT resellers of gunbot - so any figures that is displayed from our account - are real with no fake crap to promote the bot ... in fact - 5% is actually conservative if you look at a 30 day schedule ... nothing is guranteed - and NOTHING gets done unless YOU do it right ... so LEARN the product back to front - and USE the product wisely ...

if not - you will come back here and slag the bot for losses that YOU made the bot do - because you were not diligent enough to learn what you were doing ...

resellers will always promote their sales ... so what? ... if they LIE - thats different ... gunthar should drop them as soon as that happens - and never deal with them again ... but so far - the 1-5% figures are reasonably accurate for those that KNOW how to manipulate the bot in the right way ...

try it out - and THEN talk ... i did - and now two other colleagues want the bot also ...

#crysx

1) Your function call poloniex("buy","USDT_ZEC",100,0.01) includes 4 arguments, your function poloniex(command,parameter,subparam) only accepts 3.

2) Your function poloniex doesn't actually do anything with the arguments you receive. You're only sending the command parameter (and the nonce), no currency pair, rate or total. You need to add those to the payload object.

Request failed for https://poloniex.com/tradingApi returned code 422.
Truncated server response: {"error":"Total must be at least 0.0001."}

       // work in progress

        // you need a poloniex API key and secret with trading option enabled
        // you can test it with:
        // = poloniex ("returnBalances","BTC")
        // or
        // = poloniex ("returnBalances")


        function poloniex(command,parameter,subparam) {
      
          // I assume that all the keys are in the "keys" spreadsheet. The key         is in cell A1 and the secret in cell A2
      
          var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("keys");
  
          var key = sheet.getRange("A1").getValue();
    
          var secret = sheet.getRange("A2").getValue();

          var nonce = 1495932972127042 + new Date().getTime();
    
          var payload = {
            "nonce": nonce,
            "command": command
          }
  
          var payloadEncoded = Object.keys(payload).map(function(param) {
            return encodeURIComponent(param) + '=' +      encodeURIComponent(payload[param]);
          }).join('&');
    
          var uri = "https://poloniex.com/tradingApi";

          var signature =         Utilities.computeHmacSignature(Utilities.MacAlgorithm.HMAC_SHA_512, payloadEncoded, secret);
    
          var stringSignature = "";
  
          for (i = 0; i < signature.length; i++) {
            var byte = signature;
            if (byte < 0)
              byte += 256;
            var byteStr = byte.toString(16);
            if (byteStr.length == 1) byteStr = '0'+byteStr;
    stringSignature += byteStr;
           }
    
          var headers = {
            "key": key,
            "sign": stringSignature
          }
  
          var params = {
            "method": "post",
            "headers": headers,
            "payload": payloadEncoded
          }
  
          var response = UrlFetchApp.fetch(uri, params);
  
          var dataAll = JSON.parse(response.getContentText());
  
          if (parameter === undefined) {
    Logger.log(JSON.stringify(dataAll))
    return JSON.stringify(dataAll) }
          else if(parameter != undefined && subparam === undefined) {
            return dataAll[parameter] }
          else if (parameter != undefined && subparam != undefined) {
            return dataAll[parameter][subparam] }
        }