Obtain results of index universe using Eikon API

Dear Refinitiv Team,

I am trying to obtain the RICs of several thousand Equity Indices. I'm able to use the Advanced search function to display what I wanted within the Eikon application (please see this file: equity_indices.png). However, I need to export more than the maximum number of rows allowed for download by Excel (4000 rows)--do you know of a command that I could run using the Eikon API in Python? I've been trying to recreate this using the Code Creator app but haven't been able to.

Thank you very much in advance,

Adrien

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

nick.zincone

Hi @AAMZ,

You can try this:

import refinitiv.dataplatform as rdp
...

df=rdp.search(
    view = rdp.SearchViews.IndexInstruments,
    select = "CommonName,ConstituentExchangeName,RIC,PrimaryChainRIC,DTSimpleType"
)

All comments

nick.zincone

Hi @AAMZ,

You can try this:

import refinitiv.dataplatform as rdp
...

df=rdp.search(
    view = rdp.SearchViews.IndexInstruments,
    select = "CommonName,ConstituentExchangeName,RIC,PrimaryChainRIC,DTSimpleType"
)

AAMZ

Thanks a lot @nick.zincone , also for the quick response. The formula looks good and I'll give it a try as soon as I get my RDP connection in Python working in Python. Thanks again

Alex.Putkov12

@AAMZ

To add to the response by @nick.zincone, I suggest you take a look at the article titled "Building Search into your Application Workflow". RDP Search Service limits search result window to 10K documents. See the chapter titled "Segmenting the search" in the above article for discussion on techniques you can use to retrieve larger universe as a search result.

EXPLORE OUR SITES