Leavers/Joiners on Index constituents.

Question

question

aquilesjlp300

98 ●27 ●33 ●35

Leavers/Joiners on Index constituents.

I would like to find companies who left or joined an index within an specific timestamp but I'm not sure I'm getting at it correctly.

I've tried this on Excel (assuming it also works in Python):

=TR(".TRXFLDGLPU","TR.IndexJLConstituentRIC;TR.IndexJLConstituentRIC.date;TR.IndexJLConstituentRIC.change","CH=Fd RH=IN",P3)

And I get an outcome, but only for a single company.

However, if I play with the date range of the TR formula, I get NULL values.

If I wanted to get the joiners/leavers for, let's say 5 years, how I would need to do so?

Thanks in advance for any help.

eikon eikon-data-api python refinitiv-dataplatform-eikon workspace workspace-data-api index

1608159877642.png (3.1 KiB)

Dec 16, 2020 at 11:01 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.

Answer 1 · 2020-12-16T23:41:31Z

Alex Putkov.1

39.4k ●77 ●11 ●27

You need to add SDate and EDate parameters to your request.
The constituents of this index change a lot. In the last 3 months there were ~2400 changes. To retrieve all the joiners and leavers for the last 5 years you'd need to break the retrieval into several requests. Here's an example retrieving joiners and leavers for the last 3 months

ek.get_data('.TRXFLDGLPU', 
            ['TR.IndexJLConstituentChangeDate',
             'TR.IndexJLConstituentRIC.change',
             'TR.IndexJLConstituentRIC'],
            {'SDate':'0D', 'EDate':'-3M', 'IC':'B'})

Dec 16, 2020 at 11:41 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.

aquilesjlp300 Dec 17, 2020 at 02:04 AM

Thank you Alex!

Q&A Forum

question

Leavers/Joiners on Index constituents.

1 Answer

Write an Answer

question

Leavers/Joiners on Index constituents.

1 Answer

Write an Answer

Related Questions