...
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 and 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.
The event must be submitted for each holding on each date when a valuation is required. This can be done manually using the panels mentioned above or in an automated fashion using Message Center. Templates below.
CSV Direct Price Load:
View file name Private Markets - Market Value Rollforward.csv CSV Price Exchange:
View file name Private Markets - Market Value Rollforward - Price Exchange.csv
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 Price | 481 or 7723 | Calculated as Most Recent Close Price + Cost Delta. | PRICE |