Getting error for TR.IndexJLConstituentRIC data item

Zeeshan.Siddiq

Over the weekend, the outputs to TR.IndexJLConstituentRIC are no longer accessible and produce an LDError, such as "LDError: Unable to collect data for the field 'TR.INDEXJLCONSTITUENTRIC.CHANGE' and some specific identifier(s)."

Please have this looked into at the earliest and provide an update.

Jirapongse

@Zeeshan.Siddiq

Thank you for reaching out to us.

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

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. 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.

You may try to replicate this issue on the LSEG Workspace Excel by using the same RICs, fields, and parameters.

raksina.samasiri

Hi @Zeeshan.Siddiq ,

Sorry for an inconvenient, could you please provide the sample instruments used for further investigation.

Zeeshan.Siddiq

Sample identifier <.FTSE>

Below is the script for your reference:

ld.get_history(
universe=[".FTSE"],
fields=[
"TR.IndexJLConstituentRIC",
"TR.IndexJLConstituentRIC.change"
],
parameters={"SDATE": "2024-05-01", "EDATE":"2024-06-01", 'IC': 'B'}
)

Jirapongse

@Zeeshan.Siddiq

I got the same error in the LSEG Workspace Excel with the following formula.

=@RDP.Data(".FTSE","TR.IndexJLConstituentRIC;TR.IndexJLConstituentRIC.change","IC=B SDate=2024-05-01 EDate=2024-06-01 CH=Fd RH=IN",B2)

Please contact the content support team to verify what the problem is.

Zeeshan.Siddiq

Hi @Jirapongse,

Got confirmed with our product specialists that the below formula is working on Excel and showing the details.

=@RDP .Data(".FTSE","TR.IndexJLConstituentRIC(IC=B)","SDate=2024-05-01 EDate=2024-06-01 CH=Fd RH=IN;change")

But in CODEBOOK its blank.

Please have this further investigated and help fix the issue at the earliest.

Jirapongse

@Zeeshan.Siddiq

The question is about this field: TR.INDEXJLCONSTITUENTRIC.CHANGE.

"LDError: Unable to collect data for the field 'TR.INDEXJLCONSTITUENTRIC.CHANGE' and some specific identifier(s)."

Did the following formula work on your Excel?

=@RDP.Data(".FTSE","TR.IndexJLConstituentRIC;TR.IndexJLConstituentRIC.change","IC=B SDate=2024-05-01 EDate=2024-06-01 CH=Fd RH=IN",B2)

Jirapongse

The original code works fine with the TR.IndexJLConstituentRIC field.