Unable to get Revenue Data

Options
pyquant
pyquant Newcomer
in Eikon Data APIs

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?


image

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @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

    image

Answers

  • jason.ramchandani01
    jason.ramchandani01 admin

    @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

    image

    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
    pyquant Newcomer

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

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

  • pyquant
    pyquant Newcomer

    Thanks. @jason.ramchandani01

Categories