Get the whole financial statement in 1 call.

TriDo
TriDo
in Eikon Data APIs

Hi,

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    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.

Answers

  • TriDo
    TriDo

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

  • TriDo
    TriDo

    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.

  • Alex Putkov.1
    Alex Putkov.1

    This can only be done manually.

  • Alex Putkov.1
    Alex Putkov.1

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

Categories