What is the phyton code for this formula (Im using Refinitiv Eikon Excel) ?

kevinjames.simangan
kevinjames.simangan
in Eikon Data APIs

=@TR("LP68078930","TR.FundRegisterCountryofSalesFlag(FundCntry=AUT:DEU)","CH=IN;Fd RH=Country")

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01
    Answer ✓

    @kevinjames.simangan Hi - thanks for your question. The code is as follows using the Refinitiv Data Library.

    import refinitv-data as rd
    rd.open_session()
    rd.get_data(
        universe=['LP68078930'],
        fields=['TR.FundRegisterCountryofSalesFlag(FundCntry=AUT:DEU)','TR.FundRegisterCountryofSalesFlag(FundCntry=AUT:DEU).country']
    )

    1689938765849.png

    In future if you get stuck - you can try the CODE CREATOR app (type CODECR into Eikon/WS search bar). This will give a visual code builder very much like the formula builder in Eikon Excel - except it will generate the full python code and also launch a codebook instance so you can run it directly. In terms of fields most of the TR fields have the following structure:

    field_name(field_parameters).output_value.

    I hope this can help.


Answers

Categories