IRR_Table

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

Canopy Support