How to get Amount Issued for expired Corporate Bonds
The Eikon API for getting data eikon.get_data() does not have data for expired bonds.
So I tried to use the search APIs in Eikon, namely rdp.Search and data.content.search() in order to get the Amount Issued for expired bonds. (As a side note, what is the difference between these search APIs ?)
Here is an example of expired bond for which I cannot find the amount outstanding via search:
* CUSIP = 758110AE0 (a matured bond of Adidas)
Here is a sample of the search code that would retrieve (among others) the cusip above.
import refinitiv.data as rd
from refinitiv.data.content import search
GroupSize=10000
filterStr = "ParentOAPermID eq ‘4295868725’ and RCSAssetCategoryLeaf ne ‘Commercial Paper’"
srchFields = "RIC,IssuerName,CUSIP,Country,MaturityDate,IssueDate, \
IsActive,Ticker,AmtOS,AmtOutstanding,IssueSizeUSD,IssueSizeEUR"
rd.open_session()
response = search.Definition(
view=search.SearchViews.GOV_CORP_INSTRUMENTS,
select= srchFields,
filter= filterStr,
top = GroupSize,
).get_data()
Here is an alternative way to search again leading to the CUSIP above. I cannot find the Amount issued (or even outstanding) for this one either.
GroupSize=10000
filterStr = "ParentOAPermID eq ‘4295868725’ and RCSAssetCategoryLeaf ne ‘Commercial Paper’"
srchFields = "RIC,IssuerName,CUSIP,Country,MaturityDate,IssueDate, \
IsActive,Ticker,AmtOS,AmtOutstanding,IssueSizeUSD,IssueSizeEUR"
data = rdp.search(
view=rdp.SearchViews.GovCorpInstruments,
top =GroupSize,
filter= filterStr,
select = srchFields )
So how do you get the Amount Issued for expired corporate bonds in Eikon?
Thank you very much!
Best Answer
-
Dear @marius.popa ,
Thank you for your question. Consider using FaceOutstanding, FaceIssuedTotal and FaceIssuedUSD instead of AmtOutstanding (this doesn't seem to be a valid property). See attached a response based on your code. Is this addressing your question?
Generally, I would advice looking at this article which shows how to find property names and values easily.
As it comes to the difference between rdp.Search and data.content.search(), the latter is using our latest RD library so I would suggest sticking to that.
Hope this was helpful, please let me know should you have any further questions.
Best regards,
Haykaz
0
Answers
-
Hi @marius.popa
For questions related to content and the availability of data and the properties that hold this data, I would recommend you reach out to the Refinitiv Helpdesk.
That being said, I was able to find the following:
response=search.Definition(
view=search.SearchViews.GOV_CORP_INSTRUMENTS,
filter = "CUSIP eq '758110AE0' and RCSAssetCategoryLeaf ne 'Commercial Paper'",
select ="RIC,IssuerName,CUSIP,Country,MaturityDate,IssueDate, \
IsActive,Ticker,FaceIssuedTotal,FaceOutstanding,FaceOutstandingUSD",
).get_data()
response.data.df0 -
Thank you very much, Nick and Haykaz! Both answers address my question. The site only allowed me to accept one, so I added Haykaz's because it contains some clues on how to find the answer to similar questions in the future myself.
1
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 中文论坛