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

kevinjames.simangan

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

jason.ramchandani01

@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']
)

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.