-
Are DatastreamUCS and DatastreamNavigator officially supported LSEG packages?
Hi, I found two Python packages on PyPI — DatastreamUCS and DatastreamNavigator — that appear to be related to the Datastream Web Service. The PyPI author field lists "London Stock Exchange", and the packages seem to provide features not available in DatastreamPy, such as Navigator search integration and economic filter…
-
Periodic Total Return for specified dates & currencies using Datastream in Python
Hi, I would like to replicate the below excel formula using the python api. The goal is to get the total return of an Isin for a given period in a specific currency. In this case EUR. As we wish to do this for a considerable amount of Isins over multiple time periods, we wish to move from excel to Python to achieve this.…
-
historical data for brazilian stocks in dsws
I would like to pull historical data for price, dividend yield, ROIC, short interest, average daily volume, and others using DatastreamPy in Python for all index constituents (RICs: .BVSP, .MLCX, .SMLL) over the last 6 months. Since some stocks were delisted and others were added during this period, the request should…
-
How to pull historical financial data from ISIN's
Hi, =@DSGRID ($A$1:$A$1007,RI,P,PO,PB,PA,VO,IBNOSH,04/01/2025,,Daily,RowHeader=true;ColHeader=true;Heading=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=true;AutoRefresh=false) is what I used to pull the historical data for some stocks in the excel…
-
Use of Datastream Expressions
Hi ! I hope this finds you well. I'm trying to extract the performance of the EUR (for 3m and YoY) as well as the French 10Y yield. I was advised to use Datastream Expressions:- " Please consider using the Datastream Expressions that I presented (ex: PCH#(X,-3m) where X is the underlying series placed in the Series field).…
-
How to match PERMNOs (from CRSP) to RICs
Hi, I have a list of PERMNOs (from CRSP) and I’d like to know if there’s an easy way to find the corresponding RICs for these identifiers. My understanding is that each PERMNO should map to one unique RIC. For example, I have PERMNOs 10104 and 10107 — how can I match these companies with their respective RICs? Thank you!
-
Discontinued tickers
Hi, I have a question about discontinued tickers, namely following: 'CZFCS04' : ECBOT - 5 YEAR US T-NOTE CONT.INDX 'CZNCS04' : ECBOT - 10 YEAR US T-NOTE CONT.INDX 'CZUCS04' : CBOT - LONG TERM ULTRA ELEC. CONT.INDEX 'ATDCS04': SFE - AU 3 YR T-BOND DAY CONT.IDX Any reason why they are discontinued (all in this year). I was…
-
Migrating VBA Code from EIKON AdxRtList Library to Refinitiv Workspace
I am working on converting an Excel-based calculation tool that currently uses the EIKON AdxRtList Library to stream real-time underlying data. The goal is to adapt the VBA code so it works with Refinitiv Workspace instead of EIKON. Details: The VBA tool has the following components: A class module that interacts directly…
-
How to retrieve the historical list of all listed stocks at a specific past date?
Hello, I am working on an academic project and need to backtest a custom ESG equity index from 2010 to today. For this, I need to retrieve: The full list of stocks that were active at each monthly rebalancing date (e.g., January 2010, February 2010, etc.). (we can also limit this by geography saying only stocks in Europe)…
-
How can I pull historic Credit Ratings?
Hi all, I am trying to pull Credit Ratings for a list of Companies. I want the yearly issuer level credit rating from the years 2015 to 2023. What is the best way to go about this in Excel?
-
Datastream Excel: Trading Date in DSGRID
Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
-
Does DatastreamPy work with Workspace?
We use a Python script to retrieve some series from Datastream, using the package DatastreamPy. Will this still be possible after migrating from Eikon to Workspace? Are any actions needed?
-
MarketPsych ESG from DSWS API
Hello! I would like to extract MarketPsych ESG sentiment scores from Datastream DSWS API feed. Can you please provide the code? Thank you
-
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!
-
What are market release cycles for Equities and Futures on Datastream
Can I get access to some docs on what the market release cycles for equity and future data (pricing mainly) on Datastream
