The most recent content from our members.
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…
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?
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:…
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…
...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.:…
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 for every month in a year. I'm trying to calculate share turnover which is defined as trading volume/average shares outstanding.
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?
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…
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',…
It looks like you're new here. Sign in or register to get started.
