(Node.js) 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

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

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

    var http = new chilkat.Http();

    http.OAuth1 = true;
    http.OAuthVerifier = "";
    http.OAuthConsumerKey = "ETRADE_CONSUMER_KEY";
    http.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET";

    // Load the access token previously obtained via the OAuth1 Authorization
    var jsonToken = new chilkat.JsonObject();
    var success = jsonToken.LoadFile("qa_data/tokens/etrade.json");
    if (success !== true) {
        console.log("Failed to load OAuth1 token");
        return;
    }

    http.OAuthToken = jsonToken.StringOf("oauth_token");
    http.OAuthTokenSecret = jsonToken.StringOf("oauth_token_secret");

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

    http.SetUrlVar("accountIdKey","6_Dpy0rmuQ9cu9IbTfvF2A");

    // resp: HttpResponse
    var resp = http.QuickGetObj(sandboxUrl);
    if (http.LastMethodSuccess !== true) {
        console.log(http.LastErrorText);
        return;
    }

    // Make sure a successful response was received.
    if (resp.StatusCode > 200) {
        console.log(resp.StatusLine);
        console.log(resp.Header);
        console.log(resp.BodyStr);
        return;
    }

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

    var xml = new chilkat.Xml();
    xml.LoadXml(resp.BodyStr);
    console.log(xml.GetXml());

    var orderId;
    var details;
    var orderType;
    var j;
    var count_j;
    var placedTime;
    var orderValue;
    var status;
    var orderTerm;
    var priceType;
    var limitPrice;
    var stopPrice;
    var marketSession;
    var allOrNone;
    var k;
    var count_k;
    var symbol;
    var securityType;
    var callPut;
    var expiryYear;
    var expiryMonth;
    var expiryDay;
    var strikePrice;
    var symbolDescription;
    var orderAction;
    var quantityType;
    var orderedQuantity;
    var filledQuantity;
    var averageExecutionPrice;
    var estimatedCommission;
    var estimatedFees;
    var netPrice;
    var netBid;
    var netAsk;
    var gcd;
    var orderNumber;
    var bracketedLimitPrice;
    var initialStopPrice;
    var executedTime;
    var totalOrderValue;
    var totalCommission;

    var marker = xml.GetChildContent("marker");
    var next = xml.GetChildContent("next");
    var i = 0;
    var 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;
    }

    console.log("Success.");

}

chilkatExample();