Issue with field PDOR_1 with LSEG Data API

I am attempting to get the previous date of release of an economic indicator EUECBR=ECI. On Workspace Quote page that field id PDOR_1. I am able to get the data for this field with Workspace Excel as well, however in Python API it gives me NA.

Can someone assist me with this please? I have attached relevant screenshots below:

Python LSEG Data API Result

image.png

Excel Workspace

image.png

Quote Page

image.png


Code to replicate on Python:

import lseg.data as rd
rd.open_session()
df = rd.get_data(
universe = ['EUECBR=ECI'],
fields = [
'ECON_ACT',
'ECON_PRIOR',
'PDOR_1',
]
)

print(df.to_string())


Please Note: This works properly with the refinitiv-data API but not the lseg-data API.

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @PrasadAcharya

    Thank you for reaching out to us.

    I found the following log when running the code.

    [2025-02-07T10:32:38.919418+07:00] - [sessions.desktop.workspace.0] - [DEBUG] - [70916 - MainThread] - [http_service] - [request] - HTTP Response id 2
    status_code = 200
    text = {"responses":[{"columnHeadersCount":1,"data":[["EUECBR=ECI",2.9,3.15,null]],"error":[{"code":251658244,"col":3,"message":"Error: Field 'PDOR_1' was not found in response for the instrument 'EUECBR=ECI'","row":0}],"headerOrientation":"horizontal","headers":[[{"displayName":"Instrument"},

    The backend used by the get_data method couldn't find the PDOR_1 field.

    You can try another endpoint instead. For example:

    stream = rd.open_pricing_stream(
        universe=['EUECBR=ECI'],
        fields=['ECON_ACT', 'ECON_PRIOR','PDOR_1']
    )
    stream.get_snapshot() 
    
    image.png