Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • DSS /
avatar image
Question by BTh · Dec 05, 2018 at 10:17 AM · ratingscountry

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 ?

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

6 Replies

  • Sort: 
avatar image
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

Comment
Christiaan Meihsl

People who like this

1 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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 !

avatar image
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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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.

Comment

People who like this

0 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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.

avatar image
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.

avatar image
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.

avatar image
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.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
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 ?

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Unable to get Issuer Rating details response (more than 1000) in .Net SDK Solution

Rating data for equities in DSS

Issuer Rating in REST API

Only MDY rating for securities ?

Can't find the DSS field names for 4 issuer ratings requested by my users

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges