Companies and Entities

Top ↑

A company tree is defined by a company and its entities (and each entity’s trade portfolios). This can be used for instance to represent a client account and its funds, or a bank’s business unit and its trading desks.

At company level, you can define company’s default valuation settings and preferred valuation data providers. These can also be overriden at entity level.

Once the company tree has been defined, you can create portfolio(s) which will hold the trades whose details can be used for PV calculation or valuation data anomaly detection.

Xplain offers two pre-configured options - ‘BLUESTONE’ and ‘LONDON_FICC’ - which are available as off-the-shelf to use when performing your valuations or valuation data anomaly detection. For more details, please refer to our sandbox environment page.

Company Tree Example

You can use the predefined ‘LONDON_FICC’ company (with its ‘RATES_DESK’ entity), or define your own independently. This page will guide you through the process using an example: defining a ‘NEWCOMP’ with a ‘NEWENT’ that replicates ‘LONDON_FICC/RATES_DESK/’. This will be used with the ‘NEWPORTFOLIOexample. You can download the example *.CSV_ data import files here.

On this page, we will discuss how to:

  • define a company tree
  • define company’s default settings for valuation and valuation data provider (*)

(*) Defining valuation data providers is only relevant for the purpose of valuation data anomaly detection.

Company Tree Definition

The three steps required to define a company tree are as follows:

  1. create a company
  2. add entities
  3. upload documentation, e.g. ISDA master agreement or SLA (optional)

1. Creating a Company

Under Portfolios/Company List, at the company list level, you can create a company either manually or by importing the definition data.

Case 1: Manually Creating a Company

To manually create a company, click on Add New (or edit an existing one by double-clicking on the line item).

Creating a Company
Portfolios/Company List
Alt for image
Case 1: After clicking on Add New and setting Name = NEW COMPANY LONG NAME and Company ID = NEWCOMP, and unselecting Shared between teams
Alt for image

Case 2: Importing a Company

To import a company (or a list of companies), click on and select the relevant company list definition .CSV import file.

You can download the import file template here .

Case 2: After clicking on Import / Import Companies and selecting the relevant company file - Versioning options
Alt for image
Case 2: After clicking on Import
Alt for image

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

2. Adding an Entity

Under Portfolios/Company List, at the company list level, you can create companies either manually or by importing the definition data.

Case 1: Manually Creating an Entity

Under Portfolios/Company List, at the company level, under ENTITIES, you can create an entity by clicking on Add New (or edit an existing one by double-clicking on the line item).

Creating an Entity
Portfolios/Company List/NEWCOMP/Entities
Alt for image
Case 1: After clicking on Add New, setting Name = NEW ENTITY LONG NAME and Company ID = NEWENT, and unselecting Shared between teams
Alt for image

Case 2: Importing an Entity

To import a company (or a list of companies), click on and select the relevant company list definition .CSV file.

You can download the import file template here .

Case 2: After clicking on Import / Import Entities and selecting the relevant entity file - Versioning options
Alt for image
After clicking on Import
Alt for image

A description of an entity’s attributes and corresponding permissible values are set out in the table below.

3. Uploading Documentation

Under Portfolios/Company List, at the company level, under DOCUMENTATION, you can upload documentation for the company by clicking on Add New. This documentation (with a maximum size of 100MB) will be stored for information purposes only.

Uploading documentation
Portfolios/Company List/DEMOCOMP/Documentation
Alt for image
After clicking on Add New
Alt for image
After clicking on Upload, selecting the relevant documentation and clicking on Save
Alt for image

Company's Default Settings

There are two types of default settings that can be defined at company level:

  1. company’s default valuation settings
  2. company’s default valuation data provider settings

Default valuation settings includes preferred:

They will automatically be applied when valuing trades prior to running a valuation data anomaly detection.

However, you can override them prior to running a manual PV calculation.

Default valuation data settings, which are only relevant for the purpose of valuation data anomaly detection, comprise SLA deadline time and, on a trade type basis, preferred valuation data group(s) and data providers (primary, secondary, tertiary and quaternary, as applicable).

Entity settings are inherited from the parent company, but they can be overriden at entity level.

Part of our ‘NEWCOMPexample that replicates ‘LONDON_FICC’, this section will guide you through the process of defining default settings at company and entity level.

1. Company’s Default Valuation Settings

Under Portfolios/Company List, at the company level, under Default Settings, in Company Valuation Settings, you can define the default valuation settings by clicking on Edit.

Defining a Company's default valuation settings
Portfolios/Company List/NEWCOMP/Default Settings/Company Valuation Settings
Alt for image

Xplain’s global valuation settings, which are defined under Preferences/Valuations/Default Valuation Settings, are inherited at company level, but can be overridden in the Valuation Settings dropdown by selecting ‘Company Bespoke Settings’.

After clicking on Edit, setting Valuation Settings = Company Bespoke Settings, Market Data Group = NEW Market Data GROUP and Curve Configuration = LONDON
Alt for image
After clicking on Save - Versioning options
Alt for image
After clicking on Save
Alt for image

2. Company’s Default Valuation Data Provider Settings

Under Portfolios/Company List, at the company level, under Default Settings, in Company Valuation Data Provider Settings, for valuation data data cleansing, you can specify the applicable valuation data group and valuation data providers on a trade type basis, by clicking on Edit.

Defining a Company's default valuation data provider settings
Portfolios/Company List/NEWCOMP/Default Settings/Company Valuation Data Provider Settings
Alt for image

The Default Provider can be used to populate primary to quaternary provider settings using the Apply Default dropdown.

After clicking on Edit, setting Valuation Data Group = NEW VD GROUP to default, and XPLAIN and ICE as the Primary and Secondary Data Providers respectively
Alt for image
After clicking on Save - Versioning options
Alt for image
After clicking on Save
Alt for image

3. Entity's Default Settings

Entity’s settings are inherited by default from the parent company.

Under Portfolios/Company List, at the company level, under Entities, at the entity level, you can override valuation settings by defining Valuation Settings as ‘Entity Bespoke Settings’ and valuation data provider settings by defining Settings as ‘Entity Valuation Data Provider Settings’ (instead of ‘Company Valuation Settings’ and ‘Company Valuation Data Provider Settings’).

Defining an Entity's default valuation settings
Portfolios/Company List/NEWCOMP/NEWENT/ENTITY Default Settings
Alt for image
Defining an Entity's default valuation data provider settings
Portfolios/Company List/NEWCOMP/NEWENT/Entity Valuation Data Provider Settings
Alt for image

Related Docs

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