The most recent content from our members.
Hi Team, Could you provide the details of where we can get index constituents and related fields in Refinitiv data api? Thanks, Varun Kumar Mishra
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…
Hi guys, I would loke to know if there is a smart way to get time series for valuation/fundamental data at etfs/index level. The only way I found for now is to pull the historical weights and the fundamental/valuation data for each stock and then to aggregate manually, but this is - as you can imagine - not so clean, as…
Hi, I'm using get_data function to pull index details with no problem until I need to grab the same data for a new index .HEDGEINDEX, in which case all I'm getting for this index is <NA>. Can anyone help me figure out a way to pull? Thanks. Below is my code: df_ric_ts, err_ric_ts = ek.get_data( ['.HEDGEINDEX', '.SPX'],…
Hi all, I've noticed some inconsistencies in the API data, I'm wondering if I did anything wrong or if this is a data quality issue. I'm trying to retrieve the Ric Root code for indices. For this I use this function : def getRicRootFromIsin(isin): df = rd.discovery.search( view = rd.discovery.Views.SEARCH_ALL,…
Hi, I'm working on a thesis about the Belgian stock market and for this thesis I need the total returns of all the former constituents of the Belgian all share index (all the way back to 2002 or 2004). I know where the find the list of leavers and joiners but I do not know where to find a time series of actual weekly total…
Hi! I am trying to download daily price of stock index from a list of RICs by the following code. But it does not work. Can you please help me on this? df, e = ek.get_data(["MERV","SP500","ATX"], ['TR.PriceClose(Curn=USD)','TR.PriceClose.calcdate'], {'SDate': '2012-01-01', 'EDate': '2023-02-10','Frq':'D'}) df
How can I get index constituents every month? I am looking for the .HSLI index constituents every month end since 2015/1/30. I have used df=ek.get_data('.HSLI', ['TR.IndexConstituentRIC'], {'SDate':'-50M'})[0] With a loop from -50 to 0 so I get every month... However, the data is there only for the last couple of years. On…
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?
Hi Team, Hi Nick nick.zincone is there any reason why the below query gives results on Advanced Search Tool of EIKON, but not in RDP? Also, how can I get the constituents (and weights thereof) of whatever Equity Index that comes out of the query below? import refinitiv.dataplatform as rdp rd.open_session() sFilter = "(…
It looks like you're new here. Sign in or register to get started.
