(Excel) Bitfinex v2 REST Submit Order

Submit an order.

For more information, see https://docs.bitfinex.com/reference#rest-auth-submit-order

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2


apiPath = "v2/auth/w/order/submit"

apiKey = "MY_API_KEY"

apiSecret = "MY_API_SECRET"

Dim dt As Chilkat.CkDateTime
Set dt = Chilkat.NewCkDateTime
Dim success As Boolean
success = dt.SetFromCurrentSystemTime()

Dim sbNonce As Chilkat.StringBuilder
Set sbNonce = Chilkat.NewStringBuilder
success = sbNonce.Append(dt.GetAsUnixTimeStr(False))
success = sbNonce.Append("000")

nonce = sbNonce.GetAsString()

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("type","LIMIT")
success = json.UpdateString("symbol","tBTCUSD")
success = json.UpdateString("price","15")
success = json.UpdateString("amount","0.001")
success = json.UpdateInt("flags",0)

body = json.Emit()

Dim sbSignature As Chilkat.StringBuilder
Set sbSignature = Chilkat.NewStringBuilder
success = sbSignature.Append("/api/")
success = sbSignature.Append(apiPath)
success = sbSignature.Append(nonce)
success = sbSignature.Append(body)

crypt.EncodingMode = "hex_lower"
crypt.HashAlgorithm = "sha384"
crypt.MacAlgorithm = "hmac"
success = crypt.SetMacKeyString(apiSecret)


sig = crypt.MacStringENC(sbSignature.GetAsString())

http.SetRequestHeader "bfx-apikey",apiKey
http.SetRequestHeader "bfx-signature",sig
http.SetRequestHeader "bfx-nonce",nonce


Set resp = http.PostJson2("https://api.bitfinex.com/v2/auth/w/order/submit","application/json",body)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response body:"
Debug.Print resp.BodyStr