Request to review the simple query that client wrote & optimize it ds = dsweb.DataClient(username = auth_info['secrets'][1]['key'], password = auth_info['secrets'][1]['value']) # Golbal parameters start_date = '2008-01-01' # Listing of instruments per dataset instruments = { 'energy' : 'ETQC.01,LNGASIA,NATGAS1,LLCC.01',…
how can i determ if 800 different firms are family controlled using refinitiv for excel?
I have few other formulas on excel, and I am not sure how can I get that data via python, if you could please help me with that too? =@thomson .Reuters.AFOSpreadSheetFormulas.DSGRID("@:M3WRLD","A12MKC;AT0TOT;AT1TOT;AT2TOT;AT3TOT;AF0TOT;AF1TOT;AF2TOT;AF3TOT;AD0TOT;AD1TOT;AD2TOT;AD3TOT","Latest…
I am currently using LSEG Workspace and would like to set up an Excel file that automatically updates with macroeconomic news data. Specifically, I’m looking for a file that includes the following columns: Type of release Date of the release Time of the release Actual value Expected value (when available) The data should…
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).…
Hello, I have seen a post that there is a way to convert LEI numbers to RIC using phyton - and download company data as such, however, I cannot work with phyton and I wonder if there is a way to download company data with DFO Excel table (Datastream) via LEI (not via ISIN) - and what is it?
I am using the Datastream for Office (DFO) request table to download stock prices of companies, but the output comes only at 2 decimal places, I want to increase these to at least 4 decimal places. How to do it?
Specifically, I am interested 3 views, listed below with screenshots: The “Economic Monitor” screen (Accessed by "Macro -> Economic Monitor") The "Interest Rate Probabilities" screen (Accessed by "Macro → Interest Rate Probability) The "Probability Distribution" screen (Accessed by "Macro → Interest Rate Probability" page,…
I'm getting error messages when trying to pip install DatastreamPy Please see attached screen shot Can you help please? thanks
Hi Team, Could you provide the details of where we can find a mapping of a company's ISIN to all its bonds' ISINs in the Refinitiv data API? For example, we would like to have a mapping of Mercedes-Benz (DE007100000) with all its related 36 bonds (see screenshot). Thank you.
It looks like you're new here. Sign in or register to get started.
