Time series data building

Petenausen
Petenausen Newcomer
in Eikon COM

Good morning,

What is the code to get in Eikon excel firm Total assets, operating income and net income before taxes from a specific year to another specific year (e.g. from 2016 to 2010) in the in the original currency?


Thank you so much



Tagged:

Best Answer

  • SupDev1
    SupDev1 Advocate
    Answer ✓

    Try TR function(retrieves real-time, fundamental and referential data)

    =TR("Universe","Data items","Parameters", <Destination Cell>, <Arguments (1-20)>

    For yours data should look like:

    =TR("Company","TR.OperatingIncome;TR.NetIncomeBeforeExtraItems;TR.NetIncomeBeforeExtraItems”,"Sdate=FY-3 Edate=FY-10")

    More about TR and other functions

Categories