Market Data

Top ↑

Market data are (daily) market values associated for instance to a curve node (e.g. 10Y USD SOFR swap) or to a volatility point (e.g. 5Y into 10Y ATM swaption volatility for USD SOFR). They will be stored in a market data group (as described below) and will be required when defining a market data environment.

On this page, we will discuss how to upload data in ther relevant market data environment, including:

Market Data Group Example

You can use for example the predefined ‘COB LONDON’ market data group, or define your own independently. This page will guide you through the process using an example: defining a ‘NEW Market Data GROUP’ that replicates ‘COB LONDON’. You can download the example .CSV data import files here.

Market Data Groups

A market data group comprises raw market data from various providers including:

  • Quotes for curve nodes and FX Rates
  • Volatility points and skew data for IR and FX
  • Credit spreads for credit curve nodes (CDS and index)
  • Bond yield nodes

The two steps required to upload market data are as follows:

  1. Create a market data group
  2. Upload market data

Permissible values for market data can be found on the Market Data Permissible Values page.

1. Creating a Market Data Group

Under Data/Market Data/Market Data Groups, at the market data group list level, you can create a market data group by clicking on Add New (or edit an existing one by double-clicking on the line item).

Creating a Market Data Group
Data/Market Data/Market Data Groups
Alt for image
After clicking on Add New,
setting Name = NEW Market Data GROUP,
setting Pricing Slot = LDN COB,
unselecting Shared between companies and Shared between teams
Alt for image
After selecting Shared between companies and Shared between teams, and clicking on Save
Alt for image

A description of a market data group’s attributes and corresponding permissible values are set out in the table below.

Field Name Description Permissible Values
Name The name of the market data group Free text
Pricing Slot The pricing slot associated with the market data group (optional) See permissible pricing slot values
Shared between companies Whether the market data group will be accessible across all companies Boolean
Companies The company(ies) that will have access to the market data group
Applicable only if Shared between companies = FALSE
Any existing company
See company configuration
Shared between teams Whether the market data group will be accessible across all teams Boolean
Teams The team(s) that will have access to the market data group
Applicable only if Shared between Teams = FALSE
Any existing team(s)
See creating a team

2. Uploading Market Data

Under Data/Market Data, inside the market data group, you can add market data, either manually or by importing the definition data. Market data whose ticker cannot be mapped to an instrument via an MDK will be flagged as “UNRESOLVED Market Data”.

Case 1: Manually adding Market Data
To manually add market data to your market data group, click on Edit, then on Add New (or edit an existing one by double-clicking on the line item).

Adding a market data Data/Market Data/Market Data Groups/NEW Market Data GROUP
Alt for image
Case 1: Adding a market data after clicking on Edit
Data/Market Data/NEW Market Data GROUP
Alt for image
Case 1: After clicking on Add New, inputting Provider = ICAP, Date = 2022-11-30, Ticker = GBPOIS_10Y and Value = 3.755
Alt for image
Case 1: After clicking on Save - Add comment
Alt for image
Case 1: After clicking on Save
Alt for image
Case 1: After clicking on < BACK (or refresh the page) to exit the Edit mode
Alt for image

Case 2: Importing Market Data

To import market data, click on (import) and select the relevant market data list definition .CSV import file.

You can download the import file template here .

Case 2: After clicking on Import and selecting the relevant market data list file - Versioning options
Alt for image
Case 2: After clicking on Import
Alt for image

A description of a market data’s attributes and corresponding permissible values are set out in the table below.

Field Name Description Permissible Values
Provider The raw market data’s provider Any existing data provider
See data
Date The raw market data’s historical curve date YYYY-MM-DD (ISO 8601)
Ticker The raw market data’s ticker Free text (e.g. EURUSDV1Y)
Bid/Mid/Ask The market data side Bid | Mid | Ask
Value The raw market data’s historical value (unscaled) Numeric

Uploading Fixings

Under Data/Fixings, you can upload fixings, either manually or by importing the definition data. Fixings for the relevant projection indices will apply globally (i.e. not specifically to a given curve configuration).

Case 1: Manually Uploading Fixings

To manually add fixings, click on Add New (or edit an existing one by double-clicking on the line item). The upload process is similar to the one for market data.

Case 2: Importing Fixings

To import fixings, click on (import) and select the relevant fixings list definition .CSV import file.

You can download the import file template here .

Importing or uploading fixing rates
Data/Market Data/Fixings
Alt for image
After clicking on Add New
Alt for image

A description of a fixing rate’s attributes and corresponding permissible values are set out in the table below.

Field Name Description Permissible Values
Index The projection index Any projection index
See permissible indices
Value The fixing rate’s historical value Numeric
Date The fixing rate’s historical date YYYY-MM-DD (ISO 8601)
Publication Date (*) The date the fixing was published (only applicable to inflation fixings) YYYY-MM-DD (ISO 8601)

(*) For inflation fixings, the publication date can be set to record when the fixing was published. When extracting fixings for historical inflation seasonality factor calculation and curve calibration, inflation fixings with a publication date after the valuation date will be ignored.


Introduction to the Data Menu
Valuation Data
Introduction to Xplain
Curves
Portfolios
Data
Valuations
Data Cleansing
Preferences
Admin
Importing and Versioning
XVA Module
TRS Module