-
How do I get the Eikon equivalent of calcdate in dsws API?
How do I get the Eikon equivalent of calcdate in dsws API? The Eikon API call is: =@TR('ASX300 List'!J3:J500,"TR.RecMean.calcdate;TR.NumOfRecommendations;TR.NumOfStrongSell;TR.NumOfSell;TR.NumOfHold;TR.NumOfBuy;TR.NumOfStrongBuy;TR.PriceTargetMean;TR.RecMedian;TR.RecMedianLabel","SDate=1D CH=Fd RH=IN",$AB$1) DSWS API call:…
-
My question relates to the Eikon API in python
I have a combination of RIC and a timestamps called let's say 'time' from 2024-05-27 to 2024-06-07. The combination represent trades for which I want to pulled data. I tried using the get_history() function from the RD library and find historic BID and ASK prices at 1 minutes interval. Since I have close to 10K unique RIC…
-
Import csv list of DSCodes in DSWS API
Hi, I'm trying to run DSWS request using a list of dscodes from a csv vile, but the code I'm using adds "[]" before and after the list, it's returning error. Here's my code instruments= [] with open('DSCD list1.csv') as csvDataFile: csvReader = csv.reader(csvDataFile) for row in csvReader: for ticker in row:…
-
How to search for a stock using ISIN and ISOMIC combination in DSWS
How do I search for a stock using ISIN and ISOMIC combination in DSWS so I can retrieve stock on a specific exchange? E.g. DE0005810055 XETR
-
Getting error trying to install DatastreamDSWS2R in R Studio
R studio - DatastreamDSWS2R error 2.pngR studio - DatastreamDSWS2R error.pngI cannot seem to install DatastreamDSWS2R package into R Studio, and when trying to run below code, i get error. pls assist. First attachment is what i see when trying to install dsws package. Second attachement is when trying to run a sample code,…
-
Querying DatastreamDSWS2R with RICs
Hi, Is it possible to query DSWS via R using package DatastreamDSWS2R with RICs instead of DS codes as identifiers? I tried the following but it won't work because it requires DS code @AAPL instead of AAPL.OQ. If this is not possible, can you suggest a workaround to get the DS codes from a list of RICs? cheers…
-
Datastream API is intermittently giving a Read Timed Out error
We have a number of jobs that use the Datastream API at the same time. They will each pull data (sometimes the same data) to calculate different models. We will intermittently get a "Read Timed Out" error: ``` requests.exceptions.ReadTimeout: HTTPSConnectionPool(host='product.datastream.com', port=443): Read timed out.…
-
Find WorldScope Item with DatastreamDSWS2R API for a universe of stocks
Hi, what is the approach to finding a WorldScope Item, e.g. Interest Coverage Ratio (EBIT/Total Interest Expense) Worldscope Item WC08291 for a universe of all US Stocks? I've tried for the NASDAQ 100 nut even for the 100 stocks some of the Interest Coverage Ratios are not reported, is this a license issue on my side?…
-
Datastream DSWS Time out Error
Thank you for your hard work. I'm currently using the Python API for Datastream DSWS, and I'm experiencing a timeout error when calling the Datastream object. I'm posting this question to inquire about the possible causes.
-
Datastream - How to retrieve all series that match my filters or categories?
I want to pull time series data for Datastream mnemonics that match a certain criteria. Datastream interface/desktop has categories for time series that allow you to filter your search to the relevant results. For example you can search for all time series that match: Type=Commodities, Country=USA, Activity=Dead,Settlement…
-
Beta Expression in R via Datastream API
Hi, I am trying to run an expression in r using the DatasteamDSWS2R package. I have be able to get a more simple expression working, but for what ever reason the formula supplied is not generating any data. mydsws$timeSeriesRequest( instrument = 'A:BHPX' expression =…
-
How to use Datastream formula that exceeds 45 characters without creating Expression in DSWS
I'm trying to use REGB#(PCH#(CFM#(ASXAORD,VAL),1M),PCH#(CFM#(X,VAL),1M),60M) , but due to char limit, i had to build expression 'E3BT' from below in DSWS. beta_DS = ds.get_data(tickers='<BHP.AX>', fields = ['E3BT'], kind=0) beta_WS, err = ek.get_data(['BHP.AX'], [ 'TR.BetaFiveYear']) print(beta_DS) print(beta_WS) Is there…
-
A client is installing DSWS to use in Jupyter. He already has wincertstore installed but is getting
A client is installing DSWS to use in Jupyter with Python. He already has wincertstore installed but is getting the error message: AttributeError: module 'wincertstore' has no attribute 'CertFile'. Please can you advise?
-
DACSStation Web Services API - How to connect using HTTPS in Java SOAP client?
I am developing a Java-based client that accesses DACS Station via the WSI SOAP interface. It works fine where connection is allowed just using HTTP, but now I need to connect to an instance where only HTTPS access is allowed. The Developers Guide gives info on a method setting DACS_SSL_INFO where using the…
-
How to show names of datatypes in dsws
Hi team, may I know how to let dsws show the names of datatypes? Thanks in advance!
-
how to get date in dsws
Hi team, I've got a question regarding dsws. If retrieving single filed and startdate = -0D, then the result will not showing the actual date of the data. e.g. df = ds.get_data(tickers = '@:CNM1E1', fields = ['A12FE'], start = '-0D') the result will be showing index, instrument, datatype, value and currency However, if…
-
Can I create an Expression CORR#(X,Y) working in the API with two variables X and Y ?
This expression works fine : CORR#((ACH#(LN#(X(RI)~E),1M)),(ACH#(LN#(TAUGVG4(RI)~E),1M)),120M) but as you can see I need to declare one of the two variables (TAUGVG4 in this case). I would like to know if it is possible to create an expression with two symbols variables working in the API ? So a formula like this…
-
Datastream API ISSUES
Hope you are well. We have a joint issue with the datastream API. Both Alex and I get the following error message: Traceback (most recent call last): pydatastream.pydatastream.DatastreamException: Undefined: Could not load file or assembly 'Newtonsoft.Json, Version=6.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed'…
-
Static requests for DSCD in DatastreamDSWS are incomplete?
I use python (3.6) and DatastreamDSWS (1.0.8) to make a set of static requests to obtain the ‘DSCD’ for a list of SEDOLs: * When I query certain SEDOLs, I get back NA where I would expect to get a value: * An example is SEDOL ‘2076009’ (Bank of Montreal):* I get NA for DSCD when I do a static request using DSWS * When I…
-
Datastream DSWS change time zone of data
Hi, What is the default time zone of the data that Refinitiv Datastream DSWS API returns and does it support changing the timezone of the data to local time? Suspect the default is New York Close but can this be confirmed please. Can it be specified in ds.get_data() function when pulling data from the API or how can I…
-
Cannot retrieve data from DSWS
We have a batch job runs every 10min – getting new token and making the request to DataStream (https://product.datastream.com/DSWSClient/V1/DSService.svc/rest/GetData) each time Body of GetData: { "DataRequest": { "DataTypes": [ { "Value": "PI" } ], "Date": { "End": "2023-05-05", "Frequency": "D", "Kind": "0", "Start":…
-
Best way to refresh data from an existing DSWS API.
Please can someone contact me to discuss the most effective way to refresh data. I'm currently aware of someone who is refreshing an entire dataset (rather than just the most recent) which is causing issues with them reaching their data capacity limit. Thanks in advance.
-
How can I get list of ticker in exchange from RDP Rest API ?
Hi, I can't find which api to call to get stock list for an exchange. What is it called? I'm trying to figure out price relations of stocks but can't get list. Thank you.
-
How to retrieve the names and tickers from a List (DSWS)
Using Codebook, How do we map the names/tickers in the result below? It only shows Instrument number: # get constituent list df1 = ds.get_data(tickers='LS&PCOMP|L', fields=['P'], kind=0) # get a subset of first 50 instruments #slist = ','.join(df1['Instrument'].tolist()[0:50]) # get timeseries data for it df2 =…
-
Unable to download data using DSWS API in Python
Hi, I am no anymore able to download data via DSWS API in Python. A few days ago everything worked properly, but suddenly is not working anymore. Please see below my request and the error that I got. I have already checked my credentials here and everything seems okay. import DatastreamDSWS as DSWS # set datastream…
-
DSWS fetch green revenue data of FTSE
Hi team, may I know how to fetch Green Revenue data of FTSE from DSWS? For example giving ric of 000001.SZ, how to get the green revenue data fields? Thank you.
-
DSWS guide & other questions
Hi team, a few questions regarding DSWS: 1. Which python package is the official and will be continue supported one, DatastreamDSWS or pydatastream? 2. I tried (DatastreamDSWS) df = ds.get_data(tickers='VOD,BARC', fields=['PH','PL'], start= '-2D', retName = True) but got error below: TypeError: get_data() got an unexpected…
-
Glossary of Data Point headings and definitions
Hi All, Can you please advise if there is a glossary of possible Data Point headings in DSWS API, and their respective definitions? For example: P = Price MV = Market Value VO = Primary Exchange Volume Or how best should I search for available Data Points re trading volumes? Thank you in advance for any help!
-
Daily EPS Trailing 5 years of a company using REST API
Is there a REST API that I could use to retrieve daily EPS Trailing 5 years of a company?
-
Can you pass a variable for DSDateFrequency
Hi, I'm using the .net API for DSWS I want to retrieve the last available value and date from a time series for a date range. Is it possible to pass in a variable for DSDateFrequency ? DSDataRequest reqDSRequest = new DSDataRequest() { Instrument = new DSInstrument("VOD"), DataTypes = new DSDataTypes("P"), Date = new…
-
Latest Revenue available prior to specific date - DSWS API
Hi, I'm using the .net API for DSWS I want to retrieve the last available value and date from a time series prior to a specific date. For example: DSDataRequest reqDSRequest = new DSDataRequest() { Instrument = new DSInstrument("VOD"), DataTypes = new DSDataTypes("WC07240"), Date = ??? }; Is this possible ? Thanks, Fergal
-
Datastream DSWS: fundamentals date
Hi - I'm using WC07240 (Net Sales), but I have a problem when I set the variable dtAsOfDate to previous business day which gives me NA for my stocks. I want to see the relevant value + date for this item for my stocks - but how can I get this? Date = new DSSnapshotDate(DSDateType.Absolute(dtAsOFDate)
-
DSWS API Error Codes
Hi everyone, is there somewhere a complete list of all possible error codes the API can return with an explanation? Examples: $$ER: 0904,NO DATA AVAILABLE or $$ER: E100,INVALID CODE OR EXPRESSION ENTERED Thank you very much for your help!
-
How to clean the output of data
Hello, I have the code below. import DatastreamPy as dsws import pandas as pd # set up connection def connection_DSWS(): DSWS_username = open("DSWSUsername.txt","r") DSWS_password = open("DSWSPassword.txt","r") ds = dsws.Datastream(username = str(DSWS_username.read()), password = str(DSWS_password.read()))…
-
Is there an option to receive TimeSeries data in reverse order from Datastream Web Service?
Hello, I am trying to receive TimeSeries data from the Datastream API in Excel VBA under Windows, using the code examples shown in https://product.datastream.com/DswsClient/Docs/AboutRestSvc.aspx . The data comes back as oldest to latest, but I would like to reverse this order (from latest to oldest ). In the Excel DSGRID…
-
Daily data being retrieved despite using a quarterly frequency
Hi Team, I have a client who is new to DSWS. He is using the below request and wants just one datapoint for each month. Instead he is retrieving the data at a daily frequency (see code and output below). This is economics data (GDP) which is published quarterly. I have run the same request but I get the data back quarterly…
-
check quota usage using R package DatastreamDSWS
hi, how can I check quota usage using R package DatastreamDSWS? I tried the following but I get NA mydsws <- dsws$new() myData <- mydsws$snapshotRequest(instrument = c("STATS"), datatype = c("DS.USERSTATS"), requestDate = "0D") thanks
-
List of stocks in an exchange via DSWS
Hi, how can I get a list of all stocks in an exchange (e.g. NYSE) via R DSWS API (even better if via R package DatastreamDSWS2R). What I am trying to get is the something analogous to what one would get via DFO's Navigator, pulling a list of stocks in an exchange, with a given set of filters (e.g. active, major, geographic…
-
How to deal with stocks that changed their names in DSWS
I’ve got an issue where I can’t return these DataStream datapoints for changed Sedols (due to corporate actions), could you help? So, for example, RBS.L (sedol B7T7721) was a ticker on the LondonStockExchange, but around 21/Jul/2020 I it changed to NWG.L (sedol BM8PJY7) When I run the DataStream with the old sedol for a…
-
Charts via DSWS or any other API?
Dear all, I have received the following question from a customer: "We have used a url to retrieve this type of graphs like the following example: https://refini.tv/3NyvoSK This sample url is retrieved from Refinitv Eikon, where we use this in the AS IS situation for a few hundred fixed isin codes. But we need to make this…