-
Data Availability
I search for many variables, for example Board size data, for the listed firms in the GCC region (eg. Saudi, UAE, Qatar.., and there are only few numbers of firms has data, does this mean this database doesn't have data or maybe there is a correct way to search?
-
How to download Price to Book Ratio data of 60-100 stocks? I need this data for my master's disserta
How to download Price to Book Ratio data of 60-100 stocks from Refinitiv Eikon Datastream on my windows laptop? I need this data for my master's dissertation.
-
Get Name of Instrument and get name DataType ??
Hello I'm using the Python API (DatastreamPy), but I can't find how to request the Instrument name and the DataType name. This is my code import pandas as pd import DatastreamPy as dsweb ds = dsweb.DataClient(None, '', '') history = ds.get_data(tickers = 'TOTMKDV', fields = ['DWNM'], kind = 1, start = '-1Y', req = 'M', )…
-
"How can I execute a DSGRID function using Python?"
"I have a list of ISINs for some corporate bonds in an Excel table and I want to get the time series data for these bonds, for the variable yield to redemption. I am currently using the DSGRID function in Excel, which looks like this:…
-
Why can't we find data from before 2015 on WACC?
We have already retrieved relevant data regarding both i.e. ESG Scores and Returns from 2013 to 2022 for our project, but when trying to print WACC values for our companies in the same time period, this only starts from 2015 - what is the reason for this?
-
I want to download SPY ETF last 15 years one minute high frequency data. What should i do?
I want to download SPY ETF last 15 years one minute high frequency data. What should i do?
-
CODEBOOK for Datastream
Hello Team, I have a client with a query as below. I am trying to use the CODEBOOK app (CODEBK) - a development environment for financial coders with a fully hosted cloud-based kernel for Python computations, closely integrated with Refinitiv. I am currently attempting to extract Scope 1 and Scope 2 emissions based on a…
-
is it possible, using the API that the database provides, to Download the Documents & Notes related
I am fairly confident in downloading data related to green bonds, but I can't figure out if there is a way to also be able to download other data related to other areas of the bond interface to the database. I can't find any tickers or indicators that I can plug into python. I need to know if, in this case, downloading…
-
Datastream API is intermittently giving a Read Timed Out error
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.…
-
Can anyone help me with the validity of downloaded stock returns from datastream?
Hi, I have attempted to download daily stock returns for all stocks within the US tech sector, using their ISIN codes downloaded from Eikon's Screener tool, before using Datastream to create a request for daily price change within excel. This has been for between the periods of 2000-2022. Now, I'm worried that some of the…
-
How to download forward chain for a given date?
Hi, I am trying to access an entire forward chain for commodities on a given day. For example, I would like to obtain all forwards/futures data for Henry Hub on 09/29/2023 or all forwards for 12/29/2023 for ERCOT North. I have encountered the Commodity_Futures_RIC_Search.ipynb and have used a brute force method. However,…
-
Question on how to retrieve data from EIKON Refinitiv add in in Excel
Hello dear community, I am trying to retrieve the following data (time series, from 01.01.2003 to 01.01.2015) from companies using their ISIN code as reference in the Eikon Refinitiv add in in Excel: S&P's, Moody's and/or Fitch's (depending on data availability) credit ratings on the same bonds; value of the bond issue in…
-
How can i get every day prices of RELI.NS including holdays
(eg: for saturday & sunday the FRIDAY prices should reflect), In Bloomberg the command we use is =BDH("RELIANCE IB Equity","PX_LAST","01/01/2023",TODAY(),"DAYS=A","FILL=P"), Here FILL=P used to fill for previous prices where HOLIDAY exists
-
Error - installation of DSWS
Hi, I got an error as below when I tried to install DSWS library via Anaconda admin prompt. Would you advice on this issue?
-
DSWS Python API not working
The following code has worked without issue for a long time but as of yesterday quit working: import DatastreamDSWS as DSWS ds = DSWS.Datastream(username = "XXXXX", password = "XXXXX") I'm using Jupyter Notebook and have not made any changes to Python or associated packages. The Eikon API and all other packages are working…
-
$$ER: E100,INVALID CODE OR EXPRESSION ENTERED for a Credit Default Swap
Hello, I am having trouble getting the Total Return Index from selected Credit Default Swaps. The Error-Code: $$ER: E100,INVALID CODE OR EXPRESSION ENTERED keeps showing up, regardless of which CDS I choose in Datastream. I am able to get the Total Return Index for Stocks and Bonds, CDS are the only type that do not work:…
-
Datastream - How to retrieve all series that match my filters or categories?
I want to pull time series data for Datastream mnemonics that match a certain criteria. Datastream interface/desktop has categories for time series that allow you to filter your search to the relevant results. For example you can search for all time series that match: Type=Commodities, Country=USA, Activity=Dead,Settlement…
-
Beta Expression in R via Datastream API
Hi, I am trying to run an expression in r using the DatasteamDSWS2R package. I have be able to get a more simple expression working, but for what ever reason the formula supplied is not generating any data. mydsws$timeSeriesRequest( instrument = 'A:BHPX' expression =…
-
Access error while accessing refinitive Eikon through VBA
Hi, I am having a problem while trying to access to some data through excel. In the Excel file I am getting the error in the line of code: This script has been working for long time until today. The error that I get in excel is this one: While pasting the gateway URL into internet and put my credentials, I get this message…
-
Python API Error: Microsoft Visual C++ Runtime Library ---- Assertion Failed
It shows Microsoft Visual C++ Runtime Library ---- Assertion Failed when I am trying to run a search function with Admin right. Is it because my Microsoft Visual C++ setting has some issues? Thank you. After click Abort:
-
Developer Community login error
Mr. Nishimura registered his mail to Developer Community successfully, but he is not able to login. He received "unauthorized.." message instead. Please look into this issue. Screenshot attached
-
Frequency selection Refinitiv Datastream Excel
Hello, I am using Refinitiv Datastream add-in on excel to obtain monthly data (for example: ROA) for a group of companies however when I select frequency as monthly, the data I obtain is the yearly data duplicated for each month. I am pretty sure that Refinitiv has the monthly data however I do not seem to be able to…
-
100% Moneyness ID, for example for RIC "GE", 100 Moneyness ID is GE1$MONEY100
Hi, Is there any way to pull 100 Moneyness IDs using stock RIC (or some other id) from DataStream API in Python? For example for RIC "GE", we have moneyness ID is "GE1$MONEY100". Below is the screenshot from DFO Navigator just for reference. I am looking for a way using Datasteam API in Python.
-
how to get date in dsws
Hi team, I've got a question regarding dsws. If retrieving single filed and startdate = -0D, then the result will not showing the actual date of the data. e.g. df = ds.get_data(tickers = '@:CNM1E1', fields = ['A12FE'], start = '-0D') the result will be showing index, instrument, datatype, value and currency However, if…
-
How to retrieve MSCI index constituents & weights (index shares + weights) in Datastream?
Hello. I want to retrieve the same informations like in this post in Datastream. Here is the formula I'm using to retrieve this information. =@DSGRID($B$1,"RIC,NAME,NOSH,NOSHFF","Latest Value","","","RowHeader=true;ColHeader=true;DispSeriesDescription=true;DispDatatypeDescription=true") I tried with the following list…
-
Getting Realized & Implied volatilities for different time horizon for STOXX50E and SPX (.SP500) ind
I can pull realized data for multiple time horizon but I need series of data. Below is an example for .STOXX50E However this is for one data point i.e, only latest value. I need series of data, example like data series for last 6 months or 1 year or 5 years for every business day for different time horizon. Also, I do not…
-
Remove Unwanted Columns After Fetching data DSGET
Hello, once we fetch data from DSWS we generally get this ouput: # Set Start and End Dates with the following format "yyyy-mm-dd" StartDate = "2023-03-01" #Set start date EndDate = "2023-05-31" #Set end date # Set The Frequency Of The Data Equal to D,W or M Freq = 'M' # Initializations sp500_data = pd.DataFrame() ism_data…
-
Static requests for DSCD in DatastreamDSWS are incomplete?
I use python (3.6) and DatastreamDSWS (1.0.8) to make a set of static requests to obtain the ‘DSCD’ for a list of SEDOLs: * When I query certain SEDOLs, I get back NA where I would expect to get a value: * An example is SEDOL ‘2076009’ (Bank of Montreal):* I get NA for DSCD when I do a static request using DSWS * When I…
-
Service discovery request 500 server error
Hi Refinitiv Team, We got 500 server error via service discovery request. The request was working yesterday but not today. We have this logs: Sending EDP-GW service discovery request to https://api.refinitiv.com/streaming/pricing/v1 EDP-GW service discovery HTTP code: 500, Internal Server Error Thank you for your help!
-
Error: unexpected argument "retName" when I try to get name of datatype
I want to get the name of datatype following datastreamDSWS help but in vain. My code: ds.get_data(tickers='@AAPL';, fields='WC08311',retname=True) Error message: The argument shall be there I suppose. Can you please advise alternative way if available?
-
Get data from python datastream api
import DatastreamPy as dsws ds=dsws.Datastream(username='****',password='****') d = ds.get_data (tickers='BARC', fields=['P'], start='2018-01-01', end='2023-03-01', freq='W') How can I retrieve price data from "d". I intend to store it in database but am not able to access data. d returns None
-
DSWS fetch green revenue data of FTSE
Hi team, may I know how to fetch Green Revenue data of FTSE from DSWS? For example giving ric of 000001.SZ, how to get the green revenue data fields? Thank you.
-
Mismatching of quarterly EPS surprise date and earning announcement dates
I'm doing a research on Taiwan market and retrieved earning surprise data from DataStream. for example, I collected quarterly earing surprise announcement dates (EPSISURDTE) and quarterly EPS surprise score (EPSISURSUE), I find EPSISURDTE is different from quarterly earnings announcement dates on TWSE. What is the…
-
Refinitiv datastream connection unavailable
Hello, We are having truble connecting to refinitiv datastream. Sudendly the connection broke, sometimes the connection works ramdonly for a few minutes and then drops. Most of the time we can not connect to the websocket. The system have been working correctly for 4-5 months now and no changes have been made, so we asume…
-
Request Table conversion
The client is trying to convert some old Request Table created in Eikon to be compatible to RW via Conversion Wizard. But he has attached file with macro to download Datasteram data. It doesn't work anymore. Can you assist in converting this ?
-
Do we have a feature-"Automatically switch to delayed data", similar to Eikon into EMA API?
* API:EMA 3.6.3.1 * JAVA * Windows Do we have a feature-"Automatically switch to delayed data", similar to Eikon into EMA API? Hi, We’ve got a question. Can we receive automatically a price (bid/ask for equities/options/futures/curve rates) in function of our customer contract without specifying RT / Delayed by adding or…
-
DSCHART End of Month data (in workspace)
Hi, I want to download data from the DSCHART app (TRI from several global indices) but I cannot figure out how to parametrize the dates to be end of month. I didn't find in the documentation how to do this. Using Dtart=BASE and End:LATEST provides monthly data but is not end of month (as in the screenshot, I get dates such…
-
Plotly Not Working in CODEBK?
Hello, trying to use plotly to plot this simple dataframe (dfplot): index Strat1 237 2022-11-29 -0.159187 238 2022-11-30 3.094787 239 2022-12-01 -0.086763 240 2022-12-02 -0.000000 241 2022-12-05 -0.000000 Using this code: import plotly.express as px fig = px.line(dfplot, x="Date", y="Daily Return", title='Daily Return…
-
Datastream futures contract retrieval
How can we find all the contracts that are used to construct the continuous series? Is there a way to automatically generate the tickers for the contracts that are yet to expire? The question is platform and coding language agnostic.
-
How to clean the output of data
Hello, I have the code below. import DatastreamPy as dsws import pandas as pd # set up connection def connection_DSWS(): DSWS_username = open("DSWSUsername.txt","r") DSWS_password = open("DSWSPassword.txt","r") ds = dsws.Datastream(username = str(DSWS_username.read()), password = str(DSWS_password.read()))…