Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
5 2 0 2

Get the whole financial statement in 1 call.

Hi,

Is there a way to retrieve the whole income statement or balance sheet of a company without specifying each field ? Thank you

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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
Upvote
Accepted
39.4k 77 11 27

You have to specify each field you want to retrieve, but it's fairly easy to construct the list of fields in Excel. Using Formula Builder wizard select the desired field category, e.g. Reuters Fundamentals - General Information - Standardized Balance Sheet. Click Add All button to add all fields from this category to the request. Then insert formula into Excel worksheet. From Excel worksheet you can copy the list of fields and for example save them in a csv file, from which you can load the list of fields into your Python script.

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.

Hi just wondering how do we ensure the order of these fields so it looks like the balance sheet shown on eikon ?

Also is there a way to export the list from Data Item Browser to excel ? I mostly work on Mac so pretty inconvenient to switch to Windows sometimes just to use formula builder.

I'm afraid not. At the moment using Data Item Browser you can only copy & paste one data item at a time.

This can only be done manually.

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.