Constituents of an equity index?

iwasaki

Can anyone tell me why it returns an error? Are there indices that are compatible with 0# notation and those are not? Is there something wrong in my code? How can I see the list of all the constituents of an index?

import lseg.data as ld
ld.open_session()

This one works.

str_test = "0#.TSPM"
l_field_test = ['TR.RIC']
ld.get_data(str_test, fields=l_field_test)

This one returns an error.LDError: Unable to resolve some identifier(s). Requested universes: ['0#.SPADR']. Requested fields: ['TR.RIC']

str_test = "0#.SPADR"
l_field_test = ['TR.RIC']
ld.get_data(str_test, fields=l_field_test)

Jirapongse

@iwasaki

Thank you for reaching out to us.

You need to contact the helpdesk team via LSEG Support to verify that the TR.RIC field doesn't work with the 0#.SPADR RIC. The following formula also doesn't work in the Workspace Excel.

=@RDP.Data("0#.SPADR","TR.RIC","CH=Fd RH=IN",H2)

0#.SPADR is a chain RIC so you can use the Chain method in the LSEG Data Library for Python to expand chains.

chain = Chain("0#.SPADR")
print(chain.constituents)

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.