(PowerShell) ETrade Get Account Balances

Retrieves the current account balance and related details for a specified account.

For more information, see https://apisb.etrade.com/docs/api/account/api-balance-v1.html

Chilkat .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

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

$http = New-Object 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
$jsonToken = New-Object Chilkat.JsonObject
$success = $jsonToken.LoadFile("qa_data/tokens/etrade.json")
if ($success -ne $true) {
    $("Failed to load OAuth1 token")
    exit
}

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

$sandboxUrl = "https://apisb.etrade.com/v1/accounts/{$accountIdKey}/balance?instType={$instType}&realTimeNAV=true"
$liveUrl = "https://api.etrade.com/v1/accounts/{$accountIdKey}/balance?instType={$instType}&realTimeNAV=true"

$http.SetUrlVar("accountIdKey","6_Dpy0rmuQ9cu9IbTfvF2A")
$http.SetUrlVar("instType","BROKERAGE")

$resp = $http.QuickGetObj($sandboxUrl)
if ($http.LastMethodSuccess -ne $true) {
    $($http.LastErrorText)
    exit
}

# Make sure a successful response was received.
if ($resp.StatusCode -gt 200) {
    $($resp.StatusLine)
    $($resp.Header)
    $($resp.BodyStr)
    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"?>
# <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>

$xml = New-Object Chilkat.Xml
$xml.LoadXml($resp.BodyStr)
$($xml.GetXml())

$accountId = $xml.GetChildIntValue("accountId")
$accountType = $xml.GetChildContent("accountType")
$optionLevel = $xml.GetChildContent("optionLevel")
$accountDescription = $xml.GetChildContent("accountDescription")
$quoteMode = $xml.GetChildIntValue("quoteMode")
$dayTraderStatus = $xml.GetChildContent("dayTraderStatus")
$accountMode = $xml.GetChildContent("accountMode")
$fundsForOpenOrdersCash = $xml.GetChildIntValue("Cash|fundsForOpenOrdersCash")
$moneyMktBalance = $xml.GetChildIntValue("Cash|moneyMktBalance")
$cashAvailableForInvestment = $xml.GetChildIntValue("Computed|cashAvailableForInvestment")
$netCash = $xml.GetChildContent("Computed|netCash")
$cashBalance = $xml.GetChildContent("Computed|cashBalance")
$settledCashForInvestment = $xml.GetChildIntValue("Computed|settledCashForInvestment")
$unSettledCashForInvestment = $xml.GetChildIntValue("Computed|unSettledCashForInvestment")
$fundsWithheldFromPurchasePower = $xml.GetChildIntValue("Computed|fundsWithheldFromPurchasePower")
$fundsWithheldFromWithdrawal = $xml.GetChildIntValue("Computed|fundsWithheldFromWithdrawal")
$marginBuyingPower = $xml.GetChildIntValue("Computed|marginBuyingPower")
$cashBuyingPower = $xml.GetChildContent("Computed|cashBuyingPower")
$dtMarginBuyingPower = $xml.GetChildIntValue("Computed|dtMarginBuyingPower")
$dtCashBuyingPower = $xml.GetChildIntValue("Computed|dtCashBuyingPower")
$shortAdjustBalance = $xml.GetChildIntValue("Computed|shortAdjustBalance")
$regtEquity = $xml.GetChildIntValue("Computed|regtEquity")
$regtEquityPercent = $xml.GetChildIntValue("Computed|regtEquityPercent")
$accountBalance = $xml.GetChildIntValue("Computed|accountBalance")
$dtCashOpenOrderReserve = $xml.GetChildIntValue("Margin|dtCashOpenOrderReserve")
$dtMarginOpenOrderReserve = $xml.GetChildIntValue("Margin|dtMarginOpenOrderReserve")

$("Success.")