I'm writing my masterthesis and need data to conduct an event study.
I have a list of corporate bonds which includes data points such as ISIN, announcement date and Issuer Name etc. Now I need to extract the bonds of publicly traded companies and a time-series of historical closing prices for their stocks around the announcement date of the bond.
For example Apple Inc announced a bond (Annoncement date 16.02.2016, ISIN: US037833BU32). Is there a way to retrieve time-series closing price data of the issuer using the ISIN?
I can use both the Eikon and Datastream Excel Add-In but cannot find an appropriate identifier that allows me to link stock data to bond issuer data.
Thanks in advance
First you need to get the RIC of the stock. For this you can try =TR("US037833BU32","TR.RIC"), which returns "AAPL.OQ". Then you can use say =TR("AAPL.OQ","TR.CLOSEPRICE","Frq=D SDate=0 EDate=-19 CH=Fd RH=Date") to retrieve the timeseries of stock close price history.
There's a lot of potential complications here. Public companies frequently issue debt through private subsidiaries, hence the link between the bond and the stock may be less straightforward than in the above example.
This forum is dedicated to software developers using Refinitiv APIs. Since you're using Excel add-ins through GUI, if you have any further questions or need any additional help the best resource for you is Refinitiv Helpdesk, which you can reach by either calling the Helpdesk number in your country or by using Contact Us capability in your Eikon application.
Thanks for your detailed answer. Unfortunately, as a student I don't have access to the Refinitiv Helpdesk.
As a follow up question:
Is it possible to retrieve yearly fundamental data (for example revenue, total assets etc. for the last 5 fiscal years) from the issuer of the bond? Again I only have the ISIN of the bond but my data sample contains bonds from public and private companies
(e.g. XS1130340091, STOCKLAND TRUST MANAGEMENT LTD and US037833BU32, APPLE INC)
Thanks in advance
I'm a student from Robert Koch Institut doing my research paper and the first task is to get historical bond prices and yields data. I will also need to get the reporting frequency of fundametal data (quarterly and annually) later. Is there any solution to retrieve yearly fundamental data from the issuer of the bond?