Could you please help , how to get Bank of Canada Deposit Rate,US Fed Rate Lower Limit,US Fed Rate H
Hi ,
Currently we are extracting CDOR rates using DSS Rest API.
Can you please help how to extract below rates using DSS rest API
1. Bank of Canada Deposit Rate
2. US Fed Rate Lower Limit
3. US Fed Rate Higher Limit
Also, could you please let us know whether above rates are available in Refinitive DSS or not.
Best Answer
-
Thanks for your patience & as I can see a resolution was provided to you by the support team. I'm posting the findings provided here for the reference of other users if anyone else comes across the same issue:
1. Bank of Canada Deposit Rate
Unable to find the Deposit Rate on the source link - https://www.bankofcanada.ca/core-functions/monetary-policy/key-interest-rate/
We do have some data on the below RICs –RIC Name BID DATE
CADISC= CANADA DISCOUNT 0.50 02-Mar-2022
CAONMFR= CA ON MFR 0.4365 25-Mar-2022
CORRA= CORRA 0.4500 25-Mar-2022
CABANK= CAD DOM IR 0.75 02-Mar-2022
CAPRIME= CANADA PRIME 2.70 03-Mar-2022
2. US Fed Rate Lower Limit
3. US Fed Rate Higher Limit
We do not have separate RICs for US FED RATE Lower and Higher Limit. However, we do have RIC <USFFTARGET=> where the lower and higher limits are updated.
This can be extracted using Intraday Pricing Report only along with the following fields -
Lower -
General Value6
General Value6 Text
Higher –
General Value7
General Value7 TextHope this was helpful, and let us know if you have any more questions.
0
Answers
-
hi @RB5NBVICDORSupport ,
This forum is more for programming-type queries, rather than content queries. I would recommend you to contact the DSS support team directly via MyRefinitiv. However, for this case, ticket number 11083202 was raised on behalf of you and the support team is going to contact you to assist this soon.
0 -
please find an example request to retrieve the Bank of Canada Deposit Rate below
Request (replace the Token with your valid one)
POST /RestApi/v1/Extractions/ExtractWithNotes HTTP/1.1
Host: selectapi.datascope.refinitiv.com
Prefer: respond-async
Content-Type: application/json
Authorization: Token xxxxxxx
Content-Length: 749
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
"ContentFieldNames": [
"Trade Date",
"Universal Close Price"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "CADISC=", "IdentifierType": "Ric" },
{ "Identifier": "CAONMFR=", "IdentifierType": "Ric" },
{ "Identifier": "CABANK=", "IdentifierType": "Ric" },
{ "Identifier": "CAPRIME=", "IdentifierType": "Ric" },
{ "Identifier": "CORRA=", "IdentifierType": "Ric" }
]
},
"Condition": null
}
}Response
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "CADISC=",
"Trade Date": "2022-04-21",
"Universal Close Price": 1
},
{
"IdentifierType": "Ric",
"Identifier": "CAONMFR=",
"Trade Date": "2022-04-19",
"Universal Close Price": 0.9301
},
{
"IdentifierType": "Ric",
"Identifier": "CABANK=",
"Trade Date": "2022-04-21",
"Universal Close Price": 1.25
},
{
"IdentifierType": "Ric",
"Identifier": "CAPRIME=",
"Trade Date": "2022-04-21",
"Universal Close Price": 3.2
},
{
"IdentifierType": "Ric",
"Identifier": "CORRA=",
"Trade Date": "2022-04-20",
"Universal Close Price": 0.92
}
],0 -
and here's an example of the request to retrieve US Fed Rate Lower/Higher Limit
Request (replace the Token with your valid one)
POST /RestApi/v1/Extractions/ExtractWithNotes HTTP/1.1
Host: selectapi.datascope.refinitiv.com
Prefer: respond-async
Content-Type: application/json
Authorization: Token XXXXXXXXX
Content-Length: 596
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
"ContentFieldNames": [
"RIC",
"General Value6",
"General Value6 Text",
"General Value7",
"General Value7 Text"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "USFFTARGET=", "IdentifierType": "Ric" }
]
},
"Condition": { "ScalableCurrency": true }
}
}Response
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
"Contents": [
{
"IdentifierType": "Ric",
"Identifier": "USFFTARGET=",
"RIC": "USFFTARGET=",
"General Value6": 0.25,
"General Value6 Text": "Lower",
"General Value7": 0.5,
"General Value7 Text": "Upper"
}
],hope this helps
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛