-
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 =…
-
How can I download the index stock returns for S&P500, FTSE100 indicies for the last 10 years wit...
...h daily data on last price, volume using R API. Many thanks! Some further notes: I am using Datastream via Eikon with ID being an email and a password. I do not have a separate ID and password for Datastream. Can you please help to give the answer to my personal email: XXXXXX Many thanks!
-
Finding stock price changes on specific dates
I have a list of mergers and their respective rank, announcement, and effective date. I also have the ultimate parent of the target companies in the mergers. What I want to know is what the change in the stock price of the ultimate parent is on the different dates. Further I would like to know what the change in other…
-
lack of historical data through python API compared to EIKON
Hi guys, Can you tell me why I am not able to retrive data on the belowed index prior to 2012 using the python API? I seem to be able to find charts, and data using the EIKON app - but fail to do so using the below call Index: .dMIWO00000NEU Call: ek.get_data([".dMIWO00000NEU"],…
