-
GET CONSTITUENTS OF AN INDEX USING PYTHON CODE
How do I get the constituents of nifty 50 which is depicted by INNSE50 or .NSEI , I can see that on the datastream navigator but i want to extract via python code. I am trying to use this, df, err = ek.get_data( instruments = ['INNSE50'], fields = ['TR.IndexConstituentRIC', 'TR.IndexConstituentName'], parameters = {…
-
Joiners and Leavers for STOCK EXCHANGE (not MAIN INDEX)
Hi, I'm interested in retrieving historical joiners and leavers for stock exchanges. I've gone through a number of Q&As and am aware that there is functionality to obtain historical joiners and leavers for the main stock INDICES, but I wanted to know if the same exists for stock EXCHANGES. For example, the code below…
-
Historical Leavers and Joiners of .SPX
I need a list of Leavers and Joiners at the beginning let say at 01-01-1990 and then have the in and out for the following years in Phyton API. So this need to be done in 2 times : First having the list at special date let’s say 01/01/1990 Second the IN and Out the following years. For sample RIC : .GDAXI To have a…
-
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'],…
-
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=[…
-
S&P 500 Index constituents every month
How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem?…
-
Please check we are getting error using the below code.
Please check we are getting error using the below code. import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['.JTOPI'], fields = ['TR.IndexJLConstituentRIC.change'] ) display(df)
-
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 get all constituents of the ETF Index IEAC.L via Python API Script ?
I am currently using the following code to extract the RICs of the ETF index IEAC.L: indices = ["IEAC.L"] # ========================= # SECTION 3: GET CONSTITUENTS # =========================def get_constituents(index_rics): all_constituents = [] for index in index_rics: print(f'Extracting constituents for {index}') result…
-
How do i do to get the historical list of constituents for NASDAQ, say from 1994-2024?
How do i do to get the historical list of constituents for NASDAQ, say from 1994-2024? I want to get it to excel.
-
Is it possible to retrieve the historical constituents of the ACWI index using Python?
Our main challenge has been downloading the constituents of the MSCI ACWI index, whether current or historical, as both are crucial for our objective. Unfortunately, we have been unsuccessful despite multiple attempts. Below are the details of our efforts: Code Attempt 1: import refinitiv.data as rd from…
-
Historical S&P Constituents
Hello, I am currently writing my Master thesis and I am in need of the constituents of the S&P500 on several historical dates. I am using the Workspace Formula Builder in Excel. Unfortunately it does not work. Does anybody have an idea or knows how to do it in the web version? Many thanks!!! Robin
-
Help Needed: Historical OMXSPI Constituents Using Eikon Excel Add-Ons
Hi everyone! I’m a bachelor’s student from Sweden, currently writing my thesis on excess comovement by index events. This is my first time using Eikon, and I have access to the Eikon Excel add-ons. I’m trying to retrieve historical data on the constituents of the OMX Stockholm All-Share Index (.OMXSPI) for my research.…
-
"SDate" and "Period" parameters of get_data function
Hi everyone, Thanks to the insights from another user's thread on this forum, I was able to create a function that retrieves the historical constituents of the SP1500 at a specific point in time (specifically, at the end of each year). My ultimate goal is to get a list of firms which where constantly part of the SP1500…
-
Eikon box shows different fund constituents than EIKON Python API
@nick.zincone Hi, I am using EIKON API to retrieve Fund constituents using Python ("EAP" in sequel) script shown below. Upon comparing it with what I get from EIKON box (Derived Holding), I see a "slightly" different picture a. "EAP"result gives a total of weights equal to ~300% whereas EIKON box shows 100% ("ACCOUNTS…
