Lua
Lua
ETrade v1 View Portfolio
See more HTTP Misc Examples
Get portfolio information for a selected brokerage account.Chilkat Lua Downloads
local chilkat = require("chilkat")
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
local http = chilkat.Http.new()
http.oauth1 = true
http.oauth_verifier = ""
http.oauth_consumer_key = "ETRADE_CONSUMER_KEY"
http.oauth_consumer_secret = "ETRADE_CONSUMER_SECRET"
-- Load the access token previously obtained via the OAuth1 3-Legged Authorization examples Step1 and Step2.
local json = chilkat.JsonObject.new()
local success = json:load_file("qa_data/tokens/etrade.json")
if not success then
print("Failed to load OAuth1 token")
return
end
http.oauth_token = json:string_of("oauth_token")
http.oauth_token_secret = json:string_of("oauth_token_secret")
-- See the ETrade v1 API documentation HERE.
http:set_url_var("accountIdKey", "vsnhtF7d9jXxBy6HyaAC4vQ")
local respStr = http:quick_get_str("https://apisb.etrade.com/v1/accounts/{$accountIdKey}/portfolio")
if not http.last_method_success then
print(http.last_error_text)
return
end
-- A 200 status code indicates success.
local statusCode = http.last_status
print("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...
local xml = chilkat.Xml.new()
xml:load_xml(respStr)
local tagPath = ""
local positionId = ""
local expiryDay = 0
local expiryMonth = 0
local expiryYear = 0
local securityType = ""
local strikePrice = 0
local symbol = ""
local symbolDescription = ""
local dateAcquired = 0
local pricePaid = 0
local commissions = 0
local otherFees = 0
local quantity = 0
local positionIndicator = ""
local positionType = ""
local daysGain = ""
local daysGainPct = ""
local marketValue = ""
local totalCost = 0
local totalGain = ""
local totalGainPct = 0
local pctOfPortfolio = ""
local costPerShare = 0
local todayCommissions = 0
local todayFees = 0
local todayPricePaid = 0
local todayQuantity = 0
local adjPrevClose = ""
local change = ""
local changePct = ""
local lastTrade = ""
local lastTradeTime = 0
local quoteStatus = ""
local volume = 0
local lotsDetails = ""
local quoteDetails = ""
local accountId = xml:get_child_int_value("AccountPortfolio|accountId")
local i = 0
local count_i = xml:num_children_having_tag("AccountPortfolio|Position")
while i < count_i do
xml.i = i
positionId = xml:get_child_content("AccountPortfolio|Position[i]|positionId")
expiryDay = xml:get_child_int_value("AccountPortfolio|Position[i]|Product|expiryDay")
expiryMonth = xml:get_child_int_value("AccountPortfolio|Position[i]|Product|expiryMonth")
expiryYear = xml:get_child_int_value("AccountPortfolio|Position[i]|Product|expiryYear")
securityType = xml:get_child_content("AccountPortfolio|Position[i]|Product|securityType")
strikePrice = xml:get_child_int_value("AccountPortfolio|Position[i]|Product|strikePrice")
symbol = xml:get_child_content("AccountPortfolio|Position[i]|Product|symbol")
symbolDescription = xml:get_child_content("AccountPortfolio|Position[i]|symbolDescription")
dateAcquired = xml:get_child_int_value("AccountPortfolio|Position[i]|dateAcquired")
pricePaid = xml:get_child_int_value("AccountPortfolio|Position[i]|pricePaid")
commissions = xml:get_child_int_value("AccountPortfolio|Position[i]|commissions")
otherFees = xml:get_child_int_value("AccountPortfolio|Position[i]|otherFees")
quantity = xml:get_child_int_value("AccountPortfolio|Position[i]|quantity")
positionIndicator = xml:get_child_content("AccountPortfolio|Position[i]|positionIndicator")
positionType = xml:get_child_content("AccountPortfolio|Position[i]|positionType")
daysGain = xml:get_child_content("AccountPortfolio|Position[i]|daysGain")
daysGainPct = xml:get_child_content("AccountPortfolio|Position[i]|daysGainPct")
marketValue = xml:get_child_content("AccountPortfolio|Position[i]|marketValue")
totalCost = xml:get_child_int_value("AccountPortfolio|Position[i]|totalCost")
totalGain = xml:get_child_content("AccountPortfolio|Position[i]|totalGain")
totalGainPct = xml:get_child_int_value("AccountPortfolio|Position[i]|totalGainPct")
pctOfPortfolio = xml:get_child_content("AccountPortfolio|Position[i]|pctOfPortfolio")
costPerShare = xml:get_child_int_value("AccountPortfolio|Position[i]|costPerShare")
todayCommissions = xml:get_child_int_value("AccountPortfolio|Position[i]|todayCommissions")
todayFees = xml:get_child_int_value("AccountPortfolio|Position[i]|todayFees")
todayPricePaid = xml:get_child_int_value("AccountPortfolio|Position[i]|todayPricePaid")
todayQuantity = xml:get_child_int_value("AccountPortfolio|Position[i]|todayQuantity")
adjPrevClose = xml:get_child_content("AccountPortfolio|Position[i]|adjPrevClose")
change = xml:get_child_content("AccountPortfolio|Position[i]|Quick|change")
changePct = xml:get_child_content("AccountPortfolio|Position[i]|Quick|changePct")
lastTrade = xml:get_child_content("AccountPortfolio|Position[i]|Quick|lastTrade")
lastTradeTime = xml:get_child_int_value("AccountPortfolio|Position[i]|Quick|lastTradeTime")
quoteStatus = xml:get_child_content("AccountPortfolio|Position[i]|Quick|quoteStatus")
volume = xml:get_child_int_value("AccountPortfolio|Position[i]|Quick|volume")
lotsDetails = xml:get_child_content("AccountPortfolio|Position[i]|lotsDetails")
quoteDetails = xml:get_child_content("AccountPortfolio|Position[i]|quoteDetails")
i = i + 1
end
local totalPages = xml:get_child_int_value("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>