How to insert a date column with rd.get_data

Hello everyone

I would like to get a time series with get_data. I would like to have the P/E ratio of the last 3 years.

I use the following code:

import refinitiv.data as rd

rd.open_session()
df = rd.get_data(
    universe = ['LISN.S'],
    fields = ['TR.PE'],
    parameters = {
        'SDate': '2020-12-31',
        'EDate': '-1D',
        'Frq': 'D'
    }
)

display(df)

I also get the P/E of the last 3 years, but I don't get any dates. I had this problem before and I was told that I just have to add .fperiod. But this does not work with TR.PE.

What do I have to do so that when I work with a start and end date, the date is always displayed.

Many thanks

Find more posts tagged with

codebook

Accepted answers

jonathan.legrand

Hi @michael.mauchle ,

I would advise using the get_history function. For more info on that function, please look into CodeBook's example:
__Examples__/01. Data Retrieval and Discovery/01.01. Refinitiv Data Library/Access__Get_History.ipynb

rd.get_history(
    universe=["LISN.S"],
    fields=["TR.PE"],
    interval="1D",
    start="2020-12-31",
    end="2023-12-31")

All comments

jonathan.legrand

rd.get_history(
    universe=["LISN.S"],
    fields=["TR.PE"],
    interval="1D",
    start="2020-12-31",
    end="2023-12-31")

michael.mauchle

Thank you - this is how it works

manuel.alvarez

Hi, I'm having a similar problem, but when I try to get the data with the rd.get_history(), it's not work, as you can see below:

How can I pull this EPS data like in the rd.get_data(), but with the date column appears?

manuel.alvarez

P.S.: I found a old tutorial with the ek.get_data where the get_data automatically create a 'Calc Date' column, available in https://github.com/LSEG-API-Samples/Article.EikonAPI.Python.WorkingWithFundamentalandEstimatesDCF/blob/main/Working%20with%20Fundamentals%20and%20Estimates%20Data%20-%20A%20DCF%20Example.ipynb

Does exists any similar way to do this with rd.get_data()?

Thanks!

EXPLORE OUR SITES