Query issue with Commodities data

Question

Hi, I'm trying to fetch historical and live data for a few commodities, but the data field returns NA. The help desk recommended reaching out to you because it seems an issue on your side. Can you please check?

import refinitiv.data as rd

rd.open_session()

cm_hist = rd.get_data(

universe = [

'LCOc1',

'CLc1',

'TRNLTTFMc1',

"JKMc1",

],

fields = ['TR.SETTLEMENTPRICE.DATE', 'TR.SETTLEMENTPRICE'],

parameters = {

'SDate': '0D',

'EDate': '2025-10-01',

'Frq': 'D',

'Curn': 'Native'

}

)

cm_last = rd.get_data(

universe = [

'LCOc1',

'CLc1',

'TRNLTTFMc1',

"JKMc1",

],

fields = ['CF_DATE', 'CF_LAST']

)

cm_hist_clean = cm_hist.drop_duplicates(subset=['Date', 'Instrument'])

cm_hist = cm_hist_clean.pivot(index="Date", columns="Instrument", values="Settlement Price")

print(cm_hist)

print(cm_last)

stefanog · Answer

T

Jirapongse · Answer

@stefanog

It may relate to the permission issue. You can try the delayed RICs instead.

cm_last = rd.get_data(

  universe = [

    '/LCOc1',

    '/CLc1',

    'TRNLTTFMc1',

    "/JKMc1",

    ],

  fields = ['CF_DATE', 'CF_LAST']

  )

Jirapongse · Answer

@stefanog

Thank you for reaching out to us.

The best way to determine whether the issue is caused by the code or the content is to compare the data with Workspace Excel.

For example, I ran the following Excel formula to retrieve the same data and I found some values are null.

=@RDP.Data("CLc1;JKMc1;LCOc1;TRNLTTFMc1","TR.SETTLEMENTPRICE","Frq=D SDate=0D EDate=2025-10-01 CH=IN RH=Fd,Date",K2)

=@RDP.Data("LCOc1;CLc1;TRNLTTFMc1;JKMc1","CF_DATE;CF_LAST","CH=IN RH=Fd",B2)

Therefore, please need to ask the helpdesk for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code. You can also refer to this How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.

EXPLORE OUR SITES