-
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…
-
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?
-
$$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 downloading constituent list Russell 3000 for a particular date using Datastream Excel Ad...
...d in 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?
-
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
-
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,…
-
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…
