-
$$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:…
-
Data download structure with Eikon's Build Formula VS Datastream in Excel
I would like to ask the following question. I am downloading data for the last 10 years for all companies that have ESG data. Using Eikon's "Build Formula" function, I have been able to download the ESG data and part of the economic-financial data. This download shows me the data as shown in the first image. I would like…
-
Trouble selecting large amounts of data in Datastream Excel Add-in
Hi. I am a business school student, and I'm attempting to use Eikon Datastream to create a larger dataset - But i am having trouble selecting a large enough volume of data in my queries. I have access to Eikon and Datastream, and the excel add-in and I am a beginner with all. My access to these is through my school's…
-
Trouble downloading constituent list Russell 3000 for a particular date using Datastream Excel Add i
Hi I am trying to use Datastream excel add in to download Russell 3000 constituents for a particular month and year through a table using the mnemonic LFRUSS3L followed by the two digit month and two digit year (e.g.: LFRUSS3L0105). I also used the other variations that are available for the annual lists (e.g.:…
-
Refresh Excel Via Python Using Win32 Client
Hello, I have built this code in python - as a mere example - to open a specific Excel file using the Win32.client where I need to add a specific DSGRID code to fetch some data in Datastream with the COM addin. # # Open an existing workbook # import win32com.client as win32 # Set-up a Connection With Excel excel =…
-
How can I get the monthly trading volume for FTSE All share index constituents in excel?
How can I get the monthly trading volume for FTSE All share index constituents in excel for every month in a year. I'm trying to calculate share turnover which is defined as trading volume/average shares outstanding.
-
DSGRID formulae
Can someone help me understand what this DSGRID formulae does - =@DSGRID("AXBK.NS","cya#(x~INR*100,c)",YEAR(Financials!M35),"","","SDateCellRef=true;SuppressComments=true;Sym=RIC","") What is the function of : cya#(x~INR*100,c) ? Is there any documentation for these formulaes?
-
How can I get beta values for each company in a vertain month?
I'm trying to get the beta value for FTSE All share index members for every month between 2010-2019 in datastream excel. How do I do this?
-
Time series request for list of funds
I am searching for a way to make a time series request in Datastream for a list of funds. I am using the ISIN of about 2000 funds and I am trying to retrieve the monthly return index (RI) for every single one. How can I insert the entire list of ISIN numbers in the time series request (in the Series/List box), instead of…
-
DatastreamDSWS returns "NA" for "SECD" (SEDOL) using the "get_data" method
I am using the Datastream API for Python. It returns "NA" values - when I use the "DSGRID" Excel Add-in on the same list of securities, I get the required "SECD" values. My code: securities = ['US0235861004', 'US29362U1043', 'US5393192027', 'US07134L1070', 'CA91702V1013', 'US0008681092', 'US4281031058', 'US16411R2085',…
-
Internal error occurred while processing the request data.
Hi. I am using the DFO Request table to get some data from Datastream. This problem suddenly showed up with this statement at destination "Cannot read property 'ExecuteTimeSeriesRequestsResult' of undefined" and no data was retrieved. How can I fix that? Thank you
-
Excel formula for fund flows in Global Fund Flows App
Dear support team, How can I directly download using the time series request in Excel data from the Global Fund Flows App in Eikon? I am interested in the fund flows (flows(LC)). What is the name of the datatype? Is there an alternative formula to get this data? Thanks in advance.
-
Hi, is there a way to retrieve liquidity index for stocks? Thanks
Hi, is there a way to retrieve liquidity index for stocks? Thanks
-
How can I find all listed companies given “Country of Domicile” or "the Exchange name or code"
Dear Sir/Madam, I am using Eikon with Datastream for Office. Q1) In Eikon’s Python API/Datastream, how can I find ALL (both alive and dead) listed companies’ RIC or PermID given the “Country of Domicile”? Q2) In Eikon’s Python API/Datastream, how can I find ALL (both alive and dead) listed companies’ RIC or PermID given…
-
Given a RIC or PermID, how to find ALL HISTIORICAL tickers exhange ISIN CUSIP SEDOL?
Dear Sir/Madam, I am using Eikon with Datastream for Office. Q1)In Eikon’s Python API/Datastream, given a RIC or PermID, how can I find ALL historical change of its primary listing with Ticker and Exchange name? Q2) In Eikon’s Python API/Datastream, given a RIC or PermID, how can I find ALL historical change of its ISIN,…
-
Retrieving data in Datastream Excel-plugin for all European companies with continuous availability o
Hello, I am just starting to work with Datastream and are hence a beginner. I logged into Thomson Reuters Eikon - Microsoft Excel and are connected. Now I am looking for a way to receive all European companies (equities), for which there is a continuous combined-ESG score available (datatype “TRESGCS”) for the last 15…
-
ESG scores for all US companies with the excel plug in
Hi all, I am a super beginner with Datastream and I was wondering if any of you could help me. I'd like to retrieve all ESG scores for all available US companies for the period 2007 onwards using the excel plug in. I have zero experience with Datastream so if you can't provide a strightforward answer it would be great if…
-
Data limits for DFO vs. DSWS
I know that data retrieval via DSWS (Datastream Web Service) is limited to 10 million datapoints per month. However, I was wondering whether such a limit also exists for DFO (Datastream for Office)? So when I download data via the Datastream Excel Add-In do I also have to consider a limit of 10 million datapoints or is…
-
How to get the same results in python API as the one from DFO?
I execute below code to find the 'ISHARES MSCI AUSTRALIA ETF' symbol. But I got nothing. Then, I search the same keyword on Datastream Office. And then I got the following. Q1. Using python API, how can I get the same results that I got from Datastream Office's? Q2. And is there anything I can do to get and actually see…
-
batch file to refresh DFO
Hello, I am writing a batch file (vbs) to update the data from DFO programatically. The function in the excel is DSGRID. Although it runs fine, it doesn't seem to update. Here is my code: Set excApp = CreateObject("Excel.Application") excApp.Visible = True excApp.COMAddIns("PowerlinkCOMAddIn.COMAddIn").Connect = True set…
-
Datastream for Office (DFO) Excel Add-In Connection Status
Hello, We are currently using DataStream DFO Excel Add-In and wish to automate some of the data capture via a Python Script that first Opens Excel that has DFO Add-In installed and then pushes the DSGRID Formula into a Cell with the required parameters. What I would like to know is if there is a call that can be made to…
-
gRTCOMInterface.ProcessRequestTable hangs up
Hi, I'm using VBA to automate executing multiple Datastream Request Tables iteratively. It seems that each request table calls gRTCOMInterface.ProcessRequestTable to fetch the data from datastream servers. However, I noticed that after a couple of requests, this method gets hung up and the data retrieval process never…
-
Get Total Return Index from Eikon API
I'm looking to get a particular data value out of the Eikon Python API. The Datastream DFO code is RI and it's called Total Return Index. I cannot for the life of me find it in the Data Item Browser that comes with the proxy. Is this value even available through the API, or only DFO?
-
Equity search whole database
Hi guys, I'm currently doing some financial research which focusing on international equity market. I'm using the data from datastream and try to download as many company as possible (yes, the more, the better). I'm trying to select a large amount of equities at the same time, say, all US equities. However, the DFO window…