Hi,
I am attempting to retrieve pricing data between 2016-2021 for all constituents of the Euro STOXX 600 index using Formula Builder in Excel. The formula appears to work but only returns one result.
I have also tried retrieving pricing data for the same time period using one individual stock with the same issue occurring.
This is my first time using Refinitiv in Excel so I'm not sure whether it's a simple error.
Thanks in advance :)
Hi @lena.demaison ,
To get the constituent list, you can use the formula below
=@RDP.Data(".STOXX","TR.IndexConstituentName;TR.IndexConstituentRIC","CH=Fd RH=IN",B2)
Then from the RIC list retrieved, you can get their TR.PriceClose
=@RDP.Data($D$3:$D$602,"TR.PriceClose;TR.PriceClose.date","Curn=EUR SDate=2016-06-01 EDate=2017-06-01 Frq=W CH=Fd RH=IN",G2)
However,
Lastly, This forum is dedicated to software developers using Refinitiv APIs.
The moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one.
The best resource for content questions is the Refinitiv Helpdesk, which can be reached by either calling the Helpdesk number in your country or submitting a new ticket to the support team via MyRefinitiv.
The Helpdesk will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
Hope this could help
@lena.demaison Please remove the two TR.IndexJL fields and add TR.CommonName field try the call again. I hope this can help.
