For a deeper look into our DataScope Select SOAP API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
9 0 1 3

How to make DSS API fetch the correct RIC from a list of 3?

I'm using DSS API dlls to fetch a list of Rics from a list of Isins.
However, the DSS API is fetching the first row from the list. But how to know if it is the right one?

My code:

var extractionRequest = new TermsAndConditionsExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(instrumentIdentifierList, null, false),
    ContentFieldNames = new[] { "RIC", "Trading Status" }
};

var extractedRows = ExtractionsContext.Extract(extractionRequest).ToArray();


What DDS API is fetching:


From Datascope Select:

In the list above, there are 3 RICs but the API is fetching only the first one.

Is this the right one?

How to know it?






dss-rest-apidatascope-selectdss
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
38.1k 69 35 53

@everton.solon

From my checking, BRBMEFBGI5M6 can be mapped to the following RICs: [BGIU20, 1BGIU20, 2BGIU20].

Refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article, TermsAndConditionsExtractionRequest can be used to retrieve a primary RIC for an ISIN.

To get all RICs for an ISIN, you need to use other endpoints, such as SearchContext.InstrumentSearch.

For example:

{
  "SearchRequest": {
    "InstrumentTypeGroups": [
      "CollatetizedMortgageObligations", "Commodities", "Equities", "Funds",
      "FuturesAndOptions", "GovCorp", "Money", "MortgageBackedSecurities",
      "Municipals"
    ],
    "IdentifierType": "Isin",
    "Identifier": "BRBMEFBGI5M6",
    "PreferredIdentifierType": "Ric"
  }
}

The above request returns:

 "value": [
        {
            "Identifier": "1BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MDc4OHxCTUZ8REVSVnxERVJWfEZVVHxEfHwxQkdJVTIwfDUwNTU",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        },
        {
            "Identifier": "2BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MGVjMHxCTUZ8REVSVnxERVJWfEZVVHxEfHwyQkdJVTIwfDU0MTg",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        },
        {
            "Identifier": "BGIU20",
            "IdentifierType": "Ric",
            "Source": "BMF",
            "Key": "VjF8MHgwMDEwMGIwMDFmNTYwNzg3fDB4MDAxMDBiMDAxZjU2MTA4YnxCTUZ8REVSVnxERVJWfEZVVHxEfHxCR0lVMjB8NTQxOA",
            "Description": "BGI OTFCTPL",
            "InstrumentType": "Derivative",
            "Status": "Valid"
        }
    ]

For more information, please refer to REST API Reference Tree.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
9 0 1 3

@jirapongse.phuriphanvichai


"Refer to the ISIN to RIC conversion with the DSS (DataScope Select) REST API article, TermsAndConditionsExtractionRequest can be used to retrieve a primary RIC for an ISIN."


Article:

"A TermsAndConditionsExtractionRequest delivers for each input ISIN the primary RIC (except if you specified the source, see next section). It is also possible to retrieve the currency and exchange code.

A single call suffices for multiple ISINs."


My code:

In the line below, I'm using TermsAndConditionsExtractionRequest as mentioned in this post.

var extractionRequest = new TermsAndConditionsExtractionRequest
{
    IdentifierList = InstrumentIdentifierList.Create(instrumentIdentifierList, null, false),//<- instrumentIdentifierList, validationOptions, useUserPreferencesForValidationOptions
    ContentFieldNames = new[] { "RIC", "Trading Status" }
};
 
var extractedRows = ExtractionsContext.Extract(extractionRequest).ToArray();

However, it is not fetching for the primary RIC.


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea