Joiners and Leavers cancelling out

ricardo.henriquez

I want to recreate the historical constituents for the S&P 100 (taking into consideration joiners and leavers). For that matter, I am requesting the constituents from 2017 and the list of joiners and leavers using Python.

To get the constituents starting in 2017.

#Get SP Constituents in 2017

sp100_rics, err = ek.get_data(
    instruments = ['.OEXA'],
    fields = ['TR.IndexConstituentRIC',
              'TR.IndexConstituentName'],
    parameters = {
        'SDate':'2016-12-31'
    }
)

To get the list of joiners and leavers.

sp100_lj, err=ek.get_data('.OEXA', 
            ['TR.IndexJLConstituentChangeDate',
             'TR.IndexJLConstituentRIC.change',
             'TR.IndexJLConstituentRIC'],
            {'SDate':'0D', 'EDate':'-7Y', 'IC':'B'})

However from the list of joiners and leavers, I am getting strange values of the same instrument joining and leaving the index in two consecutive days.

sp100_lj.head(15)

For example, the case for VLT0.N, GEHC.OQ, CEG.OQ.. and so on.

Are this valid data references, or some sort of cancelled inclusion in the index?

I get the same values getting the table file from Workspace.

raksina.samasiri

Hi @ricardo.henriquez,

The resolution provided in the ticket is as below.

As per our checks , We can confirm Leavers and Joiners of S&P 100 Index <.OEXA> is correct as per source on Eikon .

The constituent VERALTO CORP ORD <VLTO.N> was joined on 02 Oct 2023 to the index and left the index on 03 Oct 2023. This was as per the Source( S&P) corporate actions.
These changes are correctly available on Eikon LJ Page. In case of Corporate actions like Spinoff, Mergers and Acquisitions, there is chance of Company is adding to an Index and dropping from the index , consecutive day.