Sample code for 30+ languages & platforms
AutoIt

ETrade List Orders

See more ETrade Examples

Gets the order details for a selected brokerage account based on the search criteria provided.

Chilkat AutoIt Downloads

Download Chilkat for AutoIt
AutoIt 
Local $bSuccess = False

; 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")
$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")

$oResp = ObjCreate("Chilkat.HttpResponse")
$bSuccess = $oHttp.HttpNoBody("GET",$sandboxUrl,$oResp)
If ($bSuccess = False) 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)