How can I return the Exchange Code for a constituent instrument ric using the Search/HistoricalChain

sherry.medrano

I am using this API code for HistoricalChain Search but unable to get the Source/Exchange code. What is the reason? Product is Tick History

https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/HistoricalChainResolution

{
"Request": {
"ChainRics": [
"0#.KQ150"
],
"Range": {
"Start": "2023-01-31T00:00:00.000Z",
"End": "2023-01-31T23:59:59.000Z"
}
}
}

Output:

    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalChainInstrument)",    "value": [        {            "Identifier": "0#.KQ150",            "IdentifierType": "ChainRIC",            "Source": "",            "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwIy5LUTE1MHw",            "Description": "Historical Chain",            "InstrumentType": "Unknown",            "Status": "Valid",            "Constituents": [                {                    "Identifier": ".KQ150",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwuS1ExNTB8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "000250.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMDAyNTAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "003380.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMDMzODAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "005290.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMDUyOTAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "006730.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMDY3MzAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "007390.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMDczOTAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "015750.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMTU3NTAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"                },                {                    "Identifier": "016790.KQ",                    "IdentifierType": "Ric",                    "Source": "",                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwMTY3OTAuS1F8",                    "Description": "Historical Instrument",                    "InstrumentType": "Unknown",                    "Status": "Valid",                    "DomainCode": "6"

Gurpreet

Hello @sherry.medrano

For content questions such as these, please reach out to the product/content experts by opening a ticket at LSEG MyAccount.

sherry.medrano

https://community.developers.refinitiv.com/discussion/comment/123831#Comment_123831

Hi Gurpeet. I don't think this is Content issue. Because in GUI we can retrieve Exchange Code but in API this is not available. We should be seeing same output in GUI and API?

Gurpreet

@sherry.medrano,

There are a lot of other information-fields shown in the GUI, which are not returned as the part of chain resolution. The GUI is doing more then making a single call to chain instruments.

If you need this in the code - once you have a list of all the RIC's in the chain, your app can invoke the Terms and Conditions request to get the details about these instruments individually.

{
  "ExtractionRequest": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
    "ContentFieldNames": [
      "RIC", "Security Description", "SEDOL", "ISIN", "Exchange Code", "Currency Code", "PE Code", "Trade Date"
    ],
    "IdentifierList": {
      "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
          "Identifier": "000250.KQ",
          "IdentifierType": "Ric"
        }, {
          "Identifier": "003380.KQ",
          "IdentifierType": "Ric"
        }, {
          "Identifier": "005290.KQ",
          "IdentifierType": "Ric"
        },
        ...
      ],

      "ValidationOptions": {
        "AllowHistoricalInstruments": true,
        "AllowInactiveInstruments": true,
        "AllowOpenAccessInstruments": false
      },

      "UseUserPreferencesForValidationOptions": false
    }
  }
}

result:

RIC,Security Description,SEDOL,ISIN,Exchange Code,Currency Code,PE Code,Trade Date
000250.KQ,SAM CHUN DANG PH ORD,6510279,KR7000250001,KOE,KRW,4084,2025/01/29
003380.KQ,HARIM HOLDINGS ORD,BZ404M0,KR7003380003,KOE,KRW,4084,2025/01/29
005290.KQ,DONGJIN SEMICHEM ORD,6219297,KR7005290002,KOE,KRW,4084,2025/01/29
…

Again, we can only answer technical question on these developers forums. Helpdesk is the best resource for content clarifications.