Strategy_Records
- Tanmai Sharma (Unlicensed)
Owned by Tanmai Sharma (Unlicensed)
| Name | Data Type | Description |
|---|---|---|
| id | integer | |
| instance_name | text | |
| parent_username | text | |
| child_username | text | |
| strategy_name | text | subset of strategy |
| strategy_type | text | strategy classification |
| record_date_text | text | date in text format ... (can we ignored unless user is using Sqlite which does not have a date field) |
| nav_on_networth | numeric | redundant .. pls ignore |
| nav_on_assets | numeric | redundant .. pls ignore |
| networth_base_ccy | numeric | networth of the entire strategy as of that record_date in strategy base currency (i.e. assets minus liabilities) |
| total_securities_base_ccy | numeric | networth less cash (for the avoidance of doubt, any outstanding loans / deposits / derivatives etc are not taken out of the calculation) |
| total_cash_base_ccy | numeric | |
| total_mtm_base_ccy | numeric | mark to market of all transactions in the strategy in base currency as of record date |
| total_price_adjustment_base_ccy | numeric | for Transfer In and Transfer Out trades (which are typically at historical acquisition cost), Canopy sets aside the Day 1 mark to market (otherwise the performance calculations will have a 'kink' in them and will be useless for benchmark and comparison purposes). This column tracks the total of this adjustment upto that date |
| total_money_in_base_ccy | numeric | redundant ... pls ignore |
| total_money_out_base_ccy | numeric | redundant ... pls ignore |
| total_money_in_base_ccy_static_fx | numeric | this tracks the total inflows (both Money In and Transfer In) into the account. The fx rate into base currency is 'frozen' as of the date of inflow |
| single_period_return_nav_on_assets | numeric | one day return of the strategy calculated on total_securities_base_ccy |
| single_period_return_nav_on_networth | numeric | one day return of the strategy calculate on networth_base_ccy |
| record_date | date | date of calculation |
| networth | numeric | redundant ... pls ignore |
| total_securities | numeric | redundant ... pls ignore |
| total_cash | numeric | redundant ... pls ignore |
| total_mtm | numeric | redundant ... pls ignore |
| total_price_adjustment | numeric | redundant ... pls ignore |
| nav_on_networth_base_ccy | numeric | redundant ... pls ignore |
| total_money_in | numeric | redundant ... pls ignore |
| total_money_out | numeric | redundant ... pls ignore |
| nav_on_assets_base_ccy | numeric | redundant ... pls ignore |
| created_at_seconds | numeric | redundant ... pls ignore |
| profit_today_base_ccy | numeric | one day total profit of the strategy |
| profit_today_usd | numeric | redundant ... pls ignore |
| profit_to_date_base_ccy | numeric | redundant ... pls ignore |
| total_dividend | numeric | redundant ... pls ignore |
| profit_ex_distributions_today_base_ccy | numeric | profit_today_base_ccy less distributions_today_base_ccy |
| distributions_today_base_ccy | numeric | distributions received on record date |
| total_asset_transfer | numeric | redundant ... pls ignore |
| networth_yesterday | numeric | redundant ... pls ignore |
| networth_change_after_flows | numeric | redundant ... pls ignore |
| total_loans | numeric | redundant ... pls ignore |
| total_bonds | numeric | redundant ... pls ignore |
| total_equity | numeric | redundant ... pls ignore |
| total_derivatives | numeric | redundant ... pls ignore |
| price_adj_yesterday | numeric | redundant ... pls ignore |
| total_securities_yesterday | numeric | redundant ... pls ignore |
| nav_yesterday | numeric | redundant ... pls ignore |
| securities_nav_yesterday | numeric | redundant ... pls ignore |
| total_misc_income | numeric | redundant ... pls ignore |
| total_misc_expense | numeric | redundant ... pls ignore |
| total_interest | numeric | redundant ... pls ignore |
| total_loan_cost | numeric | redundant ... pls ignore |
| uuid_code | text | unique identifier |
| inflow_base_ccy | numeric | redundant ... pls ignore |
| outflow_base_ccy | numeric | redundant ... pls ignore |
| total_asset_base_ccy | numeric | redundant ... pls ignore |
| tag | jsonb | json field in case some classifications need to be stored (to be meant to be freely used by the user) |
| created_at | date | timestamp |
| updated_at | date | timestamp |
| strategy_id | integer | |
| xirr | numeric | not implemented yet (June 2019) but in the works |
| dpi | numeric | not implemented yet (June 2019) but in the works |
| tvpi | numeric | not implemented yet (June 2019) but in the works |
| public_market_equivalent | numeric | not implemented yet (June 2019) but in the works |
| direct_alpha | numeric | not implemented yet (June 2019) but in the works |