question

Upvotes
Accepted
1 0 1 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 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
4.1k 4 7 12

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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