Determine Index constituents from Joiners & Leavers

Question

question

auth

3 ●3 ●4 ●4

Determine Index constituents from Joiners & Leavers

Hi there,

I am currently trying to stitch together historical index constituents from joiners and leavers data. To get the data, I am using the command:

lj, err = ek.get_data(RIC, ['TR.IndexJLConstituentChangeDate(SDate={0},EDate={1},IC=B)'.format(start_date, end_date,'TR.IndexJLConstituentChangeDate(SDate={0},EDate={1},IC=B).change'.format(start_date, end_date,'TR.IndexJLConstituentName(SDate={0},EDate={1},IC=B)'.format(start_date, end_date, 'TR.IndexJLConstituentRIC(SDate={0},EDate={1},IC=B)'.format(start_date, end_date)])

To test this, I am using the HDAX as a test case '0#.GDAXHI'.

Now from this data, the goal is to find the current index constituents at any given time. I thought I can just refer to the RICs and filter the latest joiner RICs, which are not leavers yet. However, I am struggling a bit with the data that I am getting back. For instance, the company 'Salzgitter Werke', has joined the index early on, and the left twice, but based on a different RIC. (so it seems I cannot use RICs for this exercise, cause the RIC KLKG.F^A11 never left according to this)

In general I see many joiners and leavers at the same date, with changed tickers (example here)

So my question, based on this data: how do I back out the list of index constituents at any given date using only joiners and leavers data?

Many thanks.

Best,

Chris

eikon-data-api index constituents

1638806945050.png (31.9 KiB)

1638807050611.png (6.5 KiB)

Dec 06, 2021 at 04:14 PM

10 |1500

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

Jirapongse Dec 15, 2021 at 06:28 AM

@auth

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

auth Jirapongse Dec 15, 2021 at 08:37 AM

Hi there,

unfortunately not, no. It seems that there are ticker changes in this dataset that make it somehow unusable on its own I feel.

I am still discussing this with the content team, but if the ticker changes are not updated across the dataset, I cannot see why this data is any useful?

For instance, if KLKG.F^A11 is just changed to KLKG.DE^A11 and previously left untouched, it looks like the former is never leaving. How do people (or internally at Refinitiv?) use this dataset at all then as a standalone?

wasin.w auth Dec 22, 2021 at 07:09 AM

Hello @auth

Please be informed that we are not the content expert, so I recommend you contact the content team directly to help you with these content questions.

Show more comments

wasin.w Jan 20, 2022 at 09:39 AM

Hello @auth

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,

AHS

wasin.w Jan 27, 2022 at 11:04 AM

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

Answer 1 · 2022-01-13T09:17:24Z

Jirapongse

78.8k ●249 ●52 ●74

@auth

I think the data from Eikon Data API is similar to the data from the Eikon Leavers and Joiners.

This is why you need to contact the content team regarding how to process the data.

Another API that can retrieve historical items in indices is Tick History REST API.

Tick History REST API has the HistoricalChainResolution endpoint which can resolve current and past chain constituents.

For example, the request looks like this:

{
  "Request": {
    "ChainRics": [
      "0#.GDAXHI"
    ],
    "Range": {
      "Start": "2001-01-12T00:00:00.000Z",
      "End": "2001-01-13T00:00:00.000Z"
    }
  }
}

The response is:

                },
                {
                    "Identifier": "SRZG.DE",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxTUlpHLkRFfA",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
                {
                    "Identifier": "SZUG_p.DE",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxTWlVHX3AuREV8",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
                {
                    "Identifier": "TAGG.DE",
                    "IdentifierType": "Ric",
                    "Source": "",
                    "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxUQUdHLkRFfA",
                    "Description": "Historical Instrument",
                    "InstrumentType": "Unknown",
                    "Status": "Valid",
                    "DomainCode": "6"
                },
                {

1642064803063.png (12.6 KiB)

1642064897016.png (22.7 KiB)

Jan 13, 2022 at 09:17 AM

10 |1500

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

Answer 2 · 2021-12-07T13:58:29Z

raksina.samasiri

14.2k ●30 ●5 ●10

Hi @auth ,

In case you'd like to get the list of index constituents at any given date, you may put the date parameter after the RIC, for example

df1, err = ek.get_data('0#.GDAXHI(19980324)', 
            ['TR.RIC','TR.CompanyName'])
df1

You may get the date when there're any leavers/joiners and use the code above to get the constituents list at any date.

hope this could help

1638885197698.png (28.7 KiB)

Dec 07, 2021 at 01:58 PM

10 |1500

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

auth Dec 07, 2021 at 03:13 PM

Hi @raksina.samasiri

Many thanks for your answer. I am aware that I can do this though. Reason why I am asking is because for my needs, it is much easier and less data intensive to build the list of tickers for each index from Joiners/Leavers, rather than having to pull the entire list each time there is an update.

I am sure it must be possible to reconstruct the list with your command, with the Joiners/Leavers data, I just haven't figured it out yet. Any help would be much appreciated...

Best,

Chris

raksina.samasiri Dec 08, 2021 at 07:50 AM

Hi @auth ,

This forum is dedicated to software developers using Refinitiv APIs. The moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.

The best resource for the content questions is the Eikon support team, which can be reached by submitting queries through MyRefinitv. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

However, in this case, I open the case number 10755576 on behalf of you and the support team is going to contact you soon for the explanation and the suggestion (if any other field can be used in your use case)

Q&A Forum

question

Determine Index constituents from Joiners & Leavers

2 Answers

Write an Answer

question

Determine Index constituents from Joiners & Leavers

2 Answers

Write an Answer

Related Questions