The most recent content from our members.
Hi, How do I mimic the Eikon TR.RecMedianLabel in Datastream using the RECMED value? In Eikon, the logic used to determine the label is as per below: In Datastream the logic used to determine the label: Therefore, if DSWS returns a value of 4 for the field RECMED, based on the above translation, the label would be “UPRF”.…
Hi all, I have a client who is using desktop DSWS and is trying to use the code ds.get_data(tickers='STATS', fields=['DS.USERSTATS'], kind=0) to view his user stats. Unfortunately this doesn't work for him : Exception Traceback (most recent call last) Cell In[21], line 1 ----> 1 ds.get_data(tickers='STATS',…
Hi, I have a fairly heavy task and the LSEG help desk recommended that I put this question here in the dev community. My team and I need to search and download data on equities (outstanding shares, price, dividend yield, etc.) traded on exchanges in 15-20 countries stemming back to the 1970's-present. My gut tells me that…
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…
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…
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 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
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,…
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…
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.…
It looks like you're new here. Sign in or register to get started.