-
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,…
-
Error when using fundamental_and_reference to search entities
I am using refinitiv.data to search entities encounter below error, anybody could help with? Enclosed the code I am using.
-
Is it possible to get information of all share classes of a company using Refinitiv.Data on Python
Hi, I'm wondering if it's possible to get the information (e.g. price, volume) of another share class given a specific share class. say, GOOGL.O, Google, on GOOGL.O BUS page, there are 6 types of shares, and they're GOOGL.O, GOOG.O, GOGL34.SA, GOGL35.SA, GOOGLm.BA say given the RIC code - GOOGL.O, is it possible to obtain…
-
How to accurately get data between your customised periods specified
Hi everyone, One thing that I am confused with regarding get_data_async, is that, depending on the datapoints I try and retrieve, I can't seem to get data within the scope of years that I specify. Say I have this for example: current_year = datetime.today().year start_year = current_year - 8 async with semaphore: #…
-
Obtaining Years alongside retrieval of Fundamental Data Asynchronously
Hi everyone, I have a question regarding the Date column not coming with get_data_async function calls. When I am making calls like so: roa_datapoints = await content.fundamental_and_reference.Definition(universe=[f'{ric}'],fields=["TR.F.IncBefDiscOpsExordItems","TR.F.TotCurrAssets","TR.CommonName"],parameters={"SDate":…
-
Python refinitiv fundamental returning wrong data -- very weird an incoherent behavior
I'm using the Refinitiv package in python, following code, and receive wrong data back, also depending on the parameters. The code: import refinitiv.data as rd from refinitiv.data.content import fundamental_and_reference rd.open_session() fields = [ 'TR.F.TotRevenue.fperiod', 'TR.F.TotRevenue', 'TR.F.COGSTot.fperiod',…
-
Industry Median fields not working
Fields related to the median industry (found in Codecreator) are giving me error 414. Is it something related to these fields or what is the reason? Any alternative would be appreciated. from refinitiv.data.content import fundamental_and_reference fields = [ 'TR.MedianIncAvailToComExclExordItemsMargPct',…
-
API for get_data not working
Hi, the following query is not working at the moment: rd.get_data( universe=['LSEG.L', 'VOD.L'], fields=["TR.AdjmtFactorAdjustmentDate", "TR.AdjmtFactorAdjustmentFactor", "TR.AdjmtFactorAdjustmentType", "TR.AdjmtFactorUnderlyingEventId", "TR.CACorpActEventType"], parameters = {'SDate': '2010-01-01', 'EDate': '2024-06-1'} )…
-
ReadTimeout('The read operation timed out')
I want to get the constituents of the ETF IEUS.DE with this part of a Jupyter Notebook: rd.open_session() # Get constituents for ETF response2 = fundamental_and_reference.Definition( universe = "IEUS.DE", fields = ["TR.ETPConstituentRIC,TR.ETPConstituentName"], ).get_data() response2.data.df I get the error An error…
-
Missing data for SP500 using fundamental_and_reference.Definition get_data
Am looking to download the following fields (list below) for SP500 index constituents, from 1995 to yesterday, daily data. Am using the following import refinitiv.data as from refinitiv.data.content import fundamental_and_reference import datetime rd.open_session() growth_fields = ["TR.EPSMeanEstLastToNextYrGrowth",…
-
EPS Fundamental data to retrieve via Workspace
hi, previously we used eikon excel formula to retrieve these data:…
-
How to access all portfolios, monitors, lists through RDP API (in python)
I may have overlooked some documentation but ... here is what I do and try to do * I manage my portfolios, monitors and watch lists in WORKSPACE (app, on Windows and Mac OS) * I'd like to access a complete list of all those items in python, that is something like: ek.get_data('PORTFOLIO([ ALL ],[PORTFOLIO.CURRENCY,…
-
How to download fundamentals data of multiple companies (almost 20,000 companies) for the past 30...
... years via Python? Client verbatim: "I need help to download the 30 Years financial of Canada and the US using Excel. I was told to do it via Python. Can you please share the following details which is showing in the configuration file mentioned in your support file."
-
ZAV with RDP API doesn't work as expected
I tried to receive some data with a ZAV like in Excel, but only the first value with "NA" is replaced by 0. This is the program: currency = "EUR" co2_fields = ["ZAV(""TR.AnalyticEstimatedCO2Total"")","ZAV(""TR.CarbonOffsetsCredits"")",\ "TR.AnalyticEstimatedCO2Total","TR.CarbonOffsetsCredits"] as_of_date = "2023-06-30"…
-
How to retrieve a sum of fields with RDP API?
As in Excel I want to get data for the following formula in Excel: AVAIL(TR.CashAndSTInvestments,TR.CashandEquivalents+TR.Cash+TR.STInvestments) I tried this jupyter notebook: currency = "EUR" bs_fields = ["AVAIL(""TR.CashAndSTInvestments"",""TR.CashandEquivalents""+""TR.Cash""+""TR.STInvestments"")"] as_of_date =…
