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

Best Answer

  • nick.zincone
    Answer ✓

    Hi @AAMZ,

    You can try this:

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

    ahs.png

Answers

  • Thanks a lot
    @nick.zincone.1 , 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
  • @AAMZ

    To add to the response by @nick.zincone.1, 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.