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

Best Answer

  • aramyan.h
    aramyan.h admin
    Answer ✓

    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

Answers