How to get LTM value for item TR.TotalRevenue?

Tulkkas · November 2019

I am trying to retrieve data for the company Allianz (RIC: ALVG.DE). In Eikon i can easily find the latest reporting quarterly and semi-annualy and there is also a TTM value of 101.128 as you can see in the below image.

I am trying to retrieve this value using the following command:

ids             = ['ALVG.DE']
fields          = ["TR.TotalRevenue","TR.TotalRevenue.rfperiode","TR.TotalRevenue.date"]
fields_params   = {'SDate':'0D', 'Period':'LTM'}
data1, err1     = ek.get_data(ids,fields,fields_params)

But this returns NaN. What should I modify to get the Trailing Twelve month value of 101.128 that i see in Eikon?

chavalit-jintamalit · November 2019

Hi @Tulkkas

Your code is correct but the data which period is LTM is not available.

I just reconfirm using "Data Item Browser"

You can contact Refinitiv Content Helpdesk to clarify why the data for LTM period is not available at https://my.refinitiv.com/

Tulkkas · December 2019

chavalit-jintamalit

Nov 26, 2019

Hi @Tulkkas
Your code is correct but the data which period is LTM is not available.

I just reconfirm using "Data Item Browser"

You can contact Refinitiv Content Helpdesk to clarify why the data for LTM period is not available at https://my.refinitiv.com/

When you say the data is not available, it means not available specifically through the Python API right? Because obviously it is available in Eikon (see my screenshot). Is there a reason why it would not be available only through de API?

How to get LTM value for item TR.TotalRevenue?

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories