-
python dsws tool DS_Response.py pandas performance warning
dsws gets a performance warning from pandas …\python3.12\latest\Lib\site-packages\DatastreamDSWS\DS_Response.py:361: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling frame.insert many times, which has poor performance. Consider joining all columns at once using pd.concat(axis=1)…
-
Dataset creation help needed
I am trying to create a dataset of the top 500 financial institutions in France that includes annual revenues between 2018-2023, assets under management for 2018-2023, firm type, and ESG information (including sustainability reports for 2018-2023 if possible!). Any guidance or ideas would be appreciated, thanks!
-
DSWS API returns invalid data
Hi, When I execute the following via the DSWS API I receive the following data: ds.get_data(tickers = '8857RL', fields = ['DSCD','ENAME','ISIN','RIC','T1C','LEI',] ,kind = 0) When I use the same DSCD in the web portal, the ISIN is correct. When I try to search the web portal for the ISIN returned by the API, I receive no…
-
Python- workspace excel implementation
Hi Team, Can you please answer two questions below? 1) Will new workflow (Python-Excel) implementation require additional payable data access licensing (for instance to data API licenses). If yes – then where can we find pricing? 2) Is there a way (please share some sample python file or reference) to initiate some…
-
Getting Module Error
How to fix this issue
-
Error using Datastream in R
addpkg('DatastreamDSWS2R', '1.9.7') library("DatastreamDSWS2R") options(Datastream.Username = " ZXXX000") options(Datastream.Password = " PASSWORD123") mydsws <- dsws$new() Error in rjson::fromJSON(myTokenResponse) : no data to parse
-
How to mimic the Eikon TR.RecMedianLabel in Datastream using the RECMED value
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”.…
-
Viewing DSWS Usage stats in DSWS desktop
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',…
-
Downloading Historical Equities data
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?
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…
-
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…
