How can I use the python API interface to find the codes and names of all ETFs listed on a certai...

cheyx

...n exchange, such as the National Exchange of India?

How can I use the python API interface to find the codes and names of all ETFs listed on a certain exchange, such as the National Exchange of India?

Jirapongse

@cheyx

Yes, you can use the Search API in the Refinitiv Data Library to search for instruments.

For ETFs in National Stock Exchange of India, the code should look like this:

df = rd.discovery.search(
    view = rd.discovery.Views.FUND_QUOTES,
    filter = "AssetCategory eq 'ETF' and ExchangeName eq 'National Stock Exchange of India'",
    select = "DocumentTitle,AssetCategory,DTSimpleType,ExchangeName,RIC,IssueISIN,AssetStateName,IssueCommonName",
    top = 5000)
df

The output is:

You can also use the following code to list all available fields in the FUND_QUOTES view.

from refinitiv.data.content import search
response = search.metadata.Definition(
    view = search.Views.FUND_QUOTES  
).get_data()

response.data.df

wasin.w

Hello @cheyx

There is the Search API of the Data Library for Python. Is it what you need?

Example Code:

rd.discovery.search(
    view = rd.discovery.Views.EQUITY_QUOTES,
    top = 100,
    filter = "(SearchAllCategoryv2 eq 'Equities' and ExchangeName eq 'National Exchange of India')",
    select = "DTSubjectName,ExchangeName,RIC",
    order_by = "AvgVol5D desc"
)

Result:

You can find more information about the Search API from the following resources:

• Search API tutorial.
• Search API - Access layer example code.
• Search API - Content layer example code.

cheyx

https://community.developers.refinitiv.com/discussion/comment/115108#Comment_115108

Thank you. But is it possible to use eikon python API to find the codes?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/115110#Comment_115110

Answered in this discussion.

Maciej.Jasinski

Hi @cheyx

The script retrieves funds codes with "RIC" data item.

If these are not the codes you need, please specify.