Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(Excel) ETrade - Place Equity Order (JSON version)Shows how to place an equity order using ETrade with OAuth1 authorization. See https://developer.etrade.com/ctnt/dev-portal/getDetail?contentUri=V0_Documentation-OrderAPI-PlaceEquityOrder for more information.
' This example assumes the Chilkat HTTP 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 3-Legged 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") ' Build the JSON request body Dim json As Chilkat.JsonObject Set json = Chilkat.NewJsonObject success = json.UpdateString("PlaceEquityOrder.-xmlns","http://order.etws.etrade.com") ' The accountId should be an 8-digit number such as "83405188" success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.accountId","MY_ETRADE_ACCOUNT_ID") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.clientOrderId","45") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.limitPrice","3") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.quantity","4") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.symbol","ETFC") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.orderAction","BUY") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.priceType","LIMIT") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.marketSession","REGULAR") success = json.UpdateString("PlaceEquityOrder.EquityOrderRequest.orderTerm","GOOD_FOR_DAY") json.EmitCompact = False Debug.Print json.Emit() ' The above code builds the following JSON: ' { ' "PlaceEquityOrder": { ' "-xmlns": "http://order.etws.etrade.com", ' "EquityOrderRequest": { ' "accountId": "83405188", ' "clientOrderId": "45", ' "limitPrice": "3", ' "quantity": "4", ' "symbol": "ETFC", ' "orderAction": "BUY", ' "priceType": "LIMIT", ' "marketSession": "REGULAR", ' "orderTerm": "GOOD_FOR_DAY" ' } ' } ' } ' POST the JSON and get the response. json.EmitCompact = True ' Set the Accept property to get a JSON response. http.Accept = "application/json" ' This example uses the sandbox URL. The live URL is "https://etws.etrade.com/order/rest/placeequityorder" Set resp = http.PostJson2("https://etwssandbox.etrade.com/order/sandbox/rest/placeequityorder","application/json",json.Emit()) If (http.LastMethodSuccess <> True) Then Debug.Print http.LastErrorText Exit Sub End If ' Examine the response status code. statusCode = resp.StatusCode Debug.Print "Status Code = "; statusCode ' Load the JSON response body: success = json.Load(resp.BodyStr) json.EmitCompact = False ' If the status code was not 200, then it was an error.. If (statusCode <> 200) Then Debug.Print json.Emit() Debug.Print "Equity order failed." Exit Sub End If Debug.Print json.Emit() ' To examine some information from the JSON: Debug.Print "quantity: "; json.IntOf("PlaceEquityOrderResponse.EquityOrderResponse.quantity") Debug.Print "msgDesc: "; json.StringOf("PlaceEquityOrderResponse.EquityOrderResponse.messageList.msgDesc") ' etc .. ' This is a sample response: ' { ' "PlaceEquityOrderResponse": { ' "EquityOrderResponse": { ' "accountId": 83310056, ' "allOrNone": false, ' "estimatedCommission": 9.99, ' "estimatedTotalAmount": 1909.99, ' "messageList": { ' "msgDesc": "Your order was successfully entered during market hours.", ' "msgCode": 1026 ' }, ' "orderNum": 277, ' "orderTime": 1240982042179, ' "quantity": 100, ' "reserveOrder": false, ' "reserveQuantity": 0, ' "orderTerm": "GOOD_UNTIL_CANCEL", ' "limitPrice": 18, ' "stopPrice": 0, ' "symbolDesc": "CISCO SYS INC COM", ' "symbol": "CSCO", ' "orderAction": "BUY", ' "priceType": "LIMIT" ' } ' } ' } ' |
© 2000-2022 Chilkat Software, Inc. All Rights Reserved.