S&P 500 Index constituents every month

lifeplsbenice2me
lifeplsbenice2me Newcomer
edited August 14 in Refinitiv Data Platform

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!

Answers

  • Jirapongse
    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.