Dear Refinitiv Team,
I know this question was discussed already a couple of times - but I am not succeeding: I am trying to get the ETF holdings weights (overtime) for the RPV - "Invesco S&P 500 Pure Value Index" which tracks the ".SP500PV". I am also fine with the holding weights of the underlying index the "SP500PV".
I tried several things to get either the weights of the ETF or of the SP500PV itself:
The "best" I could do was (where date_for_query is a variable).
ek.get_data('Index('RPV',' + date_for_query + ')',['TR.IndexConstituentWeightPercent','TR.RIC'])
Unfortunately, this request results in the same table for any date. Hence I don't get the weights over time.
I also tried to access the holding weights via the following but no weights are reported:
I also tried to access the weights with the Index and the "0#" method.
Is there a way to obtain the "tracking basket" of the ETF over time? Another alternative would be to get the DERIVED HOLDINGS (it's only monthly though).