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
0 0 0 1

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

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

eikon#technologypython apiexcel
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
10.6k 20 6 9

@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.



1689938765849.png (28.7 KiB)
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.

Thank you Jason. this works!

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.