-
'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:…
-
RCC/Websocket API - Field used for close price contribution
I'm using RCC via Websocket API to post Equity Indices data to Refinitiv, using python. I'm able to connect to UAT correctly and it seems that the data went through SENT: { "Ack":true, "ID":1, "Key":{ "Name":".FCIWD800USDP", "Service":"DDS_TRCE" }, "Message":{ "Fields":{ "ASK":2284.0247, "DSPLY_NAME":"Hello RCC",…
-
Operating metrics of all index const
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…
-
Which recordtypes to select to decode an exchange equity index
Hello, I want to decode an exchange index , example CAC40 0#FCHI and I only want to show the stocks that are part of the index. I do not want to show the RICS: " EUR=, .DJI , /.STOXX50E,.AD.FCHI". The filtering should probably be done by RECORDTYPE. Which are the RECORDTYPES I have to select so that only the RICs that are…
