(Tcl) ETrade v1 Get Account Balances

Get account balances using the ETrade v1 API.

Chilkat Tcl Extension Downloads Chilkat Tcl Extension Downloads

load ./chilkat.dll

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

set http [new_CkHttp]

CkHttp_put_OAuth1 $http 1
CkHttp_put_OAuthVerifier $http ""
CkHttp_put_OAuthConsumerKey $http "ETRADE_CONSUMER_KEY"
CkHttp_put_OAuthConsumerSecret $http "ETRADE_CONSUMER_SECRET"

# Load the access token previously obtained via the OAuth1 3-Legged Authorization examples Step1 and Step2.
set json [new_CkJsonObject]

set success [CkJsonObject_LoadFile $json "qa_data/tokens/etrade.json"]
if {$success != 1} then {
    puts "Failed to load OAuth1 token"
    delete_CkHttp $http
    delete_CkJsonObject $json
    exit
}

CkHttp_put_OAuthToken $http [CkJsonObject_stringOf $json "oauth_token"]
CkHttp_put_OAuthTokenSecret $http [CkJsonObject_stringOf $json "oauth_token_secret"]

# See the ETrade v1 API documentation HERE.

CkHttp_SetUrlVar $http "accountIdKey" "vsnhtF7d9jXxBy6HyaAC4vQ"
CkHttp_SetUrlVar $http "instType" "BROKERAGE"
set respStr [CkHttp_quickGetStr $http "https://apisb.etrade.com/v1/accounts/{$accountIdKey}/balance?instType={$instType}&realTimeNAV=true"]
if {[CkHttp_get_LastMethodSuccess $http] != 1} then {
    puts [CkHttp_lastErrorText $http]
    delete_CkHttp $http
    delete_CkJsonObject $json
    exit
}

# A 200 status code indicates success.
set statusCode [CkHttp_get_LastStatus $http]
puts "statusCode = $statusCode"

# Use the following online tool to generate parsing code from sample XML: 
# Generate Parsing Code from XML

# A sample XML response is shown below...

set xml [new_CkXml]

CkXml_LoadXml $xml $respStr

set accountId [CkXml_GetChildIntValue $xml "accountId"]
set accountType [CkXml_getChildContent $xml "accountType"]
set optionLevel [CkXml_getChildContent $xml "optionLevel"]
set accountDescription [CkXml_getChildContent $xml "accountDescription"]
set quoteMode [CkXml_GetChildIntValue $xml "quoteMode"]
set dayTraderStatus [CkXml_getChildContent $xml "dayTraderStatus"]
set accountMode [CkXml_getChildContent $xml "accountMode"]
set fundsForOpenOrdersCash [CkXml_GetChildIntValue $xml "Cash|fundsForOpenOrdersCash"]
set moneyMktBalance [CkXml_GetChildIntValue $xml "Cash|moneyMktBalance"]
set cashAvailableForInvestment [CkXml_GetChildIntValue $xml "Computed|cashAvailableForInvestment"]
set netCash [CkXml_getChildContent $xml "Computed|netCash"]
set cashBalance [CkXml_getChildContent $xml "Computed|cashBalance"]
set settledCashForInvestment [CkXml_GetChildIntValue $xml "Computed|settledCashForInvestment"]
set unSettledCashForInvestment [CkXml_GetChildIntValue $xml "Computed|unSettledCashForInvestment"]
set fundsWithheldFromPurchasePower [CkXml_GetChildIntValue $xml "Computed|fundsWithheldFromPurchasePower"]
set fundsWithheldFromWithdrawal [CkXml_GetChildIntValue $xml "Computed|fundsWithheldFromWithdrawal"]
set marginBuyingPower [CkXml_GetChildIntValue $xml "Computed|marginBuyingPower"]
set cashBuyingPower [CkXml_getChildContent $xml "Computed|cashBuyingPower"]
set dtMarginBuyingPower [CkXml_GetChildIntValue $xml "Computed|dtMarginBuyingPower"]
set dtCashBuyingPower [CkXml_GetChildIntValue $xml "Computed|dtCashBuyingPower"]
set shortAdjustBalance [CkXml_GetChildIntValue $xml "Computed|shortAdjustBalance"]
set regtEquity [CkXml_GetChildIntValue $xml "Computed|regtEquity"]
set regtEquityPercent [CkXml_GetChildIntValue $xml "Computed|regtEquityPercent"]
set accountBalance [CkXml_GetChildIntValue $xml "Computed|accountBalance"]
set dtCashOpenOrderReserve [CkXml_GetChildIntValue $xml "Margin|dtCashOpenOrderReserve"]
set dtMarginOpenOrderReserve [CkXml_GetChildIntValue $xml "Margin|dtMarginOpenOrderReserve"]

# <?xml version="1.0" encoding="UTF-8"?>
# <BalanceResponse>
#    <accountId>83564979</accountId>
#    <accountType>PDT_ACCOUNT</accountType>
#    <optionLevel>LEVEL_4</optionLevel>
#    <accountDescription>KRITHH TT</accountDescription>
#    <quoteMode>6</quoteMode>
#    <dayTraderStatus>PDT_MIN_EQUITY_RES_1XK</dayTraderStatus>
#    <accountMode>PDT ACCOUNT</accountMode>
#    <Cash>
#       <fundsForOpenOrdersCash>0</fundsForOpenOrdersCash>
#       <moneyMktBalance>0</moneyMktBalance>
#    </Cash>
#    <Computed>
#       <cashAvailableForInvestment>0</cashAvailableForInvestment>
#       <netCash>93921.44</netCash>
#       <cashBalance>93921.44</cashBalance>
#       <settledCashForInvestment>0</settledCashForInvestment>
#       <unSettledCashForInvestment>0</unSettledCashForInvestment>
#       <fundsWithheldFromPurchasePower>0</fundsWithheldFromPurchasePower>
#       <fundsWithheldFromWithdrawal>0</fundsWithheldFromWithdrawal>
#       <marginBuyingPower>0</marginBuyingPower>
#       <cashBuyingPower>93921.44</cashBuyingPower>
#       <dtMarginBuyingPower>0</dtMarginBuyingPower>
#       <dtCashBuyingPower>0</dtCashBuyingPower>
#       <shortAdjustBalance>0</shortAdjustBalance>
#       <regtEquity>0</regtEquity>
#       <regtEquityPercent>0</regtEquityPercent>
#       <accountBalance>0</accountBalance>
#    </Computed>
#    <Margin>
#       <dtCashOpenOrderReserve>0</dtCashOpenOrderReserve>
#       <dtMarginOpenOrderReserve>0</dtMarginOpenOrderReserve>
#    </Margin>
# </BalanceResponse>

delete_CkHttp $http
delete_CkJsonObject $json
delete_CkXml $xml