-
Unexplained price jump for bond by DSS
I am trying to get historical close price timeseries for a bond DE000HLB74U8 via Datascope Select (PriceHistoryExtractionRequest). Full API request below. I see end of 2022 a price jump by factor 10: { "IdentifierType": "Isin", "Identifier": "DE000HLB74U8", "Trade Date": "2022-12-27", "Last Trade Price": 92.499, "Universal…
-
DSS 401 Forbidden Error
Raising this on behalf of my colleague who is experiencing issues when running a DSS script: > dss_auth(user_id = 'XXXXX', password = 'XXXXXX', force = TRUE) Error in `httr2::req_perform()`: ! HTTP 401 Unauthorized. I have 'x'd' out the account details. Please can somebody provide some inclination as what this error is…
-
Search for RICs by Bloomberg ID/Identifier
One of our customers has Bloomberg IDs in his data we are going to process. For that data we need market data for further processing. Is there any way to look up RIC codes by using Bloomberg identifiers (Ticker codes / Bloomberg ID, ...)? Thanks in advance!
-
How do I convert DSOS SQL Database / DSW query into Python programming query?
I want to run Python query in snowflake to access DataScope Warehouse, but I only have DSOS SQLs which Snowflake does support, but I want Python codes to access DSW for my customers. Could you assist please? Thank you
-
Recent DSS output files are not found in SFTP reports folder.
https://us.v-cdn.net/6038239/uploads/OZ48GJ4YNQDU/sftp-reports-folder-screenshot-from-the-client.docx The existing DSS user (Narrative Tapestry, DSS ID:9039653 ) developed their own SFTP system and is currently testing it. They could log in DSS normally and retrieve data from the reports directory, but the files they are…
-
DSWS in RStudio - 403 error suddenly appearing
Hi I've used Datastream on excel quite a lot - trying out the API through Rstudio first time. The below code worked perfectly till about a day ago, but has now started generating errors as shown. Pardon the formatting that is messed up on copying code and output below. As you can see the error is appearing on the call to…
-
Client is unable to log into the API using Visual Studio
User ID – 9021571 Using latest code under below link https://developers.lseg.com/en/api-catalog/datascope-select/datascope-select-rest-api/download, but still unable to login, please check and advise.
-
I have some C# code that communicated with Datascope and worked as recently as 2023. It doesn't seem
client confirmed saying they already have .NET version 4.8 installed 2. Client provided the below logs C:\Izzy\DatascopeRestAPI\dss_rest_net_sdk_tutorials_code\Tutorial 2\Learning\restful_api_core_gui_basics\bin\Debug>restful_api_core_gui_basics.exe Unhandled Exception: DataScope.Select.Api.TransportException: An error…
-
How to correctly convert currency in PriceHistoryExtractionRequest
Hi, I need to programmatically convert historical EOD prices for ISINs over a certain time horizon to EUR. I struggle to correctly apply the conversion when the prices are stated in a minor currency such as GBp. Example: I want to convert the EOD prices of ISIN "GB0008706128" (Lloyds Bank) - which is denominated in GBp -…
-
Are contract rics unique?
I expected that rics representing option contracts on futures or indices would be unique. However I found an example "TY131Y5Z" of a contract ric that represents an option on both 3TYZ1 and 3TYH2. My question is: is there a cutoff date after which I can expect contract rics to be unique?
-
What is Refinitiv's DSS data and is tick size available in it
Hi Team, RFA API version 8.2 to consume market data and I want to check about the 2 things What is Refinitiv's DSS data? Is tick size available in Refinitiv's DSS data? Thank you in advance
-
deleting pending requests.
I see some pending extraction requests i'd like to delete but could not find anything in the API docs related to deleting pending requests. [{'JobId': '0x095ae227ca7b01ca', 'UserId': 9023248, 'Status': 'InProgress', 'StatusMessage': 'InProgress', 'Description': 'HistoricalReferenceReportTemplate Extraction', 'CreateDate':…
-
Query About DSS API
I'm working to query RICs using the DSS HistoricalCriteriaSearch API. I see that the responses are limited to 30k records max. Is there a way to paginate the query? https://selectapi.datascope.refinitiv.com/RestApi.Help/Context/Operation?ctx=Search&opn=HistoricalCriteriaSearch also, could you provide an example of a…
-
PYTHON API Extraction Not Yielding Results
Hi Team, Hoping for your help in checking the code of the client below, for some reason, they are not receiving any results when querying for MarketDepth: Code: def ExtractRaw(token, json_payload): try: outputfilepath = str(_outputFilePath + _outputFileName + str(os.getpid()) + '.csv.gz') if os.path.exists(outputfilepath):…
-
How to get Futures OHLCV from DataScope Select Rest API in Python3?
I would like to get the following RIC OHLCV using DataScope Select's Rest API in Python3. Could you provide sample code? RIC : .SPX DSP : S&P 500 Index - CBOE