...
Price conversions are available in Add Issue Price Conversion, Edit Issue Price Conversion, and Add/Edit Price Exchange Conversion. There is logic to identify the most recent market value, look up the cost as of that date, compare it to the cost as of price date, and apply the difference to the market value. The table below explains each field involved in the process . The entity that was used in the lookups is stored in the PRICE or PRICE_EXCHANGE table for audit purposesand which are stored for audit purposes. These fields are stored in the PRICE table if you load prices directly or the PRICE_EXCHANGE table if you use Pricing Center or Reference Data Center (RDC) Pricing.
Field | Tag | Value | Column Name |
|---|---|---|---|
Source Name | 1102 | Ensure you select the appropriate source for the position being valued. It should match the entity’s Private Equity Price Source (18452). This is critical if you hold the same security master file (SMF) across multiple funds and are using Private Equity Price Source to apply a different market value to each position. | SRC_INTFC_INST |
Effective Date | 1109 | Price date. | EFFECTIVE_DATE |
Price Type Code | 1843 | Set to | PRICE_TYPE_CODE |
Pricing Entity ID | 7107 | If a value is not provided, it will be looked up automatically. You must populate the appropriate value if you hold the same SMF across multiple funds. | ENTITY_ID |
Current Cost | 128 | Looked up automatically based on Effective Date. | |
Last Cost | 7686 | Looked up automatically based on Most Recent Close Price Date. | |
Cost Delta | 7687 | Calculated as Current Cost - Last Cost. | |
Most Recent Close Price Date | 513 | Looked up automatically. | PX_SOURCE (PRICE table only) |
Most Recent Close Price | 1852 | Looked up automatically. | PX_REFERENCE (PRICE table only) |
Closing Price or OR Price | 481 or 7723 | Calculated as Most Recent Close Price + Cost Delta. | PRICE |