Retrieving historical Index Constituent FTSE

skundu

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")

chavalit-jintamalit

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.

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