-
Currency of sovereign CDS
I found there are different currencies options for a sovereign CDS when downloading via Eikon. For instance, the US government 5Y CDS, i.e., USGV5Y**AC=R with ** stand for the currency. This CDS can be quoted by USD, GBP or EUR. But what does it mean with quoted by different currencies, and what are exactly the difference…
-
Is there a Datatype for insitutional ownership % in Datastream?
Hi, I could not find any relevant Datatype from datastream that would tell the institutional ownership percentage for stocks, if i understood correctly, from datastream its possible to find individual companies institutional ownership structure, but currently I am working with +400 stocks and going one by one is…
-
How to access Datastream Data Field search navigator for QA users
Hi, As a QA user, one of our clients is accessing DSWS data. However, he needs some sort of data field dictionary/definition reference. Please advise where and how QA users can look up Datastream data field definition, e.g. i advised user to log into but this requires Datastream User ID and password but as a QA user, the…
-
Permission denied for req file upload on sftp refinitiv
Hi Team, File upload is failing with permission denied on refinitiv SFTP. {"FTPHOST":"datastreamddl.refinitiv.com","FTPUSER":"TGK"}. Please help to resolve this. Thanks
-
Datastream codes question
Hi I have question about the Datastream codes. Are these codes recycled when a company becomes delisted, or does the code stay with a company forever? Thanks.
-
getting Datastream data using python
Dears, I want to download financial and accounting data from Datastream using python. The data includes many variables and for many years. That is what called Panel data. The question is, how can I get the variables like total assets (WC02999) and sales (WC01001) for all firms like in the FTSE350 (UK) from 2010 to 2023. I…
-
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…
-
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 disse...
...rtation. 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?
-
is it possible, using the API that the database provides, to Download the Documents & Notes relat...
...ed to a green bond? or must this procedure be done manually? 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…
-
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…