Is it possible to retrieve all indicators using only permids not rics in Eikon data api?

alekseenkova.marina
alekseenkova.marina Explorer
in Eikon Data APIs

Via excel it is not possible to extract data using Permid; however, via Eikon data api it is possible. Is there any limitations on this or are there any flaws of this method?


Please find an example below. It is just an example. My question is about general method.

import eikon as ek

ek.set_app_key('91cb87bb5ba74a5ea216a2107f0fff8496f020a7')

df, err = ek.get_data(

instruments = ['4295905573',

'4295860867',

'4295861186',

'4295861643',

'4295861649',

'4295861939',

'4295861978',

'4295862639',

'4295886292',

'5074552923'],

fields = ['TR.PE'])


df.head()


Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @alekseenkova.marina

    You can use the PermIds in Eikon Excel to retrieve the data. The formula is:

    =@TR("4295905573;4295860867;4295861186;4295861643;4295861649;4295861939;4295861978;4295862639;4295886292;5074552923","TR.PE;TR.RIC","CH=Fd RH=IN",G4)

    The output is:

    1658138492541.png

    The output is similar to the output from Eikon Data API.

    1658138545931.png

    Therefore, you need to contact the Eikon Excel support team directly MyRefinitiv regarding the limitations when using PermIds in Eikon Excel to retrieve the data. I think the limitations in Eikon Excel will also be applied to Eikon Data API.

Answers

Categories