For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
61 1 0 2

Get the historical constituents with RICs and weights for the MSCI World in Python

Hello, i am trying to get the constituents with RICs and weights of the MSCI World Index. I have tried several approaches such as

ek.get_data("0#.WORLD(2020-12-09)", "TR.CommonName")

or

ek.get_data(['.WORLD'], ['TR.IndexConstituentName'])

I am unsure if the name 'World' is correct, the latter approach works for '.STOXX50'. Help would be appreciated. Thanks!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
61 1 0 2

It doesnt work for me, also the current one doesnt. In the application it says "Your current entitlements do not allow Index Constituent Weightings "

This however works

ek.get_data(['IWDA.L'], ['TR.ETPConstituentRIC', 'TR.ETPConstituentName', 'TR.ETPConstituentWeightPercent'])

its a bit of a workaround since I am using the ishares ETF instead of the index itself but I think this should be fine. I just need to find out how to get the historical data now.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

@j.rasch I dont think we carry historical constituents for MSCI world - only current:


df,err = ek.get_data("0#.MIWD00000PUS", "TR.CommonName")
df

this works but this does not:

df,err = ek.get_data("0#.MIWD00000PUS(20201012)", "TR.CommonName")
df

Maybe you could try another index for which we have historical constituents (FTSE all World for example).

df,err = ek.get_data("0#.FTAWORLDSR(2020-10-12)", "TR.CommonName")
df

I hope this can help

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea