question

Upvotes
Accepted
20 10 17 39

How to get the historical changes of constituents of a RIC chain, via DSS (or API)?

For example, for 0#.DJI, I would like to know the historical changes of the constituents, i.e., when a constituent was added and removed precisely?

historicalchain-ricconstituents
icon clock
10 |1500

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

Upvotes
Accepted
87.5k 294 53 79

@Frederic

You can use the Search/HistoricalChainResolution endpoint to resolve current and past chain constituents given a Chain RIC. Instruments may be currently active, or inactive 'historical only' instruments.

For example, the request is:

{
  "Request": {
    "ChainRics": [
      "0#GC:"
    ],
    "Range": {
      "Start": "2022-03-27T00:00:00.000Z",
      "End": "2022-03-28T00:00:00.000Z"
    }
  }
}

The output contains:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.HistoricalChainInstrument)",
    "value": [
        {
            "Identifier": "0#GC:",
            "IdentifierType": "ChainRIC",
            "Source": "",
            "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwwI0dDOnw",
            "Description": "Historical Chain",
            "InstrumentType": "Unknown",
            "Status": "Valid",
            "Constituents": [
                {
                    "Identifier": "GCG3",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxHQ0czfA",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
                {
                    "Identifier": "GCH2",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxHQ0gyfA",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
                {
                    "Identifier": "GCJ2",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxHQ0oyfA",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
icon clock
10 |1500

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

Upvotes
87.5k 294 53 79

@Frederic

I think you mean Leavers & Joiners, as shown in Eikon.

1647249902747.png

I checked the old cases and found that this data is not available in DSS or RTH.

“data in eikon leavers / Joiners is based on the Index and constituent level data” and “We don’t cover this data in RTH which is at equity level.”

You can contact the DSS or RTH support team directly via MyRefinitiv to confirm it.



1647249902747.png (32.7 KiB)
icon clock
10 |1500

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

Thanks. Also is that possible to extract the historical updates/changes on the chain constituents of the futures chain RIC 0#GC: ?

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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