How to retrieve the RICs of Index Constituents for NASDAQ and NYSE using the Eikon Python API?

cliffordmarshall.ablaza
cliffordmarshall.ablaza LSEG
in Eikon Data APIs

I need to get all the RICs thats are listed on the NASDAQ and the NYSE. I've tried using the API to pull all the RICS associated with the MIC XNAS (NaSDAq) but it's not returning anything.

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    .NDX in the answer by @chavalit-jintamalit is the RIC for Nasdaq 100 index. To get the list of Nasdaq stocks you want to use Nasdaq Composite index (the RIC is .IXIC).
    Alternatively you can use the Screener, which provides a lot of flexibility for what you want and don't want to include in the results. E.g. the following expression returns the most complete NYSE stocks listing including ADRs, prefs etc.

    ek.get_data('SCREEN(U(IN(Equity(active,public,' +
                'countryprimaryquote))),' + 
                'IN(TR.ExchangeMarketIdCode,"XNYS"))',
                ['TR.CommonName'])

Answers

  • nick.zincone
    nick.zincone admin

    Hi @cliffordmarshall.ablaza,

    I'm not sure if there is a way to retrieve the entire set of RICs listed on an exchange. The best way to find out if such a RIC exists or if this is even possible is to direct content questions to the Refinitiv Helpdesk.

    What is available is to retrieve constituents for a specific index on an exchange. For example, here are couple of examples of index on the NASDAQ and NYSE:

    image

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Hi @cliffordmarshall.ablaza

    You can try this code:

    df1,e1 = ek.get_data('0#.NYA','DSPLY_NAME')
    df2,e2 = ek.get_data('0#.NDX','DSPLY_NAME')

Categories