Issue getting credit ratings data with Python

Hello! I am trying to download all flavors of Fitch credit rating for Alinma Bank (1150.SE) with Eikon DAPI (Python). The formula that I am using is correct and returns ratings for other entities, but not for Alinma Bank, unfortunately. I basically go through all Fitch rating sources as indicated in the RATMON file. There is no problem with the formula, it is correct.

Fitch_rating, err = ek.get_data(instruments=["1150.SE"],fields=['TR.IssuerRating(IssuerRatingSrc=FIS)','TR.IssuerRating(IssuerRatingSrc=FSS)','TR.IssuerRating(IssuerRatingSrc=FDL)','TR.IssuerRating(IssuerRatingSrc=FDS)','TR.IssuerRating(IssuerRatingSrc=FBB)','TR.IssuerRating(IssuerRatingSrc=FBD)','TR.IssuerRating(IssuerRatingSrc=FBN)','TR.IssuerRating(IssuerRatingSrc=FBP)','TR.IssuerRating(IssuerRatingSrc=FBR)','TR.IssuerRating(IssuerRatingSrc=FBS)','TR.IssuerRating(IssuerRatingSrc=FBU)','TR.IssuerRating(IssuerRatingSrc=FBV)','TR.IssuerRating(IssuerRatingSrc=FCP)','TR.IssuerRating(IssuerRatingSrc=FDT)','TR.IssuerRating(IssuerRatingSrc=FFN)','TR.IssuerRating(IssuerRatingSrc=FFQ)','TR.IssuerRating(IssuerRatingSrc=FIF)','TR.IssuerRating(IssuerRatingSrc=FIN)','TR.IssuerRating(IssuerRatingSrc=FIV)','TR.IssuerRating(IssuerRatingSrc=FJB)','TR.IssuerRating(IssuerRatingSrc=FMC)','TR.IssuerRating(IssuerRatingSrc=FME)','TR.IssuerRating(IssuerRatingSrc=FMO)','TR.IssuerRating(IssuerRatingSrc=FMT)','TR.IssuerRating(IssuerRatingSrc=FMU)','TR.IssuerRating(IssuerRatingSrc=FNQ)','TR.IssuerRating(IssuerRatingSrc=FOC)','TR.IssuerRating(IssuerRatingSrc=FPC)','TR.IssuerRating(IssuerRatingSrc=FSB)','TR.IssuerRating(IssuerRatingSrc=FSC)','TR.IssuerRating(IssuerRatingSrc=FSE)','TR.IssuerRating(IssuerRatingSrc=FSF)','TR.IssuerRating(IssuerRatingSrc=FSR)'])


What it returns is NaN (empty) for all fields, although Eikon Terminal shows that there is a BBB+ rating for Fitch Long-Term Issuer Default Rating (rating source code=FDL), please see in the formula above. What is the issue with that? Many thanks for your help!

Best Answer

  • m.bunkowski
    Answer ✓

    Hi @alex.yermolayev

    Try this one:

    ek.get_data('1150.SE', ['TR.IssuerRating.date','TR.IssuerRating.RatingSourceDescription','TR.IssuerRating'], {'IssuerRatingSrc':'FBS:FSF:FDL', 'RatingScope':'All'})

    image

Answers