| 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 |
General
Content
Integrations