| 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 | |
| nav_on_networth | numeric | nav on networth (account level: example, custodian, child, entire account) |
| nav_on_assets | numeric | nav on assets (asset class, securities) |
| networth_base_ccy | numeric | |
| total_securities_base_ccy | numeric | |
| total_cash_base_ccy | numeric | |
| total_mtm_base_ccy | numeric | |
| total_price_adjustment_base_ccy | numeric | |
| total_money_in_base_ccy | numeric | |
| total_money_out_base_ccy | numeric | |
| total_money_in_base_ccy_static_fx | numeric | |
| single_period_return_nav_on_assets | numeric | |
| single_period_return_nav_on_networth | numeric | |
| record_date | date | |
| networth | numeric | |
| total_securities | numeric | |
| total_cash | numeric | |
| total_mtm | numeric | |
| total_price_adjustment | numeric | |
| nav_on_networth_base_ccy | numeric | |
| total_money_in | numeric | |
| total_money_out | numeric | |
| nav_on_assets_base_ccy | numeric | |
| created_at_seconds | numeric | |
| profit_today_base_ccy | numeric | |
| profit_today_usd | numeric | |
| profit_to_date_base_ccy | numeric | |
| total_dividend | numeric | |
| profit_ex_distributions_today_base_ccy | numeric | |
| distributions_today_base_ccy | numeric | |
| total_asset_transfer | numeric | |
| networth_yesterday | numeric | |
| networth_change_after_flows | numeric | |
| total_loans | numeric | |
| total_bonds | numeric | |
| total_equity | numeric | |
| total_derivatives | numeric | |
| price_adj_yesterday | numeric | |
| total_securities_yesterday | numeric | |
| nav_yesterday | numeric | |
| securities_nav_yesterday | numeric | |
| total_misc_income | numeric | |
| total_misc_expense | numeric | |
| total_interest | numeric | |
| total_loan_cost | numeric | |
| uuid_code | text | |
| inflow_base_ccy | numeric | |
| outflow_base_ccy | numeric | |
| total_asset_base_ccy | numeric | |
| tag | jsonb | |
| created_at | date | |
| updated_at | date | |
| strategy_id | integer | |
| xirr | numeric | |
| dpi | numeric | |
| tvpi | numeric | |
| public_market_equivalent | numeric | |
| direct_alpha | numeric |
General
Content
Integrations