Valuation Data Cleansing Results

Top ↑

At any point in a valuation data XM workflow, you can:

  1. view cleaned valuation data “as-you-go” on a VDK basis (*)
  2. manually override those cleaned valuation data, subject to evidence being uploaded (as it will impact the final reported numbers)
  3. access Xplain’s PV Calculation results, if Xplain is one of the valuation data providers (**)

(*) Cleaned valuation data (i.e. with status 'VERIFIED') will be published "as-you-go", i.e. immediately if there is no break, or as soon as any applicable break has been resolved and approved.
(**) When Xplain is one of the valuation data providers (as part of a valuation data XM workflow), once a single overlay market data has been identified (as part of the market data XM workflow on the relevant market data group), only overlay market data will be used in the valuation calculations. Otherwise, Xplain will use raw market data as the fallback.

From the dashboard, you will be able to select and re-run any sub-stream of a valuation data break clearing phase.

After saving a valuation data dashboard, XM VD results will be accessible on a trade level in the trade valuation history window.

1. Viewing Valuation Data XM Results

Under Data Cleansing/Valuation Data/Valuation Data Dashboard, you can view and export the valuation data XM results “as-you-go” in the ‘Valuation Data XM Results’ window, either:

  • on a portfolio basis (by selecting the relevant portfolio in the ‘PORTFOLIO STATS’ tab)
  • on a combined basis across all portfolios (by selecting the ‘All XM Results’ tab)
Viewing valuation data XM results
Data Cleansing/Valuation Data/'COB LONDON' XM DASHBOARD for 'NEWCOMP'
Alt for image

Valuation Data XM Results on a Portfolio Basis

In the ‘PORTFOLIO STATS’ window, you can view and export valuation data XM results or access Xplain’s PV calculations for a given portfolio, by clicking first on the relevant icon (on the right hand side of the window).

Viewing valuation data XM results
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/Portfolio Stats
Alt for image
After clicking on the 'Data Cleansing - Valuation Results' icon
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/Portfolio Stats/XM Results
Alt for image

The valuation data XM results will include a subset of each trade’s details, as well as the final valuation summary, as set out in the table below.

Field Name Description Permissible Values
PV (Calculation Currency) The final trade valuation following the VD XM workflow, expressed in the calculation currency Numeric
Calculation Currency The currency in which valuation data are expressed The Trade Currency or the Reporting Currency, as applicable
Valuation Data Provider Name The data provider associated to the data source of the final trade valuation An existing valuation data provider
Overlay Source The data source of the final trade valuation Primary (P1) | Secondary (P2) | Tertiary (P3) | Quaternary (P4) | Accounting cost | Deal cost | Manual | Multiple | Do not price

Valuation Data XM Results on a Combined Basis Across All Portfolios

In the ‘All XM Results’ tab, you can view and export valuation data XM results for all portfolios combined, including a subset of each trade’s details, as well as the final valuation summary. In our example, we only have one portfolio so the output will be the same as the one that you can access from the ‘PORTFOLIO STATS’ window, as described above.

Where Xplain is one of the valuation data providers, in the ‘All XPLAIN Results’ tab, you can access Xplain’s PV calculation results for all portfolios combined.

Viewing All Valuation Data XM Results
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/All XM Results
Alt for image

2. Overriding Valuation Data XM Results

Under Data Cleansing/Valuation Data/Valuation Data Dashboard, in the ‘Valuation Data XM Results’ window, at the ‘XM Results’ level, once a valuation data has been cleaned (i.e. with a ‘VERIFIED’ status), you can manually override it, subject to evidence being uploaded (as it will impact the final reported numbers).

For the purpose of this example, a dummy evidence file can be downloaded here

After selecting the trade(s) whose valuation needs to be overriden
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/XM Results
Alt for image
After clicking on OVERRIDE Valuation
Alt for image
After clicking on Upload, uploading the evidence file, inputting the new value and writing a comment
Alt for image
After clicking on Apply OVERRIDE
Alt for image
After confirming by clicking on Apply OVERRIDE
Alt for image

3. Accessing Xplain PV Calculation Results

Under Data Cleansing/Valuation Data/Valuation Data Dashboard, in addition to be able to view and export valuation data XM results “as-you-go”, you can also access Xplain’s PV calculation results in the ‘Valuation Data XM Results’ window, either:

  • on a portfolio basis (by selecting the relevant portfolio in the ‘PORTFOLIO STATS’ tab)
  • on a combined basis across all portfolios (by selecting the ‘All XPLAIN Results’ tab)

Xplain’s calculations will be available only if Xplain is one of the valuation data providers.

Viewing Xplain PV calculation results
Data Cleansing/Valuation Data/'COB LONDON' XM DASHBOARD for 'NEWCOMP'
Alt for image

Xplain PV Calculation Results on a Portfolio Basis

In the ‘PORTFOLIO STATS’ window, you can view and export valuation data XM results or access Xplain’s PV calculations for a given portfolio, by clicking first on the relevant icon (on the right hand side of the window).

Accessing Xplain's PV calculations
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/Portfolio Stats
Alt for image
After clicking on the 'Xplain Valuation Results' icon
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/Portfolio Stats/Xplain Results
Alt for image

This are the same results as the ones you would get following a portfolio PV calculation in Xplain on a standalone basis, i.e. not part of a VD XM workflow.

Xplain PV Calculation Results on a Combined Basis Across All Portfolios

In the ‘All XPLAIN Results’ tab, where Xplain is one of the valuation data providers, you can access Xplain’s PV calculation results for all portfolios combined. In our example, we only have one portfolio so the output will be similar to the one that you can access from the ‘PORTFOLIO STATS’ window, as described above, but without the portfolio metrics.

After clicking on the 'Xplain Valuation Results' icon
Data Cleansing/Valuation Data/NEWCOMP DASHBOARD/All Xplain Results
Alt for image

Break Clearing - Valuation Data Approver
Trade Onboarding
Introduction to Xplain
Curves
Portfolios
Data
Valuations
Data Cleansing
Preferences
Admin
Importing and Versioning
XVA Module
TRS Module