question

Upvotes
Accepted
nail.chakir avatar image
1 ●0 ●0 ●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.

wasin.w avatar image   wasin.w

Hello @nail.chakir

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

2 Answers

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
5.2k ●16 ●2 ●7

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


screenshot-2023-07-19-at-163756.png (102.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.

Upvotes
nail.chakir avatar image
1 ●0 ●0 ●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.