The most recent content from our members.
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…
@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…
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.
Hi, Similar to the content discussed in the following thread from 2020, I was wondering if a historical / point in time Free Float Market Cap can now be obtained from any of the Refinitiv Data Platform APIs? https://community.developers.refinitiv.com/questions/67381/how-do-i-retrieve-index-constituents-in-rdppython.html…
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, Does anyone know how I can get a list of constituents of an issuer curve like '0#DEAAAEURAGEBMK='? In the Data Item Browser, I can only find "TR.IndexJLConstituentsName", which shows the last constituents that joined or left. Is there a way to obtain the full list of constituents? Thanks.
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 = "(…
I'm able to pull the index constituents as of a particular date, using: df = ek.get_data('.RUT', ['TR.IndexConstituentRIC', 'TR.IndexConstituentWeightPercent'], parameters={'sdate':'2022-04-30','edate':'2022-04-30'})[0] holdings_list = df['Constituent RIC'].str.cat(sep = ', ') How can I use the API to pull operating…
Hello, I am trying to get some index constituents details of some indices using Eikon data API. I can get some basic data using "TR.IndexConstituentxxxx" items like the query below. However, I cannot find these fields using DIB in my Workspace. There is no item if I search using "TR.IndexConstituent". If I type…
Hi Team, we have a client that is trying to retrieve historical data using R with the following code: get_data('0#.KLSE(2018-01-01)', list('TR.InstrumentName', 'TR.CompanyMarketCap(ShType=OUT)')) but they are not able to retrieve it. Client said they were able to retrieve this previously with the below image similar…
It looks like you're new here. Sign in or register to get started.