Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
16 4 7 9

Retrieve Equity Index Info via fuzzy search on RDP

Hi Team, Hi Nick

@nick.zincone

is there any reason why the below query gives results on Advanced Search Tool of EIKON, but not in RDP?

Also, how can I get the constituents (and weights thereof) of whatever Equity Index that comes out of the query below?


import refinitiv.dataplatform as rdp

rd.open_session()

sFilter = "( SearchAllCategoryv2 eq 'Indices' and ((CommonName eq 'MSCI All Country World')))"

sSelect = "RIC, CommonName,ConstituentExchangeName,IssuerCommonName,BusinessEntity,PrimaryChainRIC,RCSAssetCategoryLeaf,RCSIndexCountryGroupLeaf"

GroupSize = 5000


res = rd.discovery.search(view = rd.discovery.Views.INDEX_INSTRUMENTS, filter=sFilter, query = sSelect) # INDEX_INSTRUMENTS

print(res)


Thanks

Grigorios

#technology#productpython apiindexconstituentsrdp search
icon clock
10 |1500

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

1 Answer

· Write an Answer
Upvote
Accepted
1.3k 5 3 6

Hi @grigorios.mamalis

You need to replace 'query' with 'select' in your request.

res = rd.discovery.search(view = rd.discovery.Views.INDEX_INSTRUMENTS, filter=sFilter, select = sSelect) 

MSCI indices constituents are not available in Eikon/Refinitiv Workspace. That should be possible with Refinitiv Eikon Datastream product.

icon clock
10 |1500

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

Hi @m.bunkowski ,


many thanks for the help/correction/info. My bad.




Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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