Does DSS offer country ratings ?

Question

Question by BTh · Dec 05, 2018 at 10:17 AM · dss-rest-api datascope-select dss data credit-ratings

Does DSS offer country ratings ?

There is a requirement for this bank to get country ratings. I can't seem to find out if DSS has country ratings data from S&P, Moody's, Fitch... Can you help ?

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-01-10T07:15:28Z

Best Answer

Answer by BTh · Jan 10, 2019 at 07:15 AM

Hi @Christiaan.Meihsl

we actually have a solution, and one which is much nearer to anything suggested here, and already included in the DSS data ! and that is: Entity details ! Actually, a country, or rather its government, is held as an entity in the DSS data. Mohamed Hisham has shown me how to access such entities in the DSS GUI, then he sent us an Excel with all entities of type "Government", and, using the OrgID that came with each entry, I have been able to retrieve all the long-term "issuer" ratings (foreign) of each of these entities, so far from Moody's and S&P, and that's exactly what we call country ratings, so our problem has thus been solved... by an existing DS feature :)

My DSS login is unfortunately not permissioned for Fitch ratings, and our requests to be permissioned are stuck somewhere it seems :( That's a pity, as the bank wants actually only Fitch ratings, and neither Moody's nor S&P ratings for countries !

So, basically, DSS has country ratings, they are "disguised" as government entity ratings :). Hope this can help some other developers and TR clients looking for this kind of data.

Regards

Bernard

1 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

REFINITIV

Christiaan Meihsl ♦♦ · Jan 10, 2019 at 08:07 AM 0

Share

Great, glad you have a solution, and thank you for posting the solution !

Answer 2 · 2018-12-11T04:40:43Z

REFINITIV

Answer by Christiaan Meihsl · Dec 11, 2018 at 04:40 AM

@bernard.thouin, DSS does not have country ratings.

As an alternative, maybe you could use state bonds ratings as an approximation ? But note I'm not a data expert, so I suggest you validate this or other alternatives with a financial specialist.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2018-12-11T06:49:03Z

Answer by BTh · Dec 11, 2018 at 06:49 AM

Thanks @Christiaan.Meihsl, there seems to be a better alternative with a country ranking data file download from World-Check, but no one seems to be able to tell me how to get that file yet.

0 Show 3 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

REFINITIV

Christiaan Meihsl ♦♦ · Dec 11, 2018 at 07:04 AM 0

Share

@bernard.thouin, sounds like a good alternative, but it requires a World-Check contract.

BTh Christiaan Meihsl ♦♦ · Dec 11, 2018 at 07:20 AM 0

Share

That's clear. But have first a look at my question "Where do I find some documentation about the World-Check one API", last 3 posts, one from Wayne Choo and 2 answers from me. They are about country ratings and the famous download file.

REFINITIV

Christiaan Meihsl ♦♦ BTh · Dec 11, 2018 at 07:38 AM 0

Share

@bernard.thouin, ok, I see your predicament. I know absolutely nothing about the World-Check one API, but I will try to push some people to get you some answers. Hopefully you will get what you need. Kind regards.

Answer 4 · 2019-01-03T07:53:28Z

Answer by BTh · Jan 03, 2019 at 07:53 AM

We are now exploring getting ratings for entities, as these include governments. Don't know yet if this will satisfy the requirements.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 5 · 2019-01-07T06:27:37Z

Answer by BTh · Jan 07, 2019 at 06:27 AM

I need to get Entity Details for all entities of type "Government". Is there a request that would allow me to do that ? If yes, that would be the answer to my country ratings question, because entities of type "Government" are actually countries :)

And what is the exact DSS field name showing as "Type" in the entity search answer on the DSS GUI? it just says "Type", but what type is it? An entity type? An ID type? Some other type?

Thanks for you help.

Bernard

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 6 · 2019-01-10T05:36:12Z

REFINITIV

Answer by Christiaan Meihsl · Jan 10, 2019 at 05:36 AM

@bernard.thouin,

Just an idea: would you be ready to consider the rating of government treasury bonds as a substitute for the rating of the government itself ?

It would require using several bonds of various durations, and several rating agencies, to ensure to get a result, as not all exist or are rated. The RICs are easy to build: <2 letter country code><duration>YT=RR

Here is an example request:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "S&P Rating", "Moodys Rating", "Fitch Rating", "Dominion Bond Rating", "JCR Rating", "R&I Rating"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                { "Identifier": "CH5YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "CH10YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "CH20YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "FR5YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "FR10YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "FR20YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "CO5YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "CO10YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "CO20YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "ZA5YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "ZA10YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "ZA20YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "US5YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "US10YT=RR", "IdentifierType": "Ric" },
                { "Identifier": "US20YT=RR", "IdentifierType": "Ric" }
            ]
        }
    }
}

And the result:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "CH5YT=RR",
            "S&P Rating": null,
            "Moodys Rating": null,
            "Fitch Rating": "AAA",
            "Dominion Bond Rating": "AAA",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CH10YT=RR",
            "S&P Rating": null,
            "Moodys Rating": null,
            "Fitch Rating": null,
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CH20YT=RR",
            "S&P Rating": null,
            "Moodys Rating": null,
            "Fitch Rating": "AAA",
            "Dominion Bond Rating": "AAA",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FR5YT=RR",
            "S&P Rating": null,
            "Moodys Rating": null,
            "Fitch Rating": null,
            "Dominion Bond Rating": "AAA",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FR10YT=RR",
            "S&P Rating": null,
            "Moodys Rating": "Aa2",
            "Fitch Rating": null,
            "Dominion Bond Rating": "AAA",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FR20YT=RR",
            "S&P Rating": null,
            "Moodys Rating": "Aa2",
            "Fitch Rating": "AA",
            "Dominion Bond Rating": "AAA",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CO5YT=RR",
            "S&P Rating": "BBB",
            "Moodys Rating": "Baa2",
            "Fitch Rating": "BBB",
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CO10YT=RR",
            "S&P Rating": "BBB",
            "Moodys Rating": "Baa2",
            "Fitch Rating": "BBB",
            "Dominion Bond Rating": "BBB",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "ZA5YT=RR",
            "S&P Rating": "BB+",
            "Moodys Rating": "Baa3",
            "Fitch Rating": "BB+",
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "ZA10YT=RR",
            "S&P Rating": "BB+",
            "Moodys Rating": "Baa3",
            "Fitch Rating": "BB+",
            "Dominion Bond Rating": "NR",
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "ZA20YT=RR",
            "S&P Rating": "BB+",
            "Moodys Rating": "Baa3",
            "Fitch Rating": "BB+",
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "US5YT=RR",
            "S&P Rating": null,
            "Moodys Rating": "Aaa",
            "Fitch Rating": "AAA",
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "US10YT=RR",
            "S&P Rating": null,
            "Moodys Rating": "Aaa",
            "Fitch Rating": "AAA",
            "Dominion Bond Rating": null,
            "JCR Rating": null,
            "R&I Rating": null
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "CO20YT=RR",
            "Error": "Not found"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "US20YT=RR",
            "Error": "Not found"
        }
    ],
    "Notes": [
        "Extraction Services Version 12.3.40120 (6e884d0c045e), Built Dec  4 2018 23:36:20\r\nProcessing started at 10012019 11:32:47 AM.\r\nUser ID: 33314\r\nExtraction ID: 341333643\r\nSchedule: _OnD_0x067a9f17f3002fb6 (ID = 0x067a9f17f4d02fb6)\r\nInput List (13 items): _OnD_0x067a9f17f3002fb6 (ID = 067a9f17f3a02fb6) Created: 10012019 11:32:45 AM Last Modified: 10012019 11:32:46 AM\r\nTotal instruments after instrument expansion = 13\r\nSchedule Time: 10012019 11:32:46 AM\r\nReport Template (12 fields): _OnD_0x067a9f17f3002fb6 (ID = 0x067a9f17f3202fb6) Created: 10012019 11:32:45 AM Last Modified: 10012019 11:32:45 AM\r\nProcessing completed successfully at 10012019 11:32:48 AM, taking 0.892 Secs.\r\nExtraction finished at 10012019 10:32:48 AM UTC, with servers: x12n02, QSHC20 (0.3 secs), QSSHA1 (0.1 secs)\r\nUsage Summary for User 33314, Client 11122, Template Type Terms and Conditions\r\nBase Usage\r\n        Instrument                          Instrument                   Terms          Price\r\n  Count Type                                Subtype                      Source         Source\r\n------- ----------------------------------- ---------------------------- -------------- ----------------------------------------\r\n     12 Govt/Treasury/Central Bank                                       N/A            N/A\r\n-------\r\n     12 Total instruments charged.\r\n      1 Instrument with no reported data.\r\n=======\r\n     13 Instruments in the input list.\r\nWriting RIC maintenance report.\r\n",
        "Identifier,IdentType,Source,RIC,RecordDate,MaintType,OldValue,NewValue,Factor,FactorType\r\n"
    ]
}

Would this do ?

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Does DSS offer country ratings ?

6 Replies

Watch this question

Related Questions