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.
Best Answer
-
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.
0
Answers
-
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
0 -
@Marvin_deprecated_1, 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.
0 -
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?
0 -
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.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 280 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 720 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛