Flash_Blotter_Market_Value_History (deprecated)
- Tanmai Sharma (Unlicensed)
- Niranjan Rajendran (Unlicensed)
Owned by Tanmai Sharma (Unlicensed)
| Column | Data Type | Description |
|---|---|---|
| fbmvh_id | integer | FK to FlashBlotters |
| flash_blotter_id | integer | |
| blotter id | integer | FK to blotters |
| security id | integer | |
| contract currency id | integer | |
| parent_user_id | integer | |
| history_date | date | |
| latest_price_date | date | latest available price date |
| latest_price_close | numeric | latest available close price |
| latest_price_clean | numeric | latest available clean price |
| latest_fx_contract_ccy | numeric | latest available contract fx rate against usd |
| multiplier | null | not in use |
| multiplier_x_price | null | not in use |
| market_value_usd | numeric | market value in usd |
| mtm_total_usd | numeric | Profit of the transaction (Market Value - Entry Value) Market Value - Settlement Amount (Gross Amount for TransferfOP) |
| mtm_price_usd | numeric | The change in MTM only attributable to price movement (prices.close - blotters.trade_price)* flashblotters.quantity |
| mtm_fx_usd | numeric | The change in MTM only attributable to FX movement Total - Price - Accrued |
| mtm_accrued_usd | numeric | The change in MTM only attributable to accrued interest (prices.close - prices.clean) - (blotters.trade_date_dirty_px - blotters.trade_price) * flashblotters.quantity |
| created_at | date | |
| updated_at | date | |
| tags | jsonb | not in use |