Retrieve type (e.g. fund or stock) of RIC in Thomson Reuters Eikon API

Statistik Dude
Statistik Dude Explorer
in Eikon Data APIs

Hello,

i have managed to retrieve a Pandas Dataframe, which includes all the RICs from "stocks" traded on exchanges of a specific country. The code I have used was taken from this post in the Eikon Community Forum. However, I have two follow up questions:

1. Since the request also includes ETFs, I am curious how to request the "type" (fund or stock) of a RIC?

2. Is it somehow possible, to get the "main exchange" of a RIC or a Company Name? So the exchange where most of the stocks are traded?

Thank you in advance!

Tagged:

Best Answer

  • jason.ramchandani01
    jason.ramchandani01 admin
    Answer ✓

    @Statistik Dude Please see code below:

    df, err = ek.get_data(['VOD.L','QQQ.N'],['TR.CommonName','TR.PrimaryQuote','TR.InstrumentType','TR.ShortExchangeName'])

    df  

    image

    Now where thee primary RIC is different from the RICs you have you need to check the exchange for that primary RIC. You can use the Data Item Browser App (type DIB into eikon search bar to see what fields are available for any RIC. Its a very useful tool to navigate our content. I hope this can help.

Answers

Categories