Getting error for TR.IndexJLConstituentRIC data item

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.

Tagged:

Answers

  • Jirapongse
    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.

  • Hi @Zeeshan.Siddiq ,

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

  • 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
    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)
    
    image.png

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

  • 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
    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
    Jirapongse ✭✭✭✭✭

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

    image.png