-
MSCI total return indices from Eikon into R
Hi, I am interested in retrieving daily (or monthly) MSCI total return indices data (for a set of countries) via R/RStudio. I believe (please correct me if I am wrong) these data are in Eikon. From reading here on the platform I learned it is possible to use R. I guess what I ultimately need is API access to Eikon via R,…
-
Where and how within the LSEG to get the MSCI total return country indices in R/RStudio
Where and how within the LSEG to get the MSCI total return country indices in R/RStudio, do you have any training documentation or training video which we can refer.
-
Code Error
I tried import lseg.data as ld import pandas as pd import copy import plotly.express as px ld.open_session() ric = '.AXJO' start = '2014-01-01' end = '2025-08-26' df = ld.get_data(universe=[ric],fields =['TR.IndexJLConstituentRIC','TR.IndexJLConstituentChangeDate','TR.IndexJLConstituentituentChange'],…
-
GDAX options not returning TRDPRC_1 via API
I am downloading data for multiple security types (options, equities and indices) and below code provides me with the data I need except for (DAX) Index options at EUREX, e.g. GDAX236000U5.EX. So, most of the fields below will be empty for an option but I would expect at least "TRDPRC_1" to be populated as this can be…
-
Missing values for TR.IndexJLConstituentRIC.change when querying leavers and joiners of indices
See the following code (that works in general) and output. Until a few weeks ago, the code worked without the missing values. How can I get the (non missing) values for the variable TR.IndexJLConstituentRIC.change? ld.open_session() SP100_constitutents_Leavers_Joiners_df = ld.get_data( universe=[ '.OEXA' ], fields=[…
-
Were there recent changes to "TR.IndexJLConstituentRIC.date" and "TR.IndexJLConstituentRIC.change"?
I used to get index changes in the SPX using the following code: index_changes = rd.get_data(universe = index_ric,fields = ["TR.IndexJLConstituentRIC.date", "TR.IndexJLConstituentRIC","TR.IndexJLConstituentName", "TR.IndexJLConstituentRIC.change"],parameters={"SDATE": init_date,"EDATE": end_date, 'IC':'B'}) As of…
-
Client is facing the issue in running the Report client has access for the RIC .FTAS
from datetime import datetime as dt import pandas as pd import eikon as ek app_key='c5468339768f4efd92d04b15e44ae3b62dab8f22' ek.set_app_key(app_key) index_code='.FTAS' initial_date = pd.Timestamp(2025,7,18) fields = ['TR.IndexJLConstituentChangeDate', 'TR.IndexJLConstituentRIC.change', 'TR.IndexJLConstituentRIC']…
-
How to use CUSIP to get the RIC for equity indices?
I'm using python API. I'm trying to extract RIC for Equity Indices by cusip. As an example, I have Cusip 648815108 for S&P 500 Index and Cusip 12497K100 for CBOE Market Volatility Index. However, when I search with the below query I have an empty dataframe returned. df3 = rd.discovery.search(…
-
Historical series of Market Capitalization of market indices
Hello. Could I get a historical series of Market Capitalization of market indices (example: IBOVESPA ".BVSP"; NASDAQ 100 INDEX ".NDX") in the codebook?
-
Missing data under Eikon but available through Datastream
Hello, I am running Eikon API through Python to retrieve quarterly historical information on certain indices from 2000-2022. However, my extract has certain unexpected empty cells for common fields like Market Cap and Total Return which are available through Datastream (Excel). Below is an example count of missing data…
-
How can I get the ROE, ROI, WACC for the constituents of the Stoxx600?
I need the estimates of ROE, ROI, and WACC from 1970 with the highest available frequency for all constituents of the Stoxx 600. Thank you to anyone who can provide assistance with this.
-
Error fetching data for given date. Error code -1 | Backend error. 400 Bad Request Requested univ...
...erses Hello I am running an Eikon API code through Python to generate Excel output for different indices every quarter from 2000-2022. However, on several occasions, the code generates the following error on a given date: Error fetching data for 2012-10-01: Error code -1 | Backend error. 400 Bad Request Requested…
-
How to view the historical percentage composition of an index (e.g., S&P500) over the past 40 years
Hi all, I want to know how i can export the data named in the question above into excel. I need to see the percentage composition of two indices over the past 40 years. Hope someone can help me with that. Thanks
-
Hi, on the DSS REST API, how do you search for indices from an Exchange (example: NAS) that belon...
Hi, on the DSS REST API, how do you search for indices from an Exchange (example: NAS) that belong to a specific criteria (example: GICS industry or TRBC classification). Appreciate if any sample code can be provided.
-
Search API cannot find US ESG equity indices from US indices
Using the Search API, I want to identify (standard and ESG) equity indices by location (starting from US, then Europe…). But I am not getting back the expected list of indices. The list changes if use filter or query parameters. If I use filter to find the indexes within the USA, following this previous threat: filter =…
