Consolidated_Holdings
- Tanmai Sharma (Unlicensed)
- Sinan Biren (Unlicensed)
Owned by Tanmai Sharma (Unlicensed)
This table contains a daily snapshot of all holdings of a particular customer or customers
| Column | Data Type | Description | Additional Links |
|---|---|---|---|
| history_date | date | individual working days | |
| parent_username | text | parent account name | |
| child_username | text | child account code name | |
| child_display_name | text | child account display name | |
| custodian_name | text | name of custodian | |
| security_id | integer | ||
| ticker | text | ||
| security_name | text | ||
| ccyaccountid | integer | ||
| contract_currency | text | currency of contract | |
| quantity | numeric | quantity of holding | |
| latest_price_date | date | latest available price date | |
| latest_price_close | numeric | latest available close price | |
| latest_price_clean | numeric | latest available clean price | |
| market_value_usd | numeric | market value in usd | |
| absolute_market_value_usd | numeric | absolute market value in usd | |
| mtm_total_usd | numeric | total marked to market usd | |
| mtm_price_usd | numeric | marked to market usd due to price change | |
| mtm_fx_usd | numeric | marked to market usd due to FX | |
| mtm_accrued_usd | numeric | marked to market usd due to accrued interest | |
| user_asset_class | text | user defined asset class | |
| user_geography | text | user defined geography | |
| canopy_asset_class | text | canopy defined asset class | https://mesitis.atlassian.net/wiki/spaces/HOW/pages/368836759/Canopy+Asset+Classes |
| credit_rating | null | not in use | |
| em_dm | null | not in use | |
| tags | jsonb | not in use | |
| market_value_base_ccy | numeric | market value in base currency | |
| absolute_market_value_base_ccy | numeric | absolute market value in base currency | |
| mtm_total_base_ccy | numeric | Profit of the transaction (Market Value - Entry Value) Market Value - Settlement Amount (Gross Amount for TransferfOP) | |
| mtm_price_base_ccy | numeric | The change in MTM only attributable to price movement (prices.close - blotters.trade_price)* flashblotters.quantity | |
| mtm_fx_base_ccy | numeric | The change in MTM only attributable to FX movement Total - Price - Accrued | |
| mtm_accrued_base_ccy | numeric | The change in MTM only attributable to accrued interest (prices.close - prices.clean) - (blotters.trade_date_dirty_px - blotters.trade_price) * flashblotters.quantity | |
| base_ccy | text | account base currency | |
| basefx_rate | numeric | account base fx rate against USD | |
| created_at | date | ||
| user_industry | |||
| partner_asset_class | |||
| partner_geography | |||
| uuid_key |