-
why don't get commodities ricCode by IF2403?
this is my code to get commodities ricCode filter="TickerSymbol eq '" + code + "' and ContractMonthYear eq '" + date + "' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null", I use below param to get code , it will return error messges. "code":"IF","date":"Mar 24"…
-
How to insert a date column with rd.get_data
Hello everyone I would like to get a time series with get_data. I would like to have the P/E ratio of the last 3 years. I use the following code: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LISN.S'], fields = ['TR.PE'], parameters = { 'SDate': '2020-12-31', 'EDate': '-1D', 'Frq': 'D' } )…
-
Error code 408 \ HTTP TimeoutException
Recently, sometimes when I use eikon.get_data(), it will occur 408 error, and the error kept coming up for the next 30 mins. Then suddenly it can works well again to get the data I want. I want to know why and how can this problem be sovled. The error show below: 2023-12-13 11:11:03,926 P[9384] [MainThread 8516] HTTP…
-
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…
