Retrieving historical Index Constituent FTSE

Dear All,

I want to get the constituent of FTSE4Good US Index from 2010-2015. When I type the below formula, I get "NULL" as output. Can you please help? Thanks, Santanu

=TR(".FT4GDBUS";"TR.IndexConstituentRIC;TR.IndexConstituentName;TR.IndexConstituentWeightPercent";"SDate=2015-06-01")


Best Answer

  • Hi @skundu

    From the provided code, I believe that you are using Eikon Excel formula.

    Please contact helpdesk at https://my.refinitiv.com/

    Please select get support >> get product and content support and raise the case to helpdesk.


    I did a test and it seems that the data is not available.

    image

    Helpdesk will be able to explain why the content is not available and may be able to give you a solution.