(PHP ActiveX) ETrade List Orders

Gets 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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows Note: The php_com_dotnet.dll may need to be enabled inside of php.ini.

<?php

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

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Http')
$http = new COM("Chilkat.Http");

$http->OAuth1 = 1;
$http->OAuthVerifier = '';
$http->OAuthConsumerKey = 'ETRADE_CONSUMER_KEY';
$http->OAuthConsumerSecret = 'ETRADE_CONSUMER_SECRET';

// Load the access token previously obtained via the OAuth1 Authorization
// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject')
$jsonToken = new COM("Chilkat.JsonObject");
$success = $jsonToken->LoadFile('qa_data/tokens/etrade.json');
if ($success != 1) {
    print 'Failed to load OAuth1 token' . "\n";
    exit;
}

$http->OAuthToken = $jsonToken->stringOf('oauth_token');
$http->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 is a Chilkat.HttpResponse
$resp = $http->QuickGetObj($sandboxUrl);
if ($http->LastMethodSuccess != 1) {
    print $http->LastErrorText . "\n";
    exit;
}

// Make sure a successful response was received.
if ($resp->StatusCode > 200) {
    print $resp->StatusLine . "\n";
    print $resp->Header . "\n";
    print $resp->BodyStr . "\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>
// 

// For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Xml')
$xml = new COM("Chilkat.Xml");
$xml->LoadXml($resp->BodyStr);
print $xml->getXml() . "\n";

$marker = $xml->getChildContent('marker');
$next = $xml->getChildContent('next');
$i = 0;
$count_i = $xml->NumChildrenHavingTag('Order');
while ($i < $count_i) {
    $xml->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->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->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.' . "\n";

?>