-
Historical Index Membership for RICs
Dear all, I am currently working on retrieving historical data for a set of RICs. While I am able to successfully obtain fundamental data, such as revenue information, I am facing challenges in retrieving historical Index membership Information. Below is the code I have implemented: df = rd.get_data(unique_ric_list,…
-
ETF Ownership of equity
Hi, I am currently looking for a way to retrieve the % of outstanding shares held by ETFs of a single equity. I know that I can do this manually by looking at the Fund Ownership of an individual equity, however, I am looking at 150 equities over the past 20 years on a monthly basis. Thus, doing it manually is not an…
-
Historical levels from inception till current date for an Index
Hi All, I am looking to get the historical levels (close price) for MOILGE index from 2008 till the current date. What should the formula be to get this data. I am currently using Eikon termina - MOILGE page - Prices & Charts - Updating the date range and then copying to excel. Regards, Grishin
-
'NoneType' object has no attribute 'get' error for API data
Hello all, I am trying to download a list of index constituents using the eikon data API, however, i am getting a 'NoneType' object has no attribute 'get' error for this code : import eikon as ek import pandas as pd from tqdm import tqdm # Import tqdm for progress tracking Your Datastream API keyapi_key = 'kEY ' Initialize…
-
Index constituents and related fields in refinitiv data api.
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
-
"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…
-
Aggregating historical fundamental metrics by ETFs/Index through Refinitiv API
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…
-
Python API get_data function cannot pull data on .HEDGEINDEX
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'],…
-
Wrong Ric Root code in API
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,…
-
How to get the total returns (per actual week) of former constituents of the Belgian all Shares?
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…
-
download stock index price by a list of RICs
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
-
Index constituents every month
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…
-
How can I get beta values for each company in a vertain month?
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?
-
Retrieve Equity Index Info via fuzzy search on RDP
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 = "(…
-
$$ER: E100,INVALID CODE OR EXPRESSION ENTERED for a Credit Default Swap
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:…
