Downloading all data from a GOVSRCH EIkon panel
Hi,
Is there a way I can download (via python) all the data shown in GOVSRCH? I tried the excel approach, but there's a limitation of 4000 records.
Regards
Sumit
Best Answer
-
@sumit So I think you need to separate things into 2 bits - the first bit is to identify a universe of bonds satisfying some criteria, the second bit is to get some information (such as prices etc) about those instruments. The Search API will help with the first part. The article and its accompanying notebooks contain examples entirely relevant to your bond use case - consider this from the following filter notebook
Example - Search for Brazil global sovereign bonds in USD with a duration greater than 1
rdp.search(
view=rdp.SearchViews.FixedIncomeInstruments,
filter = "RCSIssuerCountryLeaf eq 'Brazil' and \
RCSCurrencyLeaf eq 'US Dollar' and \
RCSTRBC2012Leaf eq 'Government & Government Finance' and \
OptionAdjustedDuration gt 1",
select ="RIC, ISIN, MaturityDate, CouponRate, IndustrySector, FaceOutstandingUSD, OptionAdjustedDuration"
)or this from the same notebook:
Example - Floating Rate Notes
rdp.search(
view = rdp.SearchViews.GovCorpInstruments,
filter = "CouponRate gt 2 and \
RatingsScope(RatingType eq 'MIS' and CurrentRatingRank lt 10) and \
RCSCouponTypeName eq 'Floating Coupon' and \
IsActive eq true and \
RCSTRBC2012Name eq 'Healthcare' and \
RCSCurrencyLeaf xeq 'Euro'",
select = "CouponCurrency, IssuerName, IssueDate, RIC, CouponRate, ISIN, Ticker, RCSTRBC2012Leaf, MaturityDate, AssetState",
)Between these two examples and others in the notebook you should be able to progress sufficiently. Note: maximum results for this API are 10,000 so you may need to build things up by country or sector or type or maturity date buckets in order to get all the instruments you need. A simple check for this is if the length of the return is 10,000, most likely it has been truncated so you need to segment your filter further. I hope this can help.
0
Answers
-
Attaching a example. Almost 60k rows. How can I ensure I can download all the rows?
0 -
@sumit So you can try to build up universes using various selections using our RDP Search API. A colleague has written an excellent article with accompanying jupyter notebooks. Please note that this API has a limit of 10K rows per query. So you may have to build up larger universes using instrument types or country codes iteratively. If you are looking for larger datasets please ask your account manager about our enterprise offerings which are better placed to handle this from technical and licensing perspective. I hope this can help.
0 -
Hi Jason. Thanks a lot for this. I have set up my rdp to search data. However, the link you've sent looks very equity focussed. Is there anything Bond related which will get me started on replicating <GOVSRCH>?
Ex: to replicated my GOVSRCH settings on Eikon, I have do the following:
filter="'Principal Currency' eq 'EUR' and Maturity geq '07/09/2022' and BondType='Bonds'"
fields = ['BID','ASK','OPEN_PRC','HIGH_1','LOW_1','TRDPRC_1','NUM_MOVES','TRNOVR_UNS']How do I then add something like:
- Search only Active bonds
- Only include "Government" & "Corporate"
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 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
- 367 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛