Is it possible to use cell referencing on Python / codebook?

JeffreyPatrick.Pinpin

hello,

Is it possible to use cell referencing using Python / Codebook?

Please see attached Excel file for reference

14956763.xlsx

In addition, how can we display the dates? In added the parameter 'RH': 'Date' but still did not display the dates

import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['AAPL.O'],
fields = ['PERCENT_CHG(TR.NetprofitSmartEst,wsize=-1)'],
parameters = {
'SDate': '2025-04-25',
'EDate': '2025-05-25',
'Frq': 'D',
'RH' : 'DATE'
}
)

display(df)

Thanks

Gurpreet

Hello @JeffreyPatrick.Pinpin

Cell referencing can be used within Excel formulas. Codebook is a hosted Jupyter environment and does not have a concept of cells.

To show dates in your formula, use the .date output type for the field as shown:

df = ld.get_data('AAPL.O', fields = ['TR.NetprofitSmartEst', 'TR.NetprofitSmartEst.date', 'PERCENT_CHG(TR.NetprofitSmartEst,wsize=-1)'],
  parameters = {
    'SDate': '2025-04-25',
    'EDate': '2025-05-25',
    'Frq': 'D',
  }
)

Huma

Please check this with follow up question:

1. what is the date format on Python vs excel? Looks like excel is yyyymmdd, but the format could be dd/mm/yyyy on python?

1. % change in smart estimates for Apple revenues, 3 days after the release date (lets say here 2 May 2025).

Just one point, no need for time series.

import refinitiv.data as rd

rd.open_session()

df = rd.get_data('AAPL.O', fields = ['TR.NetprofitSmartEst', 'TR.NetprofitSmartEst.date', 'PERCENT_CHG(TR.NetprofitSmartEst,wsize=-1)'],

  parameters = {

    'SDate': '2025-04-25',

    'EDate': '2025-05-25',

    'Frq': 'D',

  }

)

display(df)

Gurpreet

https://community.developers.refinitiv.com/discussion/comment/126778#Comment_126778

Date is an object in Python - it is up to the app to format it in whatever string it wants to display. The second question is related to content and can be asked at LSEG MyAccount

Jirapongse

Regarding the SDate, I tested it and it supports yyyy-mm-dd, mm/dd/yyyy and yyyy/mm/dd.

Huma

Hi Team , Client has another follow up :

We have checked with product manager and suggested to use field TR.RevenueSmartEstPctChg(ChgPeriod=D3,RollPeriods=False)

So kindly apply this filed in the script and please note it should be static data not time series and also column for date.