Hi, I am wondering if there is a way to access the full ratings history of a loan if I enter a cusip. Specifically I need to do this through the excel/vba api or python api. Also I would like to be able to find a full ratings history that can be exported to excel or a function in excel that will output the full ratings history. Thanks.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●0 ●1
Is there a way to access a full Ratings History in Eikon terminal if you enter a cusip (for a loan)?
Hi @n.wlezien
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks,
AHS
Hi @n.wlezien
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
3.8k
●4 ●4 ●6
That can be done using Tranche Cusip and retrieving rating of the issuer
ticker = '00030UAD9'
start = "2017-01-01"
end = "2019-01-01"
df, err = ek.get_data(ticker, ['TR.IssuerRating.date','TR.IssuerRating','TR.IssuerRating.RatingSourceDescription'], {'SDate': start, 'EDate': end})
df
You can add more parameters to a function e.g. by choosing only selected rating source
ek.get_data(ticker, ['TR.IssuerRating.date','TR.IssuerRating','TR.IssuerRating.RatingSourceDescription'], {'SDate': start, 'EDate': end, 'IssuerRatingSrc': 'MCF'})
I suggest you also to explore possibilities of building that formula using Eikon Excel Formula wizard to get the data directly in Excel.
