How to filter various asset type based on the most primary market

Options
mhir
mhir Newcomer
in DSS

Hi,


I am using Refinitiv Data Scope Select API for in my project and want to filter out various asset types based on data received from Refinitiv.

<add key="ReutersWSRequestAllListings" value="true"/>

I have been using the above filter, for Refinitiv to send only One Silver copy for the instrument requested based on the fact that is traded on the most Primary Market .


No I need to disable this key and apply the filter manually . Can someone please help me determine the filter the is applied on the API when this key is set to "true".


Here is what I have for Bonds and Equities , would really appreciate if I can get this for various other asset types

if (Sources.Count(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && s.Composite.RIC.Contains("=RRPS")) > 0)
{
 return Sources.Where(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && s.Composite.RIC.Contains("=RRPS")).FirstOrDefault().AsEnumerable();
}
// Filter for Bonds to avoid filter Silver copy task
if (Sources.Count(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && s.Composite.RIC.Contains("=FINR")) > 0)
{
 return Sources.Where(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && s.Composite.RIC.Contains("=FINR")).FirstOrDefault().AsEnumerable();
}
// Filter for Equities to avoid filter Silver copy task
if (Sources.Count(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && !string.IsNullOrEmpty(s.Composite.PrimaryTradingRIC) && (s.Composite.RIC == s.Composite.PrimaryTradingRIC)) > 0)
{
 return Sources.Where(s => s.DataKind == ReutersRestWs_ReutersWsDataKind.Instrument && s.Composite != null && !string.IsNullOrEmpty(s.Composite.RIC) && !string.IsNullOrEmpty(s.Composite.PrimaryTradingRIC) && (s.Composite.RIC == s.Composite.PrimaryTradingRIC)).FirstOrDefault().AsEnumerable();
}


Regards

Irshad


Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Hello @mhir,

    From a developer's perspective, as I asked what request you were running, here is what I had in mind, depending on what you are doing with the request, in terms of approach, it may be worthwhile to proceed via Instrument search, and determine the instrument types of your instruments. For example:

    {{protocol}}{{host}}{{api}}Search/InstrumentSearch 
    {
      "SearchRequest": {
        "InstrumentTypeGroups": [
          "CollatetizedMortgageObligations",
          "Commodities",
          "Equities",
          "FuturesAndOptions",
          "GovCorp",
          "MortgageBackedSecurities",
          "Money",
          "Municipals",
          "Funds"
        ],
        "IdentifierType": "Ric",
        "Identifier": "US10YT=RRPS,JPY=,IBM.N, INVALID.RIC",
        "PreferredIdentifierType": "Ric"
      }
    }

    and the result will reflect the type of the valid:

    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Content.ValidatedInstrument)",
        "value": [
            {
                "Identifier": "IBM.N",
                "IdentifierType": "Ric",
                "Source": "NYS",
                "Key": "VjF8MHgwMDAzZGQwMDEzNzlkNDYwfDB4MDAwM2RjMDA0YTAyNGZkOHxOWVN8RVFRVXxFUVRZfE9EU0h8RXx8SUJNLk58MDA3Nw",
                "Description": "INTERNATIONAL BUSINESS MACHINES ORD",
                "InstrumentType": "EquityQuote",
                "Status": "Valid"
            },
            {
                "Identifier": "JPY=",
                "IdentifierType": "Ric",
                "Source": "RCT",
                "Key": "VjF8MHgwMDEwMGIwMDAzMGE5MDEyfDB4MDAwM2RjMDAzNDcyZjc2ZXxSQ1R8TU5RVXxNT05ZfE1PTll8WXx8SlBZPXwwMTQz",
                "Description": "US Dollar/Japanese Yen FX Spot Rate",
                "InstrumentType": "MoneyMarketQuote",
                "Status": "Valid"
            },
            {
                "Identifier": "US10YT=RRPS",
                "IdentifierType": "Ric",
                "Source": "EJV",
                "Key": "VjF8MHgwMDEwMmNlZTdlNmEyNWUzfDB4MDAxMDJjNjAzNDkxMjVkY3xFSlZ8R0NCRHxHT1ZUfEdCTkR8R3xOfFVTMTBZVD1SUlBTfEdPUlA",
                "Description": "UST    0.875 11/15/30 When Iss",
                "InstrumentType": "GovCorpBond",
                "Status": "Valid"
            }
        ]
    }

    Search is not subject to extraction quota.

    However, if you would like to determine the instrument type the way you discuss, from RIC name, we on the developers forum will not likely be of help, as the majority of this forum's members are Refinitiv API developers, the moderators are Refinitiv API experts.

    For a customer with content-specific question, the best approach is to directly post them with Refinitiv Content Helpdesk Online they may be able to better advise you on content, especially if you can point which analogous request on DSS GUI yields the same result set, the DSS content experts can help to identify the available filters, if that approach is effective.

    I hope this helps


Categories