Before you perform a valuation, you must make decisions and perform operations in a particular order.
Step 1: Decide on your valuation schedule
Choose the date and time at which you want to perform the valuation. If you do not specify a time component, valuation occurs at 00:00:00. Note the time chosen impacts the validity period of the market data you are required to assemble and load in advance into an appropriate LUSID store; see Step 4.
You can specify a range of dates and create a separate valuation report for each day in the range. Note this impacts the quantity of market data required; see Step 4. Note also that by convention no report is produced for Saturdays and Sundays in the range.
Step 2: Evaluate what types of instruments you are valuing
Each type of instrument that LUSID supports has a default pricing model that determines the categories of market data required:
|Instrument type||Default pricing model||Categories of market data required||LUSID market data store||Other pricing models available?|
|Market price||FX spot rate if different to the portfolio/reporting currency||Quote Store||No|
|None. This model just sums the remaining coupons and the principal.||FX spot rate if different to the portfolio/reporting currency||Yes (see Step 3)|
|FX spot rate between the two currencies||FX spot rate if domestic currency is different to the portfolio/reporting currency|
|All other types||We recommend changing the pricing model, which impacts the market data required and where it is stored; see Step 3.|
- If you are valuing only equities (that is, instruments of type
Equity), you cannot change the pricing model and market data requirements are simplified. Go to step 4.
- If you are valuing instruments of any other type, we recommend changing the pricing model for each type, which impacts the categories of market data required. Go to step 3.
Step 3: Consider changing the pricing model for non-equity instruments
This is likely to provide a more sophisticated result, but impacts the categories of market data required:
- Choose an appropriate, valid pricing model for each instrument type. See how to do this.
- Evaluate which categories of market data are required for each instrument type and pricing model combination. See how to do this.
Step 4: Load market data into appropriate LUSID store(s)
For each instrument type and pricing model combination:
- If required, load market prices and FX spot rates into the LUSID Quote Store. See how to do this.
- If required, load complex market data (such as discounting curves and volatility surfaces) into the LUSID Complex Market Data Store. See how to do this.
By default, you must load one discrete item of market data per category for each day in the valuation schedule. Also by default, each item must be loaded with an effective at timestamp within a day prior to the valuation time; see the table below for details. Learn how to change the validity period.
|Example valuation date||Example valuation time||Default validity period for market data item|
|Begin timestamp||End timestamp|
|7 March 2022||00:00:00|
Step 5: Create a recipe
- Construct one market data rule in your recipe for each category of market data you must locate in an appropriate LUSID store. See how to do this.
- For each non-equity instrument type whose pricing model you want to change, construct one vendor model rule in your recipe declaring the model and setting options. See how to do this.
Step 6: Decide which metrics to report
LUSID can report hundreds of metrics concerning almost any aspect of the valuation process.
We recommend you evaluate which metrics are useful or valid to report for each instrument type and pricing model combination. See how to do this.
Step 7: Choose whether to group and aggregate metrics
You can group results by particular metrics, and then aggregate grouped values to create a meaningful valuation report. See how to do this.
If you choose not to group, one result is reported per holding. This may mean multiple results are reported for holdings in the same underlying instrument if they are divided into tax lots or strategies. Similarly, legs of instruments such as FxForwards may be reported separately (depending on how they were booked).
Step 8: Choose which valuation method to use
- Call the
GetValuationAPI to value one or more transaction portfolios or a portfolio group. Alternatively, you can use the LUSID web app.
- Call the
GetValuationOfWeightedInstrumentsAPI to value notional quantities of arbitrary instruments.