Replicate GOVSRCH function in Python
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.
Best Answer
-
Hi @oleksandr.yermolayev
"For RSearch function, unfortunately, you have to use another API.
Please refer to this post. <<< click here
0
Answers
-
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.
1 -
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
0 -
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.
0 -
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
0 -
Hi @oleksandr.yermolayev
"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)
0 -
Please see the screnshot attached. Many thankscapture6.png
0 -
I cannot find formula from the GOVSCH.
If you can test the screener from the excel as in the picture above, please share the screenshot. Thanks.
0 -
sukuk-query-july-2019.zip @chavalit.jintamalit many thanks!
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 162 App Studio
- 4 Block Chain
- 5 Bot Platform
- 17 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 370 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛