(Excel) ETrade Cancel Order

The cancel order API is used to cancel an existing order.

For more information, see https://apisb.etrade.com/docs/api/order/api-order-v1.html#/definition/cancelOrder

Download Excel Class Modules Chilkat Excel Class Modules

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

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

http.OAuth1 = True
http.OAuthVerifier = ""
http.OAuthConsumerKey = "ETRADE_CONSUMER_KEY"
http.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET"

' Load the access token previously obtained via the OAuth1 Authorization
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/etrade.json")
If (success <> True) Then
    Debug.Print "Failed to load OAuth1 token"
    Exit Sub
End If

http.OAuthToken = jsonToken.StringOf("oauth_token")
http.OAuthTokenSecret = jsonToken.StringOf("oauth_token_secret")


sandboxUrl = "https://apisb.etrade.com/v1/accounts/{$accountIdKey}/orders/cancel"

liveUrl = "https://api.etrade.com/v1/accounts/{$accountIdKey}/orders/cancel"

success = http.SetUrlVar("accountIdKey","6_Dpy0rmuQ9cu9IbTfvF2A")

' Send a PUT with the following XML body

' Use this online tool to generate the code from sample XML: 
' Generate Code to Create XML

' <CancelOrderRequest>
'    <orderId>11</orderId>
' </CancelOrderRequest>

Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
xml.Tag = "CancelOrderRequest"
xml.UpdateChildContent "orderId","11"
xml.EmitCompact = True


Set resp = http.PText("PUT",sandboxUrl,xml.GetXml(),"utf-8","application/xml",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Make sure a successful response was received.
If (resp.StatusCode > 200) Then
    Debug.Print resp.StatusLine
    Debug.Print resp.Header
    Debug.Print resp.BodyStr
    Exit Sub
End If

' Sample XML response:

' Use this online tool to generate parsing code from sample XML: 
' Generate Parsing Code from XML

' <CancelOrderResponse>
'    <accountId>63438617</accountId>
'    <orderId>11</orderId>
'    <cancelTime>1529563499081</cancelTime>
'    <Messages>
'       <Message>
'          <code>5011</code>
'          <description>200|Your request to cancel your order is being processed.</description>
'          <type>WARNING</type>
'       </Message>
'    </Messages>
' </CancelOrderResponse>

success = xml.LoadXml(resp.BodyStr)
Debug.Print xml.GetXml()

accountId = xml.GetChildIntValue("accountId")
orderId = xml.GetChildIntValue("orderId")
cancelTime = xml.GetChildContent("cancelTime")
code = xml.GetChildIntValue("Messages|Message|code")
description = xml.GetChildContent("Messages|Message|description")
v_type = xml.GetChildContent("Messages|Message|type")

Debug.Print "Success."