Retrival of Bonds in default in any point in time
Hi, I'm sorry if this is the wrong place to ask, but I couldn't find any better.
I am a student conducting a research about defaulted bonds. Hence, I need bond data for bonds with the attribute Asset Status = "In Default" in any point in time. I am able to use Thomson Reuters Eikon + Datastream.
I have 2 problems:
1. I could only find data for the current Asset Status + Asset Status Effective date, but I am not able to find historical data of the Asset Status and when it was effectively changed as it is shown in the bond interface. If there is a way to examine this data, I could extract all bonds I am interested in.
2. A second way would be to understand the dynamic of "Asset Status". If there are Asset Statuses that can only be changed to if the bond was prior set to "In default" (e.g. Liquidated), then I could search for bonds that are set to "In default" or to the mentioned Asset Statuses.
Any help is appreciated.
Thanks in advance
Steffen
Best Answer
-
Hi @steffen-pluetzke, we do not really expose the asset status history in the API or Eikon Excel, I will ask if we have plans of adding this and will let you know. At the moment you can see it on a bond description page under the asset status history.
As for the life cycle of a debt instrument, I am not quite sure how to help you with that. You might be better off contacting your local Refinitiv support desk.
0
Answers
-
Hello the Refinitiv team,
I'm a graduate at the University of Arizona and I need to do a research project based on the Rotman Finance Lab data (featuring only Canadian companies) which we use for our reports. How can I find the historical data of the Asset Status?_____
>Pull data from Datastream: data identifiers and eikon.get_data package via hireessaywriter0 -
By the looks of it, this feature is not implemented (neither for Eikon Python API, Eikon Excel, or Datastream Excel). Are there plans for this?
0 -
Hello @jhonny and @steffen-pluetzke,
You may wish to look into RD library Search functionality, described in the article Building Search into your Application Workflow to see if this information can be of help to you.
See section "Common Properties" and in it Asset State -> Defaulted.
Next you may wish to review Build queries easily using Refinitiv's Search API with Python and Jupyter.
By analogy to the described:
browser.execute(
view = search.SearchViews.GOV_CORP_INSTRUMENTS,
query = "bonds",
filter = "AssetState eq 'DE'"
)results in:
(8978, 355)
This is many hits, and potentially can be narrowed down further, to your specific requirements, but is under 10k limit, and therefore should allow the request:
response=search.Definition(
view = search.SearchViews.GOV_CORP_INSTRUMENTS,
top = 10000,
filter = "AssetState eq 'DE'",
select = "CommonName, IssuerName, AssetState, MaturityDate, LastChangeDate",
order_by = "CommonName"
).get_data()
response.data.dfResulting in:
...
Hope that this information is of help
1 -
Thanks, that's great and works very well! Is it also possible to retrieve the entire history of the Asset Status given the ISIN of a government bond? For this use case, e.g., with bond AT0000386115, I can only retrieve the latest Asset Status (TR.AssetStatus). I tried the following:
df = rd.get_history(
universe = ['AT0000386115'],
fields = ['TR.AssetStatus'],
start = '2005-01-01',
end = '2015-12-31'
)0 -
Hello @jhonny,
Glad to hear that this additional information was of help, the accepted answer by our expert remains correct:
RD get_history functionality is intended for pricing history request.
By running the call without field selection, you will be able to see all the fields that are available, for example:
rd.get_history("LSEG.L")
and RD library Search functionality is at the current point of time.
For in-depth history in general, enterprise history products, such as Refinitiv Tick History, are targeted. And for the specific requirement, if your organization evaluates the product, the specific content requirement is verified with Refinitiv content experts.
A customer can fully verify the availability of specific content within Eikon/Refinitiv Workspace with Refintiiv content experts via Refinitiv Helpdesk Online -> Content -> Eikon. If the content required can be obtained via Eikon Data Item Browser, it should also be available via Eikon Data API and RD -> get_data.
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 中文论坛