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
grigorios.mamalis avatar image
16 ●5 ●7 ●10

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.

Jirapongse avatar image   Jirapongse

@grigorios.mamalis

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

1 Answer

· Write an Answer
Upvote
Accepted
m.bunkowski avatar image
1.4k ●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.

grigorios.mamalis avatar image grigorios.mamalis
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.