-
Access Denied CBOEVIX
We are currently experiencing an issue accessing VIX index data through the Datastream API. While we do have access to the data via the Monitor app, the same data does not appear to be available through the API. Our account manager has advised us to contact your support service directly, as they are unsure what might be…
-
Using Datastream functions in DSWS
Hi, is it possible to use Datastream aggregation functions in DSWS? E.g. sth like F:VIE(SUM#(X(UDD),2023-01-09,2025-05-02))? Thx PS: Sorry if the question was already asked, the gateway was down so I couldnt perform a search…
-
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…
-
Full list of equity tickers
Hi, I'm trying to bulk download balance sheet data for all equities available in Datastream Web Services. For this purpose, I'm using Python. My plan is as follows: I will loop through the list of all countries I want to include and retrieve the tickers of all equities available for each country. Then, I will loop through…
-
Expired token errror in DSWS API
Client is getting attached error when trying to retrieve data using DSWS R API i can see the token expiry date is 31 march 2025 I checked previous Q&A cases here but they seem to be relate to RDP and not DSWS Please advise how to fix this. thank you
-
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…
