question

Upvotes
Accepted
1 0 0 1

Time series data building

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



eikoneikon-com-apihistorical
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
4.1k 3 6 10

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea