...
entry_date | ticketref | trade_type | ccy_of_entry | entry_ccy_fxrate | base_ccy_fxrate | credit_account_code | credit_amount | debit_account_code | debit_amount | security_ticker | security_quantity | security_quantity_outstanding | cash_quantity | security_trade_price | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12/31/2013 | DEMO1-012568 | Buy | JPY | 0.009497 | 1 | demo_equity_managed_cssg01_jpy_01 | 166,634.36 | Equity | 166,634.36 | 9432_JP | 3100 | 0 | -17,546,000 | 5660 | ||
5/8/2014 | DEMO1-012183 | Sell | JPY | 0.009837 | 1 | Equity | 86,004.83 | demo_equity_managed_cssg01_jpy_01 | 86,004.83 | 9432_JP | -1600 | 9,038,325 | 5648.953 | |||
5/8/2014 | DEMO1-012183 | Sell | JPY | 0.009837 | 1 | TradingGainLoss | 2,905.17demo_equity_managed_cssg01_jpy_01 | 173.87 | PriceTradingGainLoss | 173.87 | 9432_JP | 0 | 0 | 0 | ||
5/8/2014 | DEMO1-012183 | Sell | JPY | 0.009837 | 1 | FxTradingGainLoss | 3,079.04 | demo_equity_managed_cssg01_jpy_01 | 23,905079.1704 | 9432_JP | 0 | 0 | 0 | |||
5/29/2014 | DEMO1-012187 | Sell | JPY | 0.009824 | 1 | Equity | 80,629.53 | demo_equity_managed_cssg01_jpy_01 | 80,629.53 | 9432_JP | -1500 | 8,984,899 | 5989.933 | |||
5/29/2014 | DEMO1-012187 | Sell | JPY | 0.009824 | 1 | TradingGainLoss | 7,638.12PriceTradingGainLoss | 4,861.89 | demo_equity_managed_cssg01_jpy_01 | 4,861.89 | 9432_JP | 0 | 0 | 0 | ||
5/29/2014 | DEMO1-012187 | Sell | JPY | 0.009824 | 1 | FxTradingGainLoss | 2,776.23 | demo_equity_managed_cssg01_jpy_01 | 72,638776.1223 | 9432_JP | 0 | 0 | 0 | |||
6/27/2014 | DEMO1-012287 | Dividend | JPY | 0.009862 | 1 | Distribution | 2,330.10 | demo_equity_managed_cssg01_jpy_01 | 2,330.10 | 9432_JP | 236,271 |
...
(a) All credits to Equity (i.e. USD 166,634.36) equal all debit to Equity (USD 86,004.83 + USD 80,629.53 = USD 166,634.36) thereby squaring off the entries.
(b) We have a net FX gain from sale of (–USD 173.87) + USD 2,776.23 = USD 2602.36
(c) We also have trading gains from price changes of USD 23,905079.17 04 + USD 74,638861.12 89 = USD 107,543940.2993
(c) We also d) Finally, we have dividend income of USD 2,330.10
...