Historical CDS Data for a certain time range

Hey I used the __Examples__/03. Quantitative Analytics/03.05. Credit Derivatives/CDS.ipynb codebook in the Workspace for some information's on CDS Data. What I need is the historical CDS Spreads from Single Name CDS that were traded by non-sovereign from the time range 01.01.2006 until 31.12.2010. How do I get this data could someone please help me out what line of codes I have to write in order to get this data ? All the codes I saw in this forum did not work on my case and I also need the code for a specific time range.

Find more posts tagged with

data

historical

python api

#technology

Accepted answers

jonathan.legrand

Hi @sahin.yigit,

Is this what you're after?

import pandas as pd
from datetime import datetime
import refinitiv.data as rd
rd.open_session()

# Find info on the fields we can use in `select` & `filter`:
response: rd.delivery._data._response.Response = rd.content.search.metadata.Definition(
    view = rd.content.search.Views.CDS_INSTRUMENTS).get_data()
# Export metadata to a spreadsheet for easy viewing:
response.data.df.to_excel("CDS_INSTRUMENTS.xlsx")

I looked in the outputed excel doc to find the fields I thought would be interesting.

Note that all the fields in that show up in that Excel Workbook are not nessesrily useful for CDSs; I used a lot of them in search requests (below) and found the ones returning data through quick trial and error proccesses.

srch_resp: rd.delivery._data._response.Response  = rd.content.search.Definition(
    view = rd.content.search.Views.CDS_QUOTES,  # for info on `SearchViews`, you can use `help(rd.content.search.SearchViews)`
    query="GE5YUSAX*", # Search all CDS that start with AMZN, which is Amazon's RIC
    filter="IsSovereign eq false", # "((AcquirerCompanyName ne 'Creditors' and AcquirerCompanyName ne 'Shareholder') and (TargetCountry eq 'US' or TargetCountry eq 'UK') and TransactionValueIncludingNetDebtOfTarget ge 100 and TargetPublicStatus eq 'Public') and (TransactionStatus eq 'Completed' or TransactionStatus eq 'Pending' or TransactionStatus eq 'Withdrawn')" # and InsertDateTime lt 2010-12-31
    select="RIC, IsSovereign, BuildDateTime, InsertDateTime,ContractCdsRicRoot,IntradayConstituentRICExists,IsBenchmarkRic,IsContractTrancheRic,IsPrimaryRIC,IssuerEquityPrimaryRIC,LiquidityRIC,PriceSource,RefEntityFamilyValuationRic,RefEntityImmediateParentIssueValuationRic,RefEntityIssueValuationRic,RICLength,RicRoot,RICUsageCount",
    top = 100, # max is 10000
    order_by = 'InsertDateTime asc').get_data()
srch_resp_df: pd.DataFrame = srch_resp.data.df
srch_resp_df

IPODate_df: pd.DataFrame = rd.get_data(
    universe=srch_resp_df.IssuerEquityPrimaryRIC.iloc[0],
    fields=["TR.IPODate"])
IPODate_df["IPO Date"][0]

Timestamp('1892-06-23 00:00:00')

if IPODate_df["IPO Date"][0] < datetime.strptime("2006-01-01", "%Y-%m-%d"):
    df: pd.DataFrame = rd.get_history(
        universe=srch_resp_df.RIC.iloc[5],
        start="2006-01-01",
        end="2010-12-31",
        fields=["TR.PARMIDSPREAD",
            "BID", "ASK", "TR.ASKSPREAD", "TR.BIDSPREAD",
                "TR.ASSETSWAPSPREAD", "TR.BENCHMARKSPREAD",
                "ASK_SPREAD", "MID_SPREAD"]) # You can find the `fields`` you are after in the DIB: https://developers.lseg.com/en/video-catalog/data-item-browser
_df: pd.DataFrame = df[["Ask Spread", "Bid Spread"]]

df["Par Mid Spread"].dropna()

Date

2007-10-17 27.802

2007-10-18 29.111

...

2010-12-30 112.256

2010-12-31 112.881

Name: Par Mid Spread, Length: 574, dtype: Float64

I found the `fields` in the `get_history` call as below:

All comments

jonathan.legrand

Hi @sahin.yigit , Could you let me know of an example CDS Spread you're after; specifically, I'm looking for a RIC, e.g.: VOD.L or ARGV5YUSAC=MP.
Also: would you mind letting me know if the Search API fullfill your need? There's an example of its use in CodeBook under:
__Examples__/01. Data Retrieval and Discovery/01.01. Refinitiv Data Library/Content__Search.ipynb

sahin.yigit

Hello @jonathan.legrand,

sure I can provide you the information. For example the CDS Spreads of the RIC: AMZN5YUSAX=MG for a past time range. As I said in my case it would be 01.01.2006-31.12.2010.

Yes the Search API fulfills my needs since it provides me the Ask and Bid Spreads of every Single Name CDS and it also has the option of showing the start and the end date. I would like to set a fix start and end date of the CDS´s and have as an output every CDS and its spread that has been traded in this time rage. I would be really thankful if you could help me out with this.

jonathan.legrand

Hi @sahin.yigit,

Is this what you're after?

import pandas as pd
from datetime import datetime
import refinitiv.data as rd
rd.open_session()

# Find info on the fields we can use in `select` & `filter`:
response: rd.delivery._data._response.Response = rd.content.search.metadata.Definition(
    view = rd.content.search.Views.CDS_INSTRUMENTS).get_data()
# Export metadata to a spreadsheet for easy viewing:
response.data.df.to_excel("CDS_INSTRUMENTS.xlsx")

I looked in the outputed excel doc to find the fields I thought would be interesting.

srch_resp: rd.delivery._data._response.Response  = rd.content.search.Definition(
    view = rd.content.search.Views.CDS_QUOTES,  # for info on `SearchViews`, you can use `help(rd.content.search.SearchViews)`
    query="GE5YUSAX*", # Search all CDS that start with AMZN, which is Amazon's RIC
    filter="IsSovereign eq false", # "((AcquirerCompanyName ne 'Creditors' and AcquirerCompanyName ne 'Shareholder') and (TargetCountry eq 'US' or TargetCountry eq 'UK') and TransactionValueIncludingNetDebtOfTarget ge 100 and TargetPublicStatus eq 'Public') and (TransactionStatus eq 'Completed' or TransactionStatus eq 'Pending' or TransactionStatus eq 'Withdrawn')" # and InsertDateTime lt 2010-12-31
    select="RIC, IsSovereign, BuildDateTime, InsertDateTime,ContractCdsRicRoot,IntradayConstituentRICExists,IsBenchmarkRic,IsContractTrancheRic,IsPrimaryRIC,IssuerEquityPrimaryRIC,LiquidityRIC,PriceSource,RefEntityFamilyValuationRic,RefEntityImmediateParentIssueValuationRic,RefEntityIssueValuationRic,RICLength,RicRoot,RICUsageCount",
    top = 100, # max is 10000
    order_by = 'InsertDateTime asc').get_data()
srch_resp_df: pd.DataFrame = srch_resp.data.df
srch_resp_df

IPODate_df: pd.DataFrame = rd.get_data(
    universe=srch_resp_df.IssuerEquityPrimaryRIC.iloc[0],
    fields=["TR.IPODate"])
IPODate_df["IPO Date"][0]

Timestamp('1892-06-23 00:00:00')

if IPODate_df["IPO Date"][0] < datetime.strptime("2006-01-01", "%Y-%m-%d"):
    df: pd.DataFrame = rd.get_history(
        universe=srch_resp_df.RIC.iloc[5],
        start="2006-01-01",
        end="2010-12-31",
        fields=["TR.PARMIDSPREAD",
            "BID", "ASK", "TR.ASKSPREAD", "TR.BIDSPREAD",
                "TR.ASSETSWAPSPREAD", "TR.BENCHMARKSPREAD",
                "ASK_SPREAD", "MID_SPREAD"]) # You can find the `fields`` you are after in the DIB: https://developers.lseg.com/en/video-catalog/data-item-browser
_df: pd.DataFrame = df[["Ask Spread", "Bid Spread"]]

df["Par Mid Spread"].dropna()

Date

2007-10-17 27.802

2007-10-18 29.111

...

2010-12-30 112.256

2010-12-31 112.881

Name: Par Mid Spread, Length: 574, dtype: Float64

I found the `fields` in the `get_history` call as below:

jonathan.legrand

You can find details about the nomeclature of CDS RICs in the Workspace application 'CDS/SINGLE Quote':

sahin.yigit

Hey @jonathan.legrand first of all thanks for your detailed answer.

I tried everything you provided and it worked well but still gives me some issues.
First of all if I use the filter InsertDateTime lt 2010-12-31 i get no output at all even if I set the query to "*" in order to search for all CDS there are. Also I tried to set several filters at the same time and if I do so I get no output at all as well. But the idea is great I want to look for every CDS Spread that existed during 2006-01-01 and 2010-12-31 under certain filters.

Further I tried the codes you provided. If I let the filter "IsSovereign eq false" as you provided it I get the following results if I display df in the last code.I can not find where you defined which CDS should be displayed here.Right now the RIC AXP1YUSAC=R is displayed, but I would rather see all different RIC´s during the specific time range. Also how can I get the rows that are hidden in the output due to space it would consume. I hope I could explained well enough what I am looking for. Anyway thank you very much for your help so far hopefully we can figure out the last problems as well.

EXPLORE OUR SITES