Column | Data Type | Description |
---|
absolute_profit_usd | numeric | absolute profit in usd (gross) |
trade_type | text |
|
parent_username | text |
|
parent_display_name | text |
|
child_username | text |
|
xirr | numeric | annualized internal rate of return |
xirr_trade_ccy | null | not in use |
absolute_return | numeric | percentage return (gross) |
trade_date_notional_usd | numeric |
|
custodian | text |
|
amount_used_for_custodian | numeric | invested amount for custodian |
traded_on | date |
|
trade_date_mtm_usd | numeric |
|
trade_price | numeric |
|
security_name | text |
|
position_closed | boolean | whether position is open or closed |
ticket_ref | text | ticket reference for transaction |
invested_amount_usd | numeric |
|
ticker | text |
|
quantity | numeric |
|
user_asset_class | text | user defined asset class |
canopy_asset_class | text | canopy defined asset class |
credit_rating | null | not in use |
tags | null | not in use |
em_dm | null | not in use |