-
Limit search results through API - DSS Rest API
Hello Team, Is there a way to limit results through API just like we can do in the GUI?? PFA screenshot - Thank you, Trisha Gehlot
-
RIC code is getting null for all the attached list of CUSIP identifiers.
We are getting ric code null when we call EndOfDayPricingExtractionRequest with CUSIP. List of CUSIP's are printed below as I am not able to attach the file Can any one quickly guide me on how to get RIC code not null for CUSIPs identifier., CSP,53945CKX7 CSP,802437FY4 CSP,13063DUD8 CSP,296385AT4 CSP,617403ES5…
-
How to call count API Hits In DSS
Hello Team, We want a better way to count API call hits, as One call, calls one more API call(As if Request_Url/nextlink is sent along with the result) We use - https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes &…
-
DSS REST API Delect Instrument from a InstrumentList
In DSS REST API Tree, there's no example about how to delete a Instrument from a Instrument List by 'InstrumentListItemKeys' so can you share the sample REST call to delete dummy item key , 'VjF8MHgwOGY3NTQyZTA1ODlmMmU2fDI'? '0x08f7542e0589f2e6', dummy IL. Two attempts below but failed. * POST…
-
Find all Rics in a chain
Hi, Can someone point me in the right direction please. I have a ChainRIC "1WSURF11" When I use DSS portal I can see all the consistuents for 1WSURF under the Open Access Constituents tab How would I find the same using the REST API? tnx in advance, Brian
-
Different API Keys for Prod and DEV - Datascope Select
We have a query on the API key being generated when using your API. For background, we are using the API in our production environment everyday but we also very periodically test pulling data into our dev environment too. At the moment, it appears both have the same API key which we are a bit worried about. Ideally, we…
-
How do we scale the RIC code/currency while requesting from SFTP method?
Dear Team, We are getting the output of below Instrument as 0.2806,0.2802 where it should be 0.002806,0.002802. We are trying to apply the scaling of 100 to this specific RIC code. Is there any guide to apply this scaling on this specific RIC code? Please support. <Instrument> <IdentifierType>RIC</IdentifierType>…
-
Duplicate Instrument List using DSS SFTP
The issue: * For a long time, the instrument list we use to upload instruments from Fusion into DSS remained the same as long as the instrument file name remained unchanged. The instrument file simply used to update the existing lists and NOT create a new instrument list. * As you know, the scheduled reports have to be…
-
Using a pre-existing instrument list and report template on DSS
Hello, I have 2 questions on DSS REST API: 1 - In the REST API Tutorial 9: On Demand extraction: instrument list -- we have a section showing how we can use instrument list existing in GUI in API. Is it possible to use pre-existing report template as well? If yes can you please provide sample format as shown in the…
-
DSS : stored and scheduled extraction and possible delay if we run identical schedules in API and s
This question is from one of DSS prospets. This client would like to retrieve DSS through API, but also would like to leave CSV files in DSS as a back-up just in case their API is failed (fyi, their connection will be Leased line). (1) Can we recommend Stored and Scheduled extraction on DSS? Can we schedule DSS extraction…
-
Where can I see the list of field in DSS?
I'd like to retrieve price data (USDJPY, N225, S&P500) in DSS and I made report templates that retrieve the fields (open_ask, ask_high, ask_low, ask_price, open_bid, ..., bid_price). But I could only get the USDJPY price and the N225 and SP500 prices were blank. Does anyone know more about this field?
-
code to bring all the rics from a source
Hi! I need all the rics for one source but when I run this code it only brings me the main ric of the source what Im doing wrong? { "Identifiers": [ { "Identifier": "ARARGE3209S6", "IdentifierType": "Isin", "UserDefinedIdentifier": "Instruments", "Source": "FTP" } ], "KeepDuplicates": false } thanks
-
SOAP API (DSS): getting multiple RIC codes
Hi, my client is using SOAP API with DSS, they are loading ISINs to list to be used with Composite report template. There is an issue where 10 ISINs can turn into 400+ RIC codes. What might be causing this? The same is not happening if I i do csv import (without exchange codes) with ISINs.
-
RIC for NYMEX Brent and ICE Crude Oil in Refinitiv
Could you help me find symbols in the historical Refinitiv API: 1. NYMEX Brent Oil 2. ICE Crude Oil I tried to search, but could't find the exact RIC for the commodities. Also, please could you verify that I used the correct symbols for: - ICE Brent: LCO - CME NYMEX: CL
-
ISO Country Code and CFI code from DSS Terms and Conditions Request
Dear All, I want to pass two different request to DSS Terms and Conditions Request. In one request i want to pass ISO 3166 as Country code and get the response. In second request i want to pass CFI Code: Code indicating the ISO10962 standard for the security classification and get the reponse. I want to get the response…
-
DSS how to get data for ISO currency and MIC
Dear All, Can we get the data from DSS for the below information ?: * Data source for Current Currency (ISO 3166) * Current CFI classification ISO 10962 * Country EEA Membership Information Thanks and regards , Rahul D
-
I'm using Stored & Scheduled Workflow to download TermsAndConditionsReportTemplate. However, i am fa
POST: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/TickHistoryTimeAndSalesReportTemplates Request: { "@odata.type": "#DataScope.Select.Api.Extractions.ReportTemplates.TermsAndConditionReportTemplate", "ShowColumnHeaders": true, "Name": "TermsAndCondition-Output", "Headers": [], "Trailers": [],…
-
how to get Settlement Prices using ChainRICs using DSS API?
Hello, I have following questions on ChainRICs using DSS API. 1. Can we extract Prices (Settlement Price or Universal Close Price) for all 'Valid Constituents' or live RICs using Chain RIC? 2. How should the Extraction Request look like? Example: ChainRIC 0#LGO: I need Extraction Request to pull following fields (in bold)…
-
How to get DSS EndOfDayPricingExtractionRequest historical data
Dear All, We are using below DSS EndOfDayPricingExtractionRequest which is working fine. { "ExtractionRequest":{ "@odata.type":"#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest", "ContentFieldNames":[ "RIC", "Security Description", "Universal Close Price Date", "Universal Close Price",…
-
Issue with Fetching Bond Schedule Data | Regulatory Capital Info
We are trying to incorporate a process where we can fetch the below two columns into our system. These are part of “Bond Schedules” Template and the Bond Schedule Type is “Regulatory Capital Info” “Loss Absorption Regulation Code” “Loss Absorption Regulation Code Description” But we are getting below error while trying to…
-
DSS API request RICs and get the fields as response
Dear All, We are using DSS REST API request and we need daily access to various central bank reference interest rates for below RIC: USF= USFFTARGET= ECBDF=ECBF SARON.S SONIAOSR= EUROND= CORRA= AUDOND= JPONMU=RR We need to request above RIC to the DSS Rest API request and get response for the below fields: * RIC * Security…
-
DSS Price Types Detailed Discussion
Do we have a detailed discussion of what is a Universal Close Price and the other price types available in DSS? Would like to understand each and their differences.
-
Request ISIN and get response for CUSIP, ISIN, TICKER and NAME
Dear All, I need information for example where when i request ISIN and then i should get response for CUSIP, ISIN, TICKER and NAME. I would like to know does Refinitiv provide this information together, if yes then which REST API i need to use and if possible are there any example already present. For example Linde plc’s…
-
Query DSS API with IdentifierType : Issuer PermID OR Issuer OrgID
Hi Team, We need to query DSS API on demand for all the ISINs of an issuer/company. Is there any way to get all the ISINs for an issuer using Issuer PermID OR Issuer OrgID as identifier type or Can we use any other identifier type to get this data (All the ISINs for an issuer/company). Thanks in advance.
-
Corresponding REST DSS API
http://datascope.com/select/ExtractionService/v1/ValidateInstruments Hi, may I know the corresponding DSS REST API for above SOAP API, or is there any replacement for the SOAP API in REST API? Thanks in advance.
-
Historical Search using .NET SDK API
I'm using the C# .NET API to query Tick History / DSS. Can you show me the API for Historical Search for an instrument where I can search by SEDOL code? Thanks
-
DSS REST API Search FuturesAndOptionsSearch getting Gold composite weekly options expiries
I want to get expiries for GC weekly options (specifically "0#GMW+", "0#GWW+" and "0#GCW+"). I usually use the datascope select search FuturesAndOptionsSearch rest api. I use this to get expiries for Equity Options ("0#SPX*.U and "0#SPXW*.U") but it doesn't work for GC weekly options. { "SearchRequest": { "FileCodes":…
-
unable to ping host "select.datascope.refinitiv.com"
Hi Team, I am calling DSS API with Oracle PL/SQ using apex_web_service.make_rest_request. we have created the ACL using the host => 'selectapi.datascope.refinitiv.com', We are getting ORA-53203: security violation error. To investigate this issue i am trying to ping selectapi.datascope.refinitiv.com but getting request…
-
CUSIP suppressed for lack of 'CUSIP & CUSIP based ISINs' and 'Shareholding Disclosure' permissions
Hi Team, I am calling the DSS API "https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes" for "CompositeExtractionRequest". I am getting CUSIP and SEDOL as NULL in response with below warning or error. Can you please help me to understand this warning/error CUSIP suppressed for lack of 'CUSIP &…
-
Market data extraction using DSS API
Hi Team, We are planning to extract the market data using Refinitiv DataScope Select API for our Shareholding Disclosure application. We are reviewing the available fields in "Refinitiv DataScope Select 17.1 - Fields by Report Template" to get the information for all the required fields. We need the information such as…
-
Index constituents limit DSS REST API.
Hi, one of my clients is trying to retrieve data for chain 0#.FTAWORLDSR with the use of Datascope Select API. It is a large index with around 3.900 constituents and they only get a reply back for 999 securities. It looks like there is a limit on 1.000 securities - see Notes file message: "Only 1000 constituents of CHAIN…
-
How to get historical values for TRGBNBPWKD?
Please can you list steps on how to get historical values (back till atleast 2018) for RIC 'TRGBNBPWKD'. 1. Is there a way to get it from TR GUI on EIKON in excel/csv format ? (preferrable) 2. If not, is there a way to retrieve it using RDP or DSS using Python? Thanks
-
Wrong Currency Code in DSS API
We are receiving for currency wrong Code on the API interface. Can you check and make change? Currency/ Country Code from Refinitiv Identifier Reason 'Currency Code': 'KWf' KW0EQ0601058 Correct ISO Code: KWD 'Currency Code': 'ZAc' ZAE000063863 Correct ISO Code: ZAR
-
What would be the API request message to collect an extracted file available on GUI?
What would be the API request message to collect an extracted file available on GUI?
-
Unable to get token - DSS API Python
Hello, I am getting following error while trying to request token: requests.exceptions.ConnectionError: HTTPSConnectionPool(host='hosted.datascopeapi.reuters.com', port=443): Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken (Caused by NewConnectionError('<urllib3.connection.HTTPSConnection object at…
-
DSS API using Python
Hello, Please can someone help with the following: 1. Is there a python based DSS API guide available? 2. Sample Python Code in DSS API to extract following RICs "CFI2Z5","CFI2Z6","CFI2Z7","CFI2Z8","CFI2Z9" OR a Sample code to extract any other RIC Thanks
-
DSS Composite extraction request returns null field values for ISIN
Hallo All, I am trying to fetch Composite extraction request data from Data Scope Select using Python. For some ISIN list i get the "Average Volume - 30 Days", "Average Volume - 90 Days" values. But for many other ISIN's, i did not get any values for "Average Volume - 30 Days", "Average Volume - 90 Days" and for those ISIN…
-
Monthly Rolling Performance of Equities (Total Return Accounting for Dividends & Splits)
Hello, * We are looking to build a return on $10K performance chart for the total return of an equity.* This total return would encompass any capital adjustments (Splits etc.), and dividends * I'm finding conflicting information about what is and is not available from DSS to achieve this* There seems to be an adjusted…
-
Where can I find closing auction volume data
Hi team, how can we get closing auction volume data in our DSS or tick history? Especially HK market. Thank you.
-
Retrieving RIC Contract Year and Month
Hello, I was wondering if there are "ContentFieldNames" for contract year and month? Using [second last, last] characters in the RIC for [month, year] is sometimes unreliable for me, since I have instruments that expire in 10+ years (e.g. NGZ34 for natural gas December 2034). I would prefer not to implement my own parsing…