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 Marvin_deprecated_1 · Aug 14, 2019 at 11:16 AM · dsscdshistorical pricing

Historical CDS prices via DSS REST API

Hello I want to get historical CDS prices via the DSS REST API

I tried the following extraction request:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest",
    "ContentFieldNames": [
      "RIC",
      "Credit Default Swap Basis1",
      "Credit Default Swap Basis2",
      "Credit Default Swap Basis3",
      "Trade Date"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{
        "IdentifierType": "Ric",
        "Identifier": "GE.N"
      }]
    },
    "Condition": {
      "AdjustedPrices": false,
      "QueryStartDate": "2019-02-02",
      "QueryEndDate": "2019-09-03"
    }
  }
}

I get back the following

 {
  'IdentifierType': 'Ric',
  'Identifier': 'GE.N',
  'RIC': 'GE.N',
  'Credit Default Swap Basis1': None,
  'Credit Default Swap Basis2': None,
  'Credit Default Swap Basis3': None,
  'Trade Date': '2019-08-09'
},

As you can see nothing is coming back for the CDS fields.

Any help is appreciated.

 
              

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.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Christiaan Meihsl · Aug 15, 2019 at 04:40 AM

@Marvin,

When you run into such issues, you can check the latest DSS data content guide for coverage. Go to the "Field Descriptions" tab, and filter on column C and/or D to see only the report name and/or field names of interest. Data coverage is in columns O-AH (n = not available, y = available).

GE.N is an equity, and CDS is not available for equity. That is why you do not receive any data.


dss-cds-coverage.png (49.0 KiB)
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 Marvin_deprecated_1 · Aug 19, 2019 at 04:26 AM

Hi Christiaan,

Thank you for your answer.

Can you explain why I get

[{
  'IdentifierType': 'Ric',
  'Identifier': 'GE5YUSAX=R',
  'Error': 'Not found'
}]

When I use the RIC code for the CDS: GE5YUSAX=R

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 ♦♦ · Aug 19, 2019 at 05:33 AM 0
Share

@Marvin, that RIC is no longer quoted, it is what we call a "historical instrument", that is why it returns "Not Found". See my answer in this separate thread for the solution, using validation options to include historical instruments in the results.

avatar image
Marvin_deprecated_1 Christiaan Meihsl ♦♦ · Aug 19, 2019 at 09:57 AM 0
Share

Hi Christiaan,

Thanks for showing how that's done!

However, my next question is why we are still receiving data for that instrument code from TRKD?

When we search for GE5YUSAX=R there we get:

{
  'GE5YUSAX=R': {
    'Fields': [{
        'DataType': 'Double',
        'Double': 131.95,
        'Name': 'CF_CLOSE'
      },
      {
        'DataType': 'Utf8String',
        'Name': 'CF_DATE',
        'Utf8String': '16 AUG 2019'
      }
    ]
  }
}

Could you explain?

avatar image
REFINITIV
Christiaan Meihsl ♦♦ Marvin_deprecated_1 · Aug 22, 2019 at 11:40 AM 0
Share

@Marvin,

I just tried a search in the DSS GUI for GE5YUSAX=R and it responds "No Securities Found", which fits with an instrument that is no longer quoted. On the other hand, if I make a historical search in DSS it tells me that the instrument is quoted till today !

This seems contradictory, and I have no explanation for that.

The moderators on this forum do not have the required deep expertise in all the content sets available through our products to answer your question. I advise you to call the Refinitiv Helpdesk number in your country. They will either have the answer for you right away, or will reach out to the content experts who can provide the answer you're looking for. An alternative is to open a content-related enquiry via MyRefinitiv.

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 >
12 People are following this question.

Related Questions

Is there a way to limit the search results from the Datascope /Search/InstrumentSearch based on exchanges?

Update instruments in instrumentlist not working via dss rest call

Open Access RICs verification via DSS REST API

Hi, is there any c# sample code available for Stored & scheduled extraction. I have created a instrument list and report tamplate on web GUI and i just want to download it.

OLD RIC codes

  • 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