Joiners/Leavers for Index Constitutes not equal

Gina

Hello all,

running the code from Building historical index constituents | Devportal to access STOXX600 constitutes result in partly >600 constitutes as Leaver/Joiners for one day do not even out. How to solve this issue? For sure, it would be a solution to run get_constituents_as_of for every today, however, this is quite API-request intense.

Thank you in advance!

Jirapongse

@Gina

Thank you for reaching out to us.

I tested the following formula in the Workspace Excel.

=@RDP .Data(".STOXX","TR.IndexJLConstituentChangeDate;TR.IndexJLConstituentRIC;TR.IndexJLConstituentName;TR.IndexJLConstituentituentChange","IC=B SDate=2018-06-18 EDate=2018-06-27 CH=Fd RH=IN",B2)

The output is same as the output from the API.

This could be a content issue. Please contact the helpdesk support team directly via LSEG Support to verify the content and formula.