For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 2 3

Fund screener via Python API

I was following the steps in https://developers.refinitiv.com/en/article-catalog/article/find-your-right-companies-with-screener-eikon-data-apis-python, I realized that if I choose “Lipper Funds” for universe, it jumps to a different page, and when I export as excel, it doesn’t have the option to include formulas that can be used for Python API. Can anyone please advise on how to get formulas for fund screener? Am I doing something wrong? Thanks!

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
18.1k 21 13 21

Hi @kelly.he

I am not aware of the Lipper Fund search on Eikon Data API.

However, I think you can try using RDP Lib.


#pip install refinitiv.dataplatform

import refinitiv.dataplatform as rdp
rdp.open_desktop_session('_same_appkey_with_eikondataapi_')

df = rdp.search(
    view = rdp.SearchViews.FundQuotes,
    filter = "ExchangeCode eq 'LIP' and FundClassCurrency eq 'THB' and AssetStateName eq 'Active'",
    select = "RIC,DocumentTitle,ExchangeCode,FundClassCurrency,FundClassLipperID,AssetStateName,FundEntityLipperId,CommonName,ExchangeName",
    top = 10000
)
df

Then you can get RIC column as RIC list and use them with Eikon Data API.

rics = df['RIC'].tolist()
fields = ['TR.RIC','TR.xxx','TR.yyy'] #some fields

df2,e = ek.get_data(rics, fields)
df2



icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I've got the following error while tryig to run the first code


AttributeError: 'NoneType' object has no attribute '_get_endpoint_config'

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.