|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(AutoIt) ETrade List OrdersGets the order details for a selected brokerage account based on the search criteria provided. For more information, see https://apisb.etrade.com/docs/api/order/api-order-v1.html#/definition/getOrders
; This requires the Chilkat API to have been previously unlocked. ; See Global Unlock Sample for sample code. $oHttp = ObjCreate("Chilkat.Http") $oHttp.OAuth1 = True $oHttp.OAuthVerifier = "" $oHttp.OAuthConsumerKey = "ETRADE_CONSUMER_KEY" $oHttp.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET" ; Load the access token previously obtained via the OAuth1 Authorization $oJsonToken = ObjCreate("Chilkat.JsonObject") Local $bSuccess = $oJsonToken.LoadFile("qa_data/tokens/etrade.json") If ($bSuccess <> True) Then ConsoleWrite("Failed to load OAuth1 token" & @CRLF) Exit EndIf $oHttp.OAuthToken = $oJsonToken.StringOf("oauth_token") $oHttp.OAuthTokenSecret = $oJsonToken.StringOf("oauth_token_secret") Local $sandboxUrl = "https://apisb.etrade.com/v1/accounts/{$accountIdKey}/orders" Local $sLiveUrl = "https://api.etrade.com/v1/accounts/{$accountIdKey}/orders" $oHttp.SetUrlVar("accountIdKey","6_Dpy0rmuQ9cu9IbTfvF2A") Local $oResp = $oHttp.QuickGetObj($sandboxUrl) If ($oHttp.LastMethodSuccess <> True) Then ConsoleWrite($oHttp.LastErrorText & @CRLF) Exit EndIf ; Make sure a successful response was received. If ($oResp.StatusCode > 200) Then ConsoleWrite($oResp.StatusLine & @CRLF) ConsoleWrite($oResp.Header & @CRLF) ConsoleWrite($oResp.BodyStr & @CRLF) Exit EndIf ; Sample XML response: ; Use this online tool to generate parsing code from sample XML: ; Generate Parsing Code from XML ; <?xml version="1.0" encoding="UTF-8" standalone="yes"?> ; <OrdersResponse> ; <marker>12345678999</marker> ; <next>https://api.sit.etrade.com/accounts/E5Nd4LJBsEi_UyHm4Vio9g/orders?marker=12345678999</next> ; <Order> ; <orderId>479</orderId> ; <details>https://api.etrade.com/accounts/E5Nd4LJBsEi_UyHm4Vio9g/orders/479</details> ; <orderType>OPTN</orderType> ; <OrderDetail> ; <placedTime>123453456</placedTime> ; <orderValue>123.0000</orderValue> ; <status>OPEN</status> ; <orderTerm>GOOD_FOR_DAY</orderTerm> ; <priceType>LIMIT</priceType> ; <limitPrice>1.5</limitPrice> ; <stopPrice>0</stopPrice> ; <marketSession>REGULAR</marketSession> ; <allOrNone>false</allOrNone> ; <Instrument> ; <Product> ; <symbol>RIMM</symbol> ; <securityType>OPTN</securityType> ; <callPut>CALL</callPut> ; <expiryYear>2012</expiryYear> ; <expiryMonth>3</expiryMonth> ; <expiryDay>9</expiryDay> ; <strikePrice>12</strikePrice> ; </Product> ; <symbolDescription>RESEARCH IN MOTION LTD COM</symbolDescription> ; <orderAction>BUY_OPEN</orderAction> ; <quantityType>QUANTITY</quantityType> ; <orderedQuantity>5</orderedQuantity> ; <filledQuantity>5</filledQuantity> ; <averageExecutionPrice>0</averageExecutionPrice> ; <estimatedCommission>9.99</estimatedCommission> ; <estimatedFees>0</estimatedFees> ; </Instrument> ; <netPrice>0</netPrice> ; <netBid>0</netBid> ; <netAsk>0</netAsk> ; <gcd>0</gcd> ; <ratio/> ; </OrderDetail> ; </Order> ; <Order> ; <orderId>477</orderId> ; <details>https://api.etrade.com/accounts/E5Nd4LJBsEi_UyHm4Vio9g/orders/477</details> ; <orderType>ONE_CANCELS_ALL</orderType> ; <totalOrderValue>209.99</totalOrderValue> ; <totalCommission>10.74</totalCommission> ; <OrderDetail> ; <orderNumber>1</orderNumber> ; <placedTime>1331699203122</placedTime> ; <orderValue>123.0000</orderValue> ; <status>OPEN</status> ; <orderTerm>GOOD_FOR_DAY</orderTerm> ; <priceType>LIMIT</priceType> ; <limitPrice>2</limitPrice> ; <stopPrice>0</stopPrice> ; <marketSession>REGULAR</marketSession> ; <bracketedLimitPrice>2</bracketedLimitPrice> ; <initialStopPrice>2</initialStopPrice> ; <allOrNone>false</allOrNone> ; <Instrument> ; <Product> ; <symbol>ETFC</symbol> ; <securityType>EQ</securityType> ; </Product> ; <symbolDescription>ETRADE Financials</symbolDescription> ; <orderAction>BUY</orderAction> ; <quantityType>QUANTITY</quantityType> ; <orderedQuantity>100</orderedQuantity> ; <filledQuantity>0</filledQuantity> ; <averageExecutionPrice>0</averageExecutionPrice> ; <estimatedCommission>9.99</estimatedCommission> ; <estimatedFees>0</estimatedFees> ; </Instrument> ; <netPrice>0</netPrice> ; <netBid>0</netBid> ; <netAsk>0</netAsk> ; <gcd>0</gcd> ; <ratio/> ; </OrderDetail> ; <OrderDetail> ; <orderNumber>2</orderNumber> ; <placedTime>1331699203</placedTime> ; <orderValue>231.0000</orderValue> ; <status>OPEN</status> ; <orderTerm>GOOD_FOR_DAY</orderTerm> ; <priceType>LIMIT</priceType> ; <limitPrice>0.5</limitPrice> ; <stopPrice>0</stopPrice> ; <marketSession>REGULAR</marketSession> ; <initialStopPrice>0.5</initialStopPrice> ; <allOrNone>false</allOrNone> ; <Instrument> ; <Product> ; <symbol>MON</symbol> ; <securityType>OPTN</securityType> ; <callPut>CALL</callPut> ; <expiryYear>2012</expiryYear> ; <expiryMonth>4</expiryMonth> ; <expiryDay>21</expiryDay> ; <strikePrice>85</strikePrice> ; </Product> ; <symbolDescription>MON Mar 9 '12 $85 Call</symbolDescription> ; <orderAction>BUY_OPEN</orderAction> ; <quantityType>QUANTITY</quantityType> ; <orderedQuantity>1</orderedQuantity> ; <filledQuantity>0</filledQuantity> ; <averageExecutionPrice>0</averageExecutionPrice> ; <estimatedCommission>9.99</estimatedCommission> ; <estimatedFees>0</estimatedFees> ; </Instrument> ; <netPrice>0</netPrice> ; <netBid>0</netBid> ; <netAsk>0</netAsk> ; <gcd>0</gcd> ; <ratio/> ; </OrderDetail> ; </Order> ; <Order> ; <orderId>475</orderId> ; <details>https://api.etrade.com/accounts/E5Nd4LJBsEi_UyHm4Vio9g/orders/475</details> ; <orderType>SPREADS</orderType> ; <OrderDetail> ; <placedTime>1331742953</placedTime> ; <executedTime>1331742955432</executedTime> ; <orderValue>4445.99</orderValue> ; <status>EXECUTED</status> ; <orderTerm>GOOD_FOR_DAY</orderTerm> ; <priceType>NET_DEBIT</priceType> ; <limitPrice>1.5</limitPrice> ; <stopPrice>0</stopPrice> ; <marketSession>REGULAR</marketSession> ; <allOrNone>false</allOrNone> ; <Instrument> ; <Product> ; <symbol>REE</symbol> ; <securityType>OPTN</securityType> ; <callPut>CALL</callPut> ; <expiryYear>2012</expiryYear> ; <expiryMonth>7</expiryMonth> ; <expiryDay>21</expiryDay> ; <strikePrice>7</strikePrice> ; </Product> ; <symbolDescription>REE Jul 21 '12 $7 Call</symbolDescription> ; <orderAction>BUY_OPEN</orderAction> ; <quantityType>QUANTITY</quantityType> ; <orderedQuantity>2</orderedQuantity> ; <filledQuantity>2</filledQuantity> ; <averageExecutionPrice>1.5</averageExecutionPrice> ; <estimatedCommission>7.24</estimatedCommission> ; <estimatedFees>0</estimatedFees> ; </Instrument> ; <Instrument> ; <Product> ; <symbol>REE</symbol> ; <securityType>OPTN</securityType> ; <callPut>PUT</callPut> ; <expiryYear>2013</expiryYear> ; <expiryMonth>1</expiryMonth> ; <expiryDay>19</expiryDay> ; <strikePrice>12.50</strikePrice> ; </Product> ; <symbolDescription>REE Jan 19 '13 $12.50 Put</symbolDescription> ; <orderAction>BUY_OPEN</orderAction> ; <quantityType>QUANTITY</quantityType> ; <orderedQuantity>2</orderedQuantity> ; <filledQuantity>2</filledQuantity> ; <averageExecutionPrice>1.5</averageExecutionPrice> ; <estimatedCommission>7.24</estimatedCommission> ; <estimatedFees>0</estimatedFees> ; </Instrument> ; <netPrice>0</netPrice> ; <netBid>0</netBid> ; <netAsk>0</netAsk> ; <gcd>0</gcd> ; <ratio/> ; </OrderDetail> ; </Order> ; </OrdersResponse> ; $oXml = ObjCreate("Chilkat.Xml") $oXml.LoadXml($oResp.BodyStr) ConsoleWrite($oXml.GetXml() & @CRLF) Local $iOrderId Local $sDetails Local $sOrderType Local $iJ Local $iCount_j Local $sPlacedTime Local $sOrderValue Local $status Local $sOrderTerm Local $sPriceType Local $sLimitPrice Local $iStopPrice Local $sMarketSession Local $sAllOrNone Local $iK Local $iCount_k Local $symbol Local $securityType Local $sCallPut Local $iExpiryYear Local $iExpiryMonth Local $iExpiryDay Local $strikePrice Local $symbolDescription Local $sOrderAction Local $sQuantityType Local $iOrderedQuantity Local $iFilledQuantity Local $sAverageExecutionPrice Local $sEstimatedCommission Local $iEstimatedFees Local $iNetPrice Local $iNetBid Local $iNetAsk Local $iGcd Local $iOrderNumber Local $iBracketedLimitPrice Local $sInitialStopPrice Local $sExecutedTime Local $sTotalOrderValue Local $sTotalCommission Local $sMarker = $oXml.GetChildContent("marker") Local $sNext = $oXml.GetChildContent("next") Local $i = 0 Local $iCount_i = $oXml.NumChildrenHavingTag("Order") While $i < $iCount_i $oXml.I = $i $iOrderId = $oXml.GetChildIntValue("Order[i]|orderId") $sDetails = $oXml.GetChildContent("Order[i]|details") $sOrderType = $oXml.GetChildContent("Order[i]|orderType") $iJ = 0 $iCount_j = $oXml.NumChildrenHavingTag("Order[i]|OrderDetail") While $iJ < $iCount_j $oXml.J = $iJ $sPlacedTime = $oXml.GetChildContent("Order[i]|OrderDetail[j]|placedTime") $sOrderValue = $oXml.GetChildContent("Order[i]|OrderDetail[j]|orderValue") $status = $oXml.GetChildContent("Order[i]|OrderDetail[j]|status") $sOrderTerm = $oXml.GetChildContent("Order[i]|OrderDetail[j]|orderTerm") $sPriceType = $oXml.GetChildContent("Order[i]|OrderDetail[j]|priceType") $sLimitPrice = $oXml.GetChildContent("Order[i]|OrderDetail[j]|limitPrice") $iStopPrice = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|stopPrice") $sMarketSession = $oXml.GetChildContent("Order[i]|OrderDetail[j]|marketSession") $sAllOrNone = $oXml.GetChildContent("Order[i]|OrderDetail[j]|allOrNone") $iK = 0 $iCount_k = $oXml.NumChildrenHavingTag("Order[i]|OrderDetail[j]|Instrument") While $iK < $iCount_k $oXml.K = $iK $symbol = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|symbol") $securityType = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|securityType") $sCallPut = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|callPut") $iExpiryYear = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryYear") $iExpiryMonth = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryMonth") $iExpiryDay = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryDay") $strikePrice = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|strikePrice") $symbolDescription = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|symbolDescription") $sOrderAction = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|orderAction") $sQuantityType = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|quantityType") $iOrderedQuantity = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|orderedQuantity") $iFilledQuantity = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|filledQuantity") $sAverageExecutionPrice = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|averageExecutionPrice") $sEstimatedCommission = $oXml.GetChildContent("Order[i]|OrderDetail[j]|Instrument[k]|estimatedCommission") $iEstimatedFees = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|estimatedFees") $iK = $iK + 1 Wend $iNetPrice = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|netPrice") $iNetBid = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|netBid") $iNetAsk = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|netAsk") $iGcd = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|gcd") $iOrderNumber = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|orderNumber") $iBracketedLimitPrice = $oXml.GetChildIntValue("Order[i]|OrderDetail[j]|bracketedLimitPrice") $sInitialStopPrice = $oXml.GetChildContent("Order[i]|OrderDetail[j]|initialStopPrice") $sExecutedTime = $oXml.GetChildContent("Order[i]|OrderDetail[j]|executedTime") $iJ = $iJ + 1 Wend $sTotalOrderValue = $oXml.GetChildContent("Order[i]|totalOrderValue") $sTotalCommission = $oXml.GetChildContent("Order[i]|totalCommission") $i = $i + 1 Wend ConsoleWrite("Success." & @CRLF) |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.