Replicate GOVSRCH function in Python

alex.yermolayev · July 2019

With Python to be able to receive a list of identifiers (ISINs, RICs, Tickers etc) based on specific criteria (e.g. Bonds, active, issued in Sweden, abover $250m amount outstanding.

chavalit-jintamalit · July 2019

Hi @alex.yermolayev

For RSearch function, unfortunately, you have to use another API.

Please refer to this post. <<< click here

chavalit-jintamalit · July 2019

Hi @alex.yermolayev

I think you can use "SCREENER" app to create the search term then use it with Eikon Data API.

1. Type in "SCREENER" on Eikon Search bar and press enter to open SCREENER.

Then select any search term and export it as excel formula. See picture below:

2. Look at the formulas in excel and extract the formulas to use with Eikon Data APIs.

alex.yermolayev · July 2019

Hi @chavalit-jintamalit,

Many thanks for you explanation, it is very helpful. However,

1. I see that the syntax in Excel and Python formula is a bit different. Could you let me know where I can get help on this Screen function in Python (Jupyter Notebooks) (may be a link to the documentation)?

2. Can I use the Screener function even if I look for bonds, not companies?

3. How do I know how many entries I got using the screener in Python, without necessarily doing the same search on the Terminal first?

Sorry for multiple questions, but your help is invaluable.

Cheers

chavalit-jintamalit · July 2019

https://community.developers.refinitiv.com/discussion/comment/46662#Comment_46662

Hi @alex.yermolayev

1. It is just a matter of handling String in excel and python is different.

For example ""in excel is escape character for "

So ""TH"" is "TH"

And /* sth sth sth */ is a comment so it can be removed.

(Sorry, there is no document)

2. I am sorry, I think it does not support bond search.

3. SCREENER on terminal is connecting to different services so you know in advance of the number of entries

It is not possible on the API, you have to do the actual search and count the number or records.

alex.yermolayev · July 2019

https://community.developers.refinitiv.com/discussion/comment/46671#Comment_46671

Hi @chavalit-jintamalit,

Many thanks for the reply.

1. Ok, understood

2. But the initial question was on GOVSRCH app (see above), which allows you to search for bonds. Can I not search for bonds at all in Eikon API? It it at all possible to retrieve all bonds (i.e either bond RICs or ISINs issued in Sweden, for example?)

3. Ok, undestood.

Cheers