-
host='selectapi.datascope.refinitiv.com', port=443 Error
Hello Team I am getting this error, could you please help on the same- requests.exceptions.ProxyError: HTTPSConnectionPool(host='selectapi.datascope.refinitiv.com', port=443): Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken (Caused by ProxyError('Cannot connect to proxy.', RemoteDisconnected('Remote…
-
DSS Rest API Sample Code for Elektron EOD
Can we add or share Rest API Sample Code for Elektron EOD? currently we only have for DSS EOD and Intraday Or can help confirm if we need any change on condition between Elektron EOD and EOD? Much appreciate it
-
ASX Tick Size Tables via RDP or ?
Hi, I'm trying to determine how or where I can receive the Tick Size Tables for a stock on the ASX Market. There is a standard tick size/price steps table shown below. However the note in the screen shot below indicates other security types can different rules. The ASX documentaton…
-
Unable to generate security Token using Datascope API using C# code
-
Retrieving RIC Code Using FundSearch Endpoint
I am performing a fund search using the following endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FundSearch Despite specifying "PreferredIdentifierType": "Ric" in my request, I am consistently receiving ISIN codes instead of the desired RIC code. How can I ensure that I get RIC codes?
-
ExtractWithNotes returns different ISIN results than the one requested
https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes returns some other ISIN than the one requested for. This could be due to the underlying ISIN combinations. But we're expecting that the API returns correct response with the requested ISIN.
-
"message": "Malformed request payload: Syntax error at Line 1, Char 1: expected valid json array or
I'm making an http request to the api using the below details but I'm getting the 400 error with the above message. URI: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes Headers: { "Accept": "application/json; odata.metadata=minimal", "Authorization": "Token xxxxx", "Content-Type":…
-
Derivative Ric resolution
What is the best way to resolve a Ric for a derivative (OPTION/FUTURE)? I know there is a mechanism to do this using SFTP, but is there a way using an http api. Thanks.
-
I am trying to fetch the Current Month FX Rates from the Refinitiv using API's.
Hi, I am new to refinitiv. Currently i am using Datascope Select to fetch the daily FX Rates using Instrumental List and Scheduler. Now i am struggling to fetch the FX Rates based on the current month average price. Eg - If the current date is 2-Jun then it should send me 2 days average OR FX Rates of two days(average i…
-
Extracting fields from 2 or more reports in DSS using API
Hello, I have 16 K list of RICs that i need to pull data for a month from 3 DSS templates. Can you tell me how I can do this via REST API (postman code) Field DSS Template Bid Elektron Timeseries Ask Elektron Timeseries Universal Ask Price Composite Universal Bid Price Composite Universal Close Price Composite Close Price…
-
Datascope select monitoring api respond-async wait time
Hi, I am building a system to process hundreds of requests for many different users, for the Datascope select api for TickHistoryTimeAndSalesExtraction. My plan is to handle asynchronicity in the application by calling the monitor api (i.e. /RestApi/v1/Extractions/ExtractRawResult(ExtractionId='0x123456789')) every 30…
-
Datascope select asynchronous requests best practice
Given that the datascope select api typically has a rate limit duration of 60 seconds, why would I have a wait time of less than 60 seconds on an asynchronous request, given that the request will be returned as soon as a result is available anyway? Take the following example, an asynchronous request takes exactly 45…
-
timebar persistence
I did ask this question earlier, however the response received did not solve the problem. in the code below, when i use, "TimebarPersistence": "false", i still receive carried over values (i would not expect to see quotes on Saturday and Sunday). note: ticker1 is defined as "JPY="…
-
Matlab TRTH Timeseries - Getting two days of data when requesting a year
I am using Matlab to connect to the Datascope API (TRTH). When I try to pull a year's worth of timeseries, intraday data using the below code, I get back two days of data rather than the requested year's worth. I am not specifying an interval in order to get back unaggregated results. I have tried putting in two digits on…
-
REST API error message for ISIN DU00000COCHA reflecting as ISIN DU00000COCH3
Hi, Wanted to check on the below issue where using DSS REST API for ISIN DU00000COCHA, getting the error message reflecting as ISIN DU00000COCH3 not found under Terms and Conditions Report Template. I am using DSS Rest API extraction and Identifier List is having ISIN as DU00000COCHA which is a Dummy ISIN, however in the…
-
How to create Scheduled Extraction for SSS Intraday Pricing report template
One of our prospects would like to create recurring weekly Intraday Pricing scheduled extraction over DSS. Can you advise how to code in REST API? I tried to search Postman codes, but cannot find a such example.
-
Historical AuM (and other data) of PE Fund Managers
Dear Community, I'm working on a project to analyze the investment behaviour of different groups of fund managers in the PE universe. Therefore, I'm considering PE deals within the last 15 years. In order to control for firm size, it would be optimal to retrieve historical AuM for each firm for each year (expanding this…
-
Search API - what are the available columns name for select and filter arguments?
Hi, I am using refinitiv.data.content.search.Definition() which has two argument select and filter. My question is how can I know which columns name are available for specific views and how can I select all columns. "*" doesn't work. For example, in screenshot, your example code select columns…
-
datascope rest api
Hello, Example of Chain Ric: 0#GBPVOLSURF we only use LONGNEXTLR,LONGLINK1,LONGLINK2.....LONGLINK14 fields and when i connect { "Identifier": "0#GBPVOLSURF", "IdentifierType": "ChainRIC" } which field show LONGNEXTLR value. In this example LONGNEXTLR fields result :1#GBPVOLSURF .
-
DataScope Equities Non-Standard Futures RIC
DataScope Equities IT record field 14, Last Trading Day, is blank for futures series "CBOE Futures Exchange LLC Market Volatility TAS Index Spread" Why is it blank? Also the RIC is not the standard format. We would expect, for example VXTG4-M4 However, we are receiving an extra S and B as follows. VXTSG4-BM4 Is this for…
-
Tick History get Market Maker and Market by Order Data
Hi, I am trying to use DataScope REST API to retrieve Market Maker and Market by Order data via Tick History. I tried both `TickHistoryMarketDepthExtractionRequest` as well as `TickHistoryRawExtractionRequest` templates, but both fail to expand to any RICs. Request URL:…
-
DataScope Select Search API failing when maxpagesize variable is set
Hi, I've noticed when using the following payload and headers: payload = json.dumps({ "SearchRequest": { "ExchangeCodes": [ "CMX" ], "IdentifierType": "RICRoot", "Identifier": "GC", "AssetStatus": "Active", "FuturesAndOptionsType": "FuturesOnOptions" } }) headers = { 'Prefer': 'respond-async;odata.maxpagesize=100000',…
-
Can I get trade start date from Ric Child Info
https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes The child Ric information of option data is obtained from the above API. It seems like I can get the expiration date, but I wonder if it's possible to get information on when the transaction started. If the expiry date is the end, I would…
-
Hi, I am trying to fetct historical option chain data for TSEC weighted index (.TWII). could you guy
Hi, I am trying to fetct historical option chain data for TSEC weighted index (.TWII). could you guys help me with the instrument chain RIC for the same.
-
NSI - Mkt. Condition - Qualifiers
Using DSS for NSI (XNSE), is there a document with definitions for the qualifiers for the mkt. condition msg types? I do not see them shown in the attached document with the venue specific qualifiers. is there a general qualifiers definitions doc I can reference?
-
RawExtractionResults return jobId instead of data
For example: A GET query to https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/RawExtractionResults('0x08b018d5e039394b')/$value returned HTTP/1.1 200 Connection established HTTP/1.1 200 OK Cache-Control: no-cache Pragma: no-cache Content-Type: application/json; charset=utf-8 Expires: -1 Server:…
-
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
-
To add row count in the trailer for TermsAndConditionsReportTemplate
i am trying to add the number of rows at the trailer of the records. However, i keep hitting error 400. Below is the error message and what i entered under "Conditions" Error {"error":{"message":"Malformed request payload: Error while parsing an enum value: Requested value 'Row Count' was not found."}} Values entered…
-
We are getting TLS1.1 not supported error while using .NET Framework 4.8 and DataScope.Select.RestAp
client is claiming when they run custom extractions and downloading the output file with S3 direct header they are getting below error: We got TLS errors frequently today (maybe since last week). We had to retry several times to get the files downloaded, and this caused delays. Take file DAILY-1MIN-EURO2-20230825.csv.gz…
-
Need access to daily interest rates
Hi, For a new project we need daily access to various central bank daily reference interest rates (avareges), including: * Fed Fund Rate * deposit facility rate * SARON – Swiss Average Rate Overnight * SONIA – Sterling Overnight Index Average * ON Deposite Rate * CORRA – Canadian Overnight Repo Rate Average * AUD Overnight…
-
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.
-
How to convert RIC code from auto-listing to contract month?
Hi, Now, i get data of LCOc1, LCOc2 from Tick-History. But how can i change from our auto-listing code into non-auto-listing code? and can i search the code via webui of "datascope select"? Thank you very much, Petch
-
Any suggestions why I'm getting host name invalid ? "HTTP Error 400. The request hostname is invalid
INvalid Host Name error_TH API.png Any suggestions why I'm getting host name invalid ? "HTTP Error 400. The request hostname is invalid.</p>" The question has been raised internal only.
-
Cloning Datascope Plus Account and retaining reports from one user to a new account/user
Hi there, I am wondering if it is possible to "clone" a user that is currently setup on Datascope Select (with tons of configurations and reports present) onto a new different account/user with the same content as the first user? The new user would have a different login/password but essentially have the same set of…
-
Can we club two report templates in one API call
Client wants to use one API call for two different report templates(Terms and Condition / Ratings) is this possible. If yes request you to kindly share a sample API Code.
-
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 &…
-
DSS Rest API and Azure
Hi, client mine wrote: "We are experiencing performanceproblems in our testenvironment and therefore one of our application developers went through your document on REST-API and found a section with a recommendation NOT to use this in combination with Azure. We have plans to migrate our application using Azure during…
-
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…
-
Information about ask and bid
Hi, I'm new and I would like help about DataScope. I need information about book, especially I need the last five and the first five positions/orders of ask and bid, in a certain point on time? What is the best way to extract this information? Tick history, or Tick History Raw, or other? Thank you