Overview

The compliance policy of financial institutions usually restricts purchasing or owning securities issued by companies (or their subsidiaries) which were underwritten by those financial institutions. This article demonstrates how we can use the DataScope Select .NET SDK to extract all associated securities for a list of legal entities.

Solution

We are going to use a csv file as an input, which will consist of three columns:

• security identifier type, ISN (ISIN), CSP (CUSIP) or SED (SEDOL);
• security identifier;
• description.

So, in our case, the file companies.csv will look like this:

This file will help us get the OrgID, a Refinitiv issuer identifier.

We are going to use the following DataScope Select templates:

• Terms and Conditions;
• EntityHierarchy.

So, we are going to establish a connection to DataScope Select, upload the companies.csv input file, get a list of OrgIDs for those instruments, then extract an entity hierarchy for each OrgID to get a list of associated OrgIDs and, finally, build a full list of all instruments associated with all entities.

Code

Prerequisites

In order to start working with the DataScope Select .NET SDK you will need to download the latest SDK, extract it, copy the following files into your solution folder and reference them in your IDE:

• Microsoft.OData.Client.dll
• Microsoft.OData.Core.dll
• Microsoft.OData.Edm.dll
• Microsoft.Spatial.dll
• Newtonsoft.Json.dll
• DataScope.Select.Core.RestApi.Common.dll
• DataScope.Select.RestApi.Client.dll

For more information on how to install the SDK have a look at the .Net SDK tutorial 1.

Authentication

Firstly, we need to establish a connection to DataScope Select host.

Reading the inputs

Once the connection to the host is established, our app will read the companies.csv file, parse it and create an InstrumentIdentifier list:

Extracting issuer OrgIDs

We are going to create a field array that is going to be used in the extraction of the Terms and Conditions template

Now we are going to use the DataScope Select object TermsAndConditionsExtractionRequest with the above field list to extract the issuer OrgIDs into issuerOrgIdAry:

Extracting entity hierarchy

We are going to use issuerOrgIdAry from the previous step in otder to create a company entity array:

Now, let's create a field array for this extraction:

So, all the preparation at this point is done. Let us use the DataScope Select object LegalEntityHierarchyExtractionRequest to create the associated identifier extraction:

Compiling a list of identifiers

Let us create one list for all related identifiers:

Extracting associated instruments

Next, let us use the TermsAndConditionsExtractionRequest object again extract to all instruments:

Results

Finally, display the results in the console:

Here is what our output will look like:

Conclusion

Automating similar routines with DataScope Select is quick and simple, offering you greater flexibility and is more efficient than the manual use of DataScope Select via the browser.