(Lianja) ETrade v1 View Portfolio

Get portfolio information for a selected brokerage account.

Chilkat Lianja Extension Download Chilkat Lianja Extension

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

loHttp = createobject("CkHttp")

loHttp.OAuth1 = .T.
loHttp.OAuthVerifier = ""
loHttp.OAuthConsumerKey = "ETRADE_CONSUMER_KEY"
loHttp.OAuthConsumerSecret = "ETRADE_CONSUMER_SECRET"

// Load the access token previously obtained via the OAuth1 3-Legged Authorization examples Step1 and Step2.
loJson = createobject("CkJsonObject")
llSuccess = loJson.LoadFile("qa_data/tokens/etrade.json")
if (llSuccess <> .T.) then
    ? "Failed to load OAuth1 token"
    release loHttp
    release loJson
    return
endif

loHttp.OAuthToken = loJson.StringOf("oauth_token")
loHttp.OAuthTokenSecret = loJson.StringOf("oauth_token_secret")

// See the ETrade v1 API documentation HERE.

loHttp.SetUrlVar("accountIdKey","vsnhtF7d9jXxBy6HyaAC4vQ")
lcRespStr = loHttp.QuickGetStr("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/portfolio")
if (loHttp.LastMethodSuccess <> .T.) then
    ? loHttp.LastErrorText
    release loHttp
    release loJson
    return
endif

// A 200 status code indicates success.
lnStatusCode = loHttp.LastStatus
? "statusCode = " + str(lnStatusCode)

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

// A sample XML response is shown below...

loXml = createobject("CkXml")
loXml.LoadXml(lcRespStr)

lnAccountId = loXml.GetChildIntValue("AccountPortfolio|accountId")
i = 0
lnCount_i = loXml.NumChildrenHavingTag("AccountPortfolio|Position")
do while i < lnCount_i
    loXml.I = i
    lcPositionId = loXml.GetChildContent("AccountPortfolio|Position[i]|positionId")
    lnExpiryDay = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Product|expiryDay")
    lnExpiryMonth = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Product|expiryMonth")
    lnExpiryYear = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Product|expiryYear")
    lcSecurityType = loXml.GetChildContent("AccountPortfolio|Position[i]|Product|securityType")
    lnStrikePrice = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Product|strikePrice")
    lcSymbol = loXml.GetChildContent("AccountPortfolio|Position[i]|Product|symbol")
    lcSymbolDescription = loXml.GetChildContent("AccountPortfolio|Position[i]|symbolDescription")
    lnDateAcquired = loXml.GetChildIntValue("AccountPortfolio|Position[i]|dateAcquired")
    lnPricePaid = loXml.GetChildIntValue("AccountPortfolio|Position[i]|pricePaid")
    lnCommissions = loXml.GetChildIntValue("AccountPortfolio|Position[i]|commissions")
    lnOtherFees = loXml.GetChildIntValue("AccountPortfolio|Position[i]|otherFees")
    lnQuantity = loXml.GetChildIntValue("AccountPortfolio|Position[i]|quantity")
    lcPositionIndicator = loXml.GetChildContent("AccountPortfolio|Position[i]|positionIndicator")
    lcPositionType = loXml.GetChildContent("AccountPortfolio|Position[i]|positionType")
    lcDaysGain = loXml.GetChildContent("AccountPortfolio|Position[i]|daysGain")
    lcDaysGainPct = loXml.GetChildContent("AccountPortfolio|Position[i]|daysGainPct")
    lcMarketValue = loXml.GetChildContent("AccountPortfolio|Position[i]|marketValue")
    lnTotalCost = loXml.GetChildIntValue("AccountPortfolio|Position[i]|totalCost")
    lcTotalGain = loXml.GetChildContent("AccountPortfolio|Position[i]|totalGain")
    lnTotalGainPct = loXml.GetChildIntValue("AccountPortfolio|Position[i]|totalGainPct")
    lcPctOfPortfolio = loXml.GetChildContent("AccountPortfolio|Position[i]|pctOfPortfolio")
    lnCostPerShare = loXml.GetChildIntValue("AccountPortfolio|Position[i]|costPerShare")
    lnTodayCommissions = loXml.GetChildIntValue("AccountPortfolio|Position[i]|todayCommissions")
    lnTodayFees = loXml.GetChildIntValue("AccountPortfolio|Position[i]|todayFees")
    lnTodayPricePaid = loXml.GetChildIntValue("AccountPortfolio|Position[i]|todayPricePaid")
    lnTodayQuantity = loXml.GetChildIntValue("AccountPortfolio|Position[i]|todayQuantity")
    lcAdjPrevClose = loXml.GetChildContent("AccountPortfolio|Position[i]|adjPrevClose")
    lcChange = loXml.GetChildContent("AccountPortfolio|Position[i]|Quick|change")
    lcChangePct = loXml.GetChildContent("AccountPortfolio|Position[i]|Quick|changePct")
    lcLastTrade = loXml.GetChildContent("AccountPortfolio|Position[i]|Quick|lastTrade")
    lnLastTradeTime = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Quick|lastTradeTime")
    lcQuoteStatus = loXml.GetChildContent("AccountPortfolio|Position[i]|Quick|quoteStatus")
    lnVolume = loXml.GetChildIntValue("AccountPortfolio|Position[i]|Quick|volume")
    lcLotsDetails = loXml.GetChildContent("AccountPortfolio|Position[i]|lotsDetails")
    lcQuoteDetails = loXml.GetChildContent("AccountPortfolio|Position[i]|quoteDetails")
    i = i + 1
enddo
lnTotalPages = loXml.GetChildIntValue("AccountPortfolio|totalPages")

// <?xml version="1.0" encoding="UTF-8"?>
// <PortfolioResponse>
//    <AccountPortfolio>
//       <accountId>83554788</accountId>
//       <Position>
//          <positionId>10087531</positionId>
//          <Product>
//             <expiryDay>0</expiryDay>
//             <expiryMonth>0</expiryMonth>
//             <expiryYear>0</expiryYear>
//             <securityType>EQ</securityType>
//             <strikePrice>0</strikePrice>
//             <symbol>A</symbol>
//          </Product>
//          <symbolDescription>A</symbolDescription>
//          <dateAcquired>-68400000</dateAcquired>
//          <pricePaid>0</pricePaid>
//          <commissions>0</commissions>
//          <otherFees>0</otherFees>
//          <quantity>-120</quantity>
//          <positionIndicator>TYPE2</positionIndicator>
//          <positionType>SHORT</positionType>
//          <daysGain>190.80</daysGain>
//          <daysGainPct>2.4472</daysGainPct>
//          <marketValue>-7605.60</marketValue>
//          <totalCost>0</totalCost>
//          <totalGain>-7605.60</totalGain>
//          <totalGainPct>0</totalGainPct>
//          <pctOfPortfolio>-0.0008</pctOfPortfolio>
//          <costPerShare>0</costPerShare>
//          <todayCommissions>0</todayCommissions>
//          <todayFees>0</todayFees>
//          <todayPricePaid>0</todayPricePaid>
//          <todayQuantity>0</todayQuantity>
//          <adjPrevClose>64.970000</adjPrevClose>
//          <Quick>
//             <change>-1.59</change>
//             <changePct>-2.4472</changePct>
//             <lastTrade>63.38</lastTrade>
//             <lastTradeTime>1529429280</lastTradeTime>
//             <quoteStatus>DELAYED</quoteStatus>
//             <volume>2431617</volume>
//          </Quick>
//          <lotsDetails>https://api.etrade.com/v1/accounts/JDIozUumZpHdgbIjMnAAHQ/portfolio/10087531</lotsDetails>
//          <quoteDetails>https://api.etrade.com/v1/market/quote/A</quoteDetails>
//       </Position>
//       <Position>
//          <positionId>140357348131</positionId>
//          <Product>
//             <expiryDay>0</expiryDay>
//             <expiryMonth>0</expiryMonth>
//             <expiryYear>0</expiryYear>
//             <securityType>EQ</securityType>
//             <strikePrice>0</strikePrice>
//             <symbol>TWTR</symbol>
//          </Product>
//          <symbolDescription>TWTR</symbolDescription>
//          <dateAcquired>-68400000</dateAcquired>
//          <pricePaid>0</pricePaid>
//          <commissions>0</commissions>
//          <otherFees>0</otherFees>
//          <quantity>3</quantity>
//          <positionIndicator>TYPE2</positionIndicator>
//          <positionType>LONG</positionType>
//          <daysGain>-3.915</daysGain>
//          <daysGainPct>-2.8369</daysGainPct>
//          <marketValue>134.085</marketValue>
//          <totalCost>0</totalCost>
//          <totalGain>134.085</totalGain>
//          <totalGainPct>0</totalGainPct>
//          <pctOfPortfolio>0.0235</pctOfPortfolio>
//          <costPerShare>0</costPerShare>
//          <todayCommissions>0</todayCommissions>
//          <todayFees>0</todayFees>
//          <todayPricePaid>0</todayPricePaid>
//          <todayQuantity>0</todayQuantity>
//          <adjPrevClose>46.000000</adjPrevClose>
//          <Quick>
//             <change>-1.305</change>
//             <changePct>-2.8369</changePct>
//             <lastTrade>44.695</lastTrade>
//             <lastTradeTime>1529429280</lastTradeTime>
//             <quoteStatus>DELAYED</quoteStatus>
//             <volume>26582141</volume>
//          </Quick>
//          <lotsDetails>https://api.etrade.com/v1/accounts/yIFaUoJ81qyAhgxLWRQ42g/portfolio/140357348131</lotsDetails>
//          <quoteDetails>https://api.etrade.com/v1/market/quote/TWTR</quoteDetails>
//       </Position>
//       <totalPages>1</totalPages>
//    </AccountPortfolio>
// </PortfolioResponse>


release loHttp
release loJson
release loXml