-
Eikon fails to return financial data
Hi, I am trying to get some financials for a list of companies using the Eikon API on Python over a certain time period. When using the eikon.get function, I get two lists, where the first one is for the successful requests and the other is for the errors. When analysing the errors for a specific row, I get "'code': 416,…
-
some NYSE RIC's returning without suffix - why?
def get_conversion_defs(symbols) -> pd.DataFrame: response = symbol_conversion.Definition(symbols=symbols, from_symbol_type='TickerSymbol' ).get_data() df = response.data.df return df if __name__ == '__main__': import refinitiv.data as rd rd.open_session() output = get_conversion_defs([ 'BAC', # expecting suffix of NYSE .K…
-
Can't get API to work in local script (works in codebook)
Trying to fetch some historical data from Eikon API. I am running the following code: # Importing libraries import eikon as ek import datetime import pandas as pd ek.set_app_key('MY APP KEY') # Defining start time for the data series start = datetime.datetime.now() - datetime.timedelta(days=1) # 1 day ago…
-
We use API search function to retrieve data, but it returns unknown property 'ProviderSymbol'. Th...
...e field in Eikon Client is "PROV_SYMB" df = rd.discovery.search( view=rd.discovery.Views.COMMODITY_QUOTES, top=10, filter="(ProviderSymbol eq 'm2401')", select="ProviderSymbol,RIC" ) { "return_code": 500, "return_info": "Error code 400 | Invalid filter: unknown property 'ProviderSymbol'", "result": {} }
-
using Python to download all securities that have exposures to a country, a sector, or a company ...
...to excel I wanted to download from Refinitiv Eikon all securities (including equities, bonds, etc.) that have exposure to a given country, using Python. But I have no experience using Python to download anything from Eikon at all. Wondering if anyone can help me on this. I also wanted to download all securities that…
-
corporate governance / shareholder activism query
hello, can i query the 'corporate governance' table where i could download recovers of shareholder activist, target, date, status, goal, etc? i see it in the eikon front end - curious how to query the data from the python eikon api thank you
-
How to get monthly Average data?
Hi, I am using Eikon in Python. this is my code: Here is my question: In the second one, at the fields for some RICs which does not have 'TR.~ ' fields, where to find what to put in AVG(here). 1. is it possible to get monthly data for these RIC in the second one? 2. if so, how to know what to put in AVG() function? I truly…
-
How can i get the news Articles and images?
Hi, I am using Python to get the News letters. Here is my code in Python : headlines = tr.get_news_headlines(query=test+" IN KOREAN",date_from='2023-10-26',date_to='2023-11-28') for index, headline_row in headlines.iterrows(): story = tr.get_news_story(headline_row['storyId']) print("story : \n" + str(story)) I was…
-
Multiple output for the same date
Hi, I am trying to get some balance sheet data from Eikon API on Python using eikon.get_data for a list of companies throughout the period 2000-2022. I encounter four types of problems (in different instances). I will refer to the total assets of company AU000000TEN8 in USD in the examples I make: 1. it assigns the same…
-
Get list of constituents of an issuer curve
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.