Code Error

I tried import lseg.data as ld

import pandas as pd

import copy

import plotly.express as px

ld.open_session()

ric = '.AXJO'
start = '2014-01-01'
end = '2025-08-26'

df = ld.get_data(universe=[ric],fields =['TR.IndexJLConstituentRIC','TR.IndexJLConstituentChangeDate','TR.IndexJLConstituentituentChange'],
parameters={"SDATE":f"{start}","EDATE":f"{end}", 'IC':'B'})
df
It doesn’t work either. I definitely have S&P Australia and New Zealand access.

I am getting the below error

Please see the error message below

 

---------------------------------------------------------------------------

LDError                                   Traceback (most recent call last)

/tmp/ipykernel_535/735257641.py in <module>

     16 end = '2024-02-15'

     17

---> 18 df = ld.get_data(universe=[ric],fields =['TR.IndexJLConstituentRIC','TR.IndexJLConstituentChangeDate','TR.IndexJLConstituentituentChange'],

     19             parameters={"SDATE":f"{start}","EDATE":f"{end}", 'IC':'B'})

     20

 

/opt/conda/lib/python3.8/site-packages/lseg/data/_access_layer/get_data_func.py in get_data(universe, fields, parameters, header_type)

     85

     86     if can_use_eikon_approach:

---> 87         return _get_data_eikon_approach(universe, fields, parameters, header_type, session)

     88

     89     return _get_data(universe, fields, parameters, header_type, session)

 

/opt/conda/lib/python3.8/site-packages/lseg/data/_access_layer/get_data_func.py in _get_data_eikon_approach(universe, fields, parameters, header_type, session)

    136         exceptions.append(exception_msg)

    137

--> 138     raise_if_all(exceptions)

    139

    140     adc_data = ADCContainerEikonApproach(adc_raw, fields)

 

/opt/conda/lib/python3.8/site-packages/lseg/data/_access_layer/get_data_func.py in raise_if_all(exceptions)

     92 def raise_if_all(exceptions: List[str]):

     93     if exceptions and all(exceptions):

---> 94         raise LDError(message="\n\n".join(exceptions))

     95

     96

 

LDError: Unable to collect data for the field 'TR.INDEXJLCONSTITUENTRIC' and some specific identifier(s). Requested universes: ['.AXJO']. Requested fields: ['TR.INDEXJLCONSTITUENTRIC', 'TR.INDEXJLCONSTITUENTCHANGEDATE', 'TR.INDEXJLCONSTITUENTITUENTCHANGE']

[ ]:

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @AbdulSamad

    Thank you for reaching out to us.

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

    =@RDP .Data(".AXJO","TR.IndexJLConstituentRIC,TR.INDEXJLCONSTITUENTCHANGEDATE,TR.INDEXJLCONSTITUENTITUENTCHANGE","Sdate=2014-01-01 EDate=2025-08-06 CH=Fd RH=IN IC=B",B2)

    image.png

    However, it works fine with .FTSE.

    image.png

    This could be a content issue. Please contact the helpdesk team to verify this.

  • image.png

    =@RDP .Data(".AXJO","TR.IndexJLConstituentRIC,TR.INDEXJLCONSTITUENTCHANGEDATE,TR.INDEXJLCONSTITUENTITUENTCHANGE","Sdate=2014-01-01 EDate=2025-08-06 CH=Fd RH=IN IC=B",B2)

    By using the above formula, I am able to get data

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    Sorry. I can't get it. Is it about the permission?

    image.png
  • Client has the necessary permissions,

    I have double checked with entitlements teams also

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    You can ask the client to replicate this issue on the Workspace Excel.

    =@RDP .Data(".AXJO","TR.IndexJLConstituentRIC,TR.INDEXJLCONSTITUENTCHANGEDATE,TR.INDEXJLCONSTITUENTITUENTCHANGE","Sdate=2014-01-01 EDate=2025-08-06 CH=Fd RH=IN IC=B",B2)

    If the client can't retrieve the data, please contact the Excel support team to verify it.

  • I am checking with TECH team on this, thank you for advising