Retrieving historical TR.EPSMean data

FFabianB

Hi @Jirapongse

I would like to retrieve EPSMean (Tr.EPSMean) for three different periods for one stock. The code I have is the following:

fields=["TR.EPSMean(Period=2026)","TR.EPSMean(Period=2027)","TR.EPSMean(Period=2028)"]
df_fundamental = get_history(
                    universe=[ric],
                    fields=fields,
                    interval="1d",
                    start=datetime.datetime.today() - datetime.timedelta(2*365),
                    end=datetime.datetime.today()
                )

While it does return data, it does return the same data for the same dates twice etc.

Can you please advise how this can be prevented and also what other parameters can be used for this field via the Python API.

Jirapongse

@FFabianB

Thank you for reaching out to us.

I checked and found that it pulls the date when the estimates have been received by us. To get the exact values estimated for a specific date, you may use CalcDate. Therefore, the code will look like this:

df = ld.get_data(
    universe = ['LSEG.L'],
    fields = ['TR.EPSMean(Period=2026).calcdate','TR.EPSMean(Period=2026)',
              'TR.EPSMean(Period=2027).calcdate','TR.EPSMean(Period=2027)',
              'TR.EPSMean(Period=2028).calcdate','TR.EPSMean(Period=2028)'],
    parameters = {'SDate':'2024-04-22', 'Frq':'D', 'EDate':'2026-04-22'})

df

However, this question relates to content. Please contact the content support team directly via LSEG Support to confirm and verify this.

You need to ask 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.