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

Find more posts tagged with

excel

python api

rdp-api

#technology

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

Hope this helps.

Best regards,

Haykaz

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

Hope this helps.

Best regards,

Haykaz

Many Thanks Haykaz.