S&P 500 Index constituents every month

lifeplsbenice2me

How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem? Thank you!

Jirapongse

@lifeplsbenice2me

Thank you for reaching out to us.

You can try the following one:

=@RDP.Data("0#.SPX(20120101)","TR.RIC","CH=Fd RH=IN",B2)

However, please contact the helpdesk team directly via LSEG Support to confirm this formula.

Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.