Unable to get Revenue Data

pyquant

Hi,

I am having 2 issues (see below)

1.) I am unable to get historical revenue data for JETJ.L (see attached picture).

2.) The revenue for DHER.DE is missing a few periods why is that?

jason.ramchandani01

@pyquant Please try the code below to get the interim values for all Co's. I hope this can help.

df, err = ek.get_data(['JETJ.L','DHER.DE','AAPL.O','UBER.K'], 
                      ['TR.F.TotRevBizActiv.date','TR.F.TotRevBizActiv.periodenddate','TR.F.TotRevBizActiv'],
                     {'SDate':'2015-01-01', 'EDate':'2020-12-01','FRQ':'FI','Period':'FI0'})

df

jason.ramchandani01

@pyquant So quarterly reporting is standard in the US but not in the UK - where only semiannual reporting is available for JETJ.L. For DEHR.DE Quarterly reporting started in 2016.

For more complete fundamentals please use our new Refinitiv Company Fundamentals (RCF) content set and statements. RCF is our new strategic content set, with the most comprehensive, accurate and timely data on public and private companies around the world. It aims to provide both company specific data disclosed by the company and also standardized data to enhance the comparability of the financial data of companies from different countries, accounting standards and industries. This is a very large content set that combines the best of Refinitiv Fundamentals and also Worldscope. On average it provides 60% more content than the previous Refinitiv Fundamentals content set. Please try the following code:

df, err = ek.get_data(['JETJ.L','DHER.DE','AAPL.O','UBER.K'], 
                      ['TR.F.TotRevBizActiv.date','TR.F.TotRevBizActiv.periodenddate','TR.F.TotRevBizActiv'],
                     {'SDate':'2015-01-01', 'EDate':'2020-12-01','FRQ':'FQ','Period':'FQ0'})

df

You can find out more about this excellent new content set by launching the RCF app by typing RCFLAND into eikon search bar. I hope this can help.

pyquant

Thanks for your prompt reply. So I have another follow up question.

How can I get the semi-annual data for JETJ.l?

pyquant

Thanks. @jason.ramchandani