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

Options

hello,

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

Please see attached Excel file for reference

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

Answers

  • 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
    Huma LSEG

    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)

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

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

    image.png
  • Huma
    Huma LSEG

    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.