We are new to Datascope Select and we need to retrieve CDOR rate details template from Datascope ...

Best Answer
-
Determining the instrument RIC
The first thing is to determine which RIC contains the Canadian Dollar Offered Rate (CDOR) you are interested in. There are actually several, which you can find by using our Eikon product, or the RIC search tool in this portal, and typing CDOR as search criteria.
Here is a potential candidate result : CADBAFIX=
That said, please note this forum is aimed at software developers using Refinitiv APIs. The moderators on this forum do not have the required deep expertise in all the content sets available through our products to precisely 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.
Requesting data for a RIC
Once you have the RIC(s) you need, you can request the data. You do not specify what "details" you are interested in, so I'll give you a generic answer: when you want to find a specific data field, you should check the DSS Data Content Guide. Open tab "Field Descriptions", and use a text filter on column D or E to display only the rows that "contain" a keyword that defines what you are looking for. The results will show in column C which templates (request types) will deliver that field. Base on that you can request the data, using either the GUI or the API. Our tutorials show many examples of data requests.
0
Answers
-
Hi @Gopi Jaladi
Just to expand on Christiaan's response, if you need official Content, Product or other support you can contact our Helpdesk to raise a Case by signing-up to MyRefinitiv the self-service portal. This would be the best approach if you want to confirm which constituent RICs/Chain RICs or File Codes to use.
In DSS that you can also use File Codes to add into the instrument list:
https://hosted.datascope.reuters.com/datascope/search/default.aspx?scr=IPC
File Codes for CDOR appear to be 172 ('real-time' RIC constituents), or 3487 ('delayed' RIC constituents)
In DSS you can also search for the Chain RICs (exact match search only) here: https://hosted.datascope.reuters.com/datascope/search/default.aspx?scr=CHN, ie. CADBAFIX=
It is also worth mentioning that depending on if using 'real-time' or 'delayed' you may get some embargo, suppressed or other messages printed out in the DSS Notes file post-extraction. If there are any permission messages related to the RICs it is worth raising with your Refinitiv Account Manager to discuss these further.
0 -
On-Demand Intraday Pricing request example using File Code 172:
//Create the request
var extractionRequest = new IntradayPricingExtractionRequest
{
IdentifierList = InstrumentIdentifierList.Create(
new[] { new InstrumentIdentifier { Identifier = "172", IdentifierType = IdentifierType.FileCode } }, null, false),
Condition = new IntradayPricingCondition { ScalableCurrency = true },
ContentFieldNames = new[] {
"Instrument ID", "Instrument ID Type", "RIC", "PE Code", "Exchange Code", "File Code", "Asset Type", "Currency Code", "Trade Date", "Bid Price",
"High Price", "Low Price", "Open Price",
"Previous Close Date", "Previous Close Price", "Security Description" }
};
//Extract - NOTE: If the extraction request takes more than 30 seconds the async mechanism will be used. See Key Mechanisms
var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
var extractedRows = extractionResult.Contents;
//Output
if (!extractedRows.Any())
Debug.WriteLine("No rows returned");
else
{
foreach (var row in extractedRows)
Debug.WriteLine(
row.Identifier + " (" + row.IdentifierType + ") " +
String.Join(", ", row.DynamicProperties.Select(dp => dp.Key + "=" + dp.Value)));
}
//Output Notes
Debug.WriteLine("NOTES:");
foreach (var note in extractionResult.Notes)
Debug.WriteLine(note);0 -
Hi Gareth.teage,
Thanks a lot for your response.We are able to extract daily CDOR rates using your File Code 172:. But we need to extract CDOR rates for specific date? is it possible to extract past CDOR rates from datascope using Rest API?
Is there any sample code to retrieve old CDOR rates from datascope using rest api?.
Thanks in advance
0 -
Hi Gopi,
To access historic rates you'll need access to one of the following templates which contain historic end of day prices:
- Price History (Date Range)
- Single Price History (Single Date)
or the templates:
- Timeseries Pricing (Date Range)
- Single Historical Price (Single Date)
Access to these can be checked via the DSS GUI: https://hosted.datascope.reuters.com/ at: https://hosted.datascope.reuters.com/DataScope/preferences/default.aspx?tab=Permissions
Best regards,
Gareth
0 -
An modified example of this for date range 1st Dec 2015 to 2nd Dec 2015 would be:
//Create the request
var extractionRequest = new PriceHistoryExtractionRequest()
{
IdentifierList = new InstrumentIdentifierList()
{
InstrumentIdentifiers = new[] { new InstrumentIdentifier { Identifier = "172", IdentifierType = IdentifierType.FileCode } }
},
Condition = new PriceHistoryCondition()
{
QueryStartDate = new DateTimeOffset(new DateTime(2015, 12, 1)),
QueryEndDate = new DateTimeOffset(new DateTime(2015, 12, 2)),
LastEntityOnly = false
},
ContentFieldNames = new[]
{
"Instrument ID Type", "Instrument ID", "Usage Instrument Type", "Usage Instrument SubType", "RIC", "Trade Date", "Universal Close Price"
}
};
//Extract - NOTE: If the extraction request takes more than 30 seconds the async mechansim will be used. See Key Mechanisms
var extractionResult = ExtractionsContext.ExtractWithNotes(extractionRequest);
var extractedRows = extractionResult.Contents;
//Output
if (!extractedRows.Any())
Debug.WriteLine("No rows returned");
else
{
foreach (var row in extractedRows)
Debug.WriteLine(
row.Identifier + " (" + row.IdentifierType + ") " +
String.Join(", ", row.DynamicProperties.Select(dp => dp.Key + "=" + dp.Value)));
}
//Output Notes
Debug.WriteLine("NOTES:");
foreach (var note in extractionResult.Notes)
Debug.WriteLine(note);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
- 684 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 249 ETA
- 554 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 643 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 192 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛