Sample code for 30+ languages & platforms
Perl

ETrade List Orders

See more ETrade Examples

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

Chilkat Perl Downloads

Download Chilkat for Perl
Perl 
use chilkat();

$success = 0;

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

$http = chilkat::CkHttp->new();

$http->put_OAuth1(1);
$http->put_OAuthVerifier("");
$http->put_OAuthConsumerKey("ETRADE_CONSUMER_KEY");
$http->put_OAuthConsumerSecret("ETRADE_CONSUMER_SECRET");

# Load the access token previously obtained via the OAuth1 Authorization
$jsonToken = chilkat::CkJsonObject->new();
$success = $jsonToken->LoadFile("qa_data/tokens/etrade.json");
if ($success != 1) {
    print "Failed to load OAuth1 token" . "\r\n";
    exit;
}

$http->put_OAuthToken($jsonToken->stringOf("oauth_token"));
$http->put_OAuthTokenSecret($jsonToken->stringOf("oauth_token_secret"));

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

$http->SetUrlVar("accountIdKey","6_Dpy0rmuQ9cu9IbTfvF2A");

$resp = chilkat::CkHttpResponse->new();
$success = $http->HttpNoBody("GET",$sandboxUrl,$resp);
if ($success == 0) {
    print $http->lastErrorText() . "\r\n";
    exit;
}

# Make sure a successful response was received.
if ($resp->get_StatusCode() > 200) {
    print $resp->statusLine() . "\r\n";
    print $resp->header() . "\r\n";
    print $resp->bodyStr() . "\r\n";
    exit;
}

# 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>
# 

$xml = chilkat::CkXml->new();
$xml->LoadXml($resp->bodyStr());
print $xml->getXml() . "\r\n";

$marker = $xml->getChildContent("marker");
$next = $xml->getChildContent("next");
$i = 0;
$count_i = $xml->NumChildrenHavingTag("Order");
while ($i < $count_i) {
    $xml->put_I($i);
    $orderId = $xml->GetChildIntValue("Order[i]|orderId");
    $details = $xml->getChildContent("Order[i]|details");
    $orderType = $xml->getChildContent("Order[i]|orderType");
    $j = 0;
    $count_j = $xml->NumChildrenHavingTag("Order[i]|OrderDetail");
    while ($j < $count_j) {
        $xml->put_J($j);
        $placedTime = $xml->getChildContent("Order[i]|OrderDetail[j]|placedTime");
        $orderValue = $xml->getChildContent("Order[i]|OrderDetail[j]|orderValue");
        $status = $xml->getChildContent("Order[i]|OrderDetail[j]|status");
        $orderTerm = $xml->getChildContent("Order[i]|OrderDetail[j]|orderTerm");
        $priceType = $xml->getChildContent("Order[i]|OrderDetail[j]|priceType");
        $limitPrice = $xml->getChildContent("Order[i]|OrderDetail[j]|limitPrice");
        $stopPrice = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|stopPrice");
        $marketSession = $xml->getChildContent("Order[i]|OrderDetail[j]|marketSession");
        $allOrNone = $xml->getChildContent("Order[i]|OrderDetail[j]|allOrNone");
        $k = 0;
        $count_k = $xml->NumChildrenHavingTag("Order[i]|OrderDetail[j]|Instrument");
        while ($k < $count_k) {
            $xml->put_K($k);
            $symbol = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|symbol");
            $securityType = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|securityType");
            $callPut = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|callPut");
            $expiryYear = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryYear");
            $expiryMonth = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryMonth");
            $expiryDay = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|Product|expiryDay");
            $strikePrice = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|Product|strikePrice");
            $symbolDescription = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|symbolDescription");
            $orderAction = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|orderAction");
            $quantityType = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|quantityType");
            $orderedQuantity = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|orderedQuantity");
            $filledQuantity = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|filledQuantity");
            $averageExecutionPrice = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|averageExecutionPrice");
            $estimatedCommission = $xml->getChildContent("Order[i]|OrderDetail[j]|Instrument[k]|estimatedCommission");
            $estimatedFees = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|Instrument[k]|estimatedFees");
            $k = $k + 1;
        }

        $netPrice = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|netPrice");
        $netBid = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|netBid");
        $netAsk = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|netAsk");
        $gcd = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|gcd");
        $orderNumber = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|orderNumber");
        $bracketedLimitPrice = $xml->GetChildIntValue("Order[i]|OrderDetail[j]|bracketedLimitPrice");
        $initialStopPrice = $xml->getChildContent("Order[i]|OrderDetail[j]|initialStopPrice");
        $executedTime = $xml->getChildContent("Order[i]|OrderDetail[j]|executedTime");
        $j = $j + 1;
    }

    $totalOrderValue = $xml->getChildContent("Order[i]|totalOrderValue");
    $totalCommission = $xml->getChildContent("Order[i]|totalCommission");
    $i = $i + 1;
}

print "Success." . "\r\n";