question

Upvotes
Accepted
1 0 2 2

Translating Excel Formula to RDP/API - Index Constituents

Hello Everyone,

I am currently using the formula below to get the constituents of FTSE 100 today:

=@TR(".FTSE","TR.IndexConstituentRIC","SDate="&TODAY()&" RH=IN",H5)

Can anyone help me to get the equivalent formula when using RDP/Python API ?

Thanks

#technologyrdp-apipython 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.

Upvotes
Accepted
6.2k 18 2 8

Hi @nail.chakir ,


Thank you for your question. You may use RD Libraries for python. See an example query below:

import refinitiv.data as rd
rd.open_session()

df = rd.get_data('.FTSE', ['TR.IndexConstituentRIC' , 'TR.IndexConstituentName'])
df

screenshot-2023-07-19-at-163756.png

Hope this helps.


Best regards,

Haykaz


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.

Upvotes
1 0 2 2

Many Thanks Haykaz.

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.

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.