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!