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.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
135
●15 ●10 ●10
Replicate GOVSRCH function in Python
Hello @oleksandr.yermolayev,
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS
18.2k
●21 ●13 ●21
For RSearch function, unfortunately, you have to use another API.
Please refer to this post. <<< click here
Hello @oleksandr.yermolayev,
please note that a link in a comment does not always manifest as a link
18.2k
●21 ●13 ●21
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.
135
●15 ●10 ●10
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
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.
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
Please try to do the search on "Thomson Reuters Eikon - Microsoft Excel"
Then use the Screener on Excel and provide the screenshot.
I will try to see if I can make the same query on the API. (It may or may not be possible)
