How to retrieve MSCI index constituents & weights (index shares + weights) in Datastream?

yaokoffi.kouassi

Hello.

I want to retrieve the same informations like in this post in Datastream.

Here is the formula I'm using to retrieve this information.

=@DSGRID($B$1,"RIC,NAME,NOSH,NOSHFF","Latest Value","","","RowHeader=true;ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true")

I tried with the following list constituents (LFRCAC40, LDJSTOXX and LMSWRLDD) but the results are not correct.

The returned data are at the company level and not at the index level

Expected values returned by Refinitiv Data Library:

import refinitiv.data as rd

rd.open_session()

INDEX_CONSTITUENT_SHARES_FLD = "TR.IndexConstituentShares"
INDEX_CONSTITUENT_RIC = "TR.IndexConstituentRIC"
INDEX_WEIGHT = "TR.IndexConstituentWeightPercent"

df = rd.get_data(".FCHI", [INDEX_CONSTITUENT_RIC, INDEX_WEIGHT, INDEX_CONSTITUENT_SHARES_FLD])
df

can someone have a look, please ?

Thanks

Jirapongse

@yaokoffi.kouassi

Thank you for reaching out to us.

It should be these data types:

• WTIDX: % Weight Of Each Constituent Within The List
• FNSIDX: Number Of Shares Used In The Index Based On Free Float

df = ds.get_data("LFRCAC40",["RIC","WTIDX","FNSIDX"],kind=0)
df.pivot(index='Instrument', columns='Datatype')['Value']

Typically, you can use the Datastream Navigator tool to search for instruments and data types.

Otherwise, you can contact the Datastream support team directly via MyRefinitiv to find data types for you.

I hope that this information is of help.

yaokoffi.kouassi

Thank you so much @Jirapongse .

Your code works fine!