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 ?
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
@BTh, 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.
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.
@BTh, sounds like a good alternative, but it requires a World-Check contract.
We are now exploring getting ratings for entities, as these include governments. Don't know yet if this will satisfy the requirements.
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.
@BTh,
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 ?
Great, glad you have a solution, and thank you for posting the solution !
