-
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":…
-
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'} )…
-
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',…
-
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 download fundamentals data of multiple companies (almost 20,000 companies) for the past 30 ye
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 =…
-
Error code 412 | Unable to resolve all requested identifiers in ['0#.STOXX'].
When trying to retrieve Joiner and Leaver data for STOXX I get the RDError 412: Unable to resolve all requested identifiers in ['0#.STOXX']. I used this program in jupyter notebook: rd.open_session() sdate = "0D" edate = "1980-01-02" ic_l = "L" currency = "EUR" fields_jl = ["TR.IndexJLConstituentRIC",…
-
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…
-
Issue to retrieve some fields using RefinitivData under C#
dear Developer community i'm facing issue to retrieve some fields using Refinitv data library under .Net. indeed, as shown below i'm not able to retrieve fields like 'TR.FiIssueDate', 'TR.TD.MaturityDate' for Bonds (request done by ISIN and also by ric) using FundamentalAndReference service. when i use the same library…
-
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,…
-
Discrepancies/Errors between Python API and Refinitiv Eikon Data (Daily Errors)
Please see "Discrepancies/Errors between Python API and Refinitiv Eikon data" for previous explanation of issue. This is an issue that I have been trying to resolve with the Reuters Customer Support and Development Community for over a month now. Here I am providing a compiled list of today's errors that I found. I see a…
-
fundamental data missing
Hello, I am currently trying to retrieve historical fundamental data including balance sheet data, income data and market capitalization for the EURO STOXX 600 for a few years by quarter. For this, first I extract the RIC for the constituents: euro_stoxx_600, err = ek.get_data("0#.STOXX", "TR.RIC",…
-
How do I download Fund Shareholder's History report of a company ? The data we get when we go to "Ow
Kindly help me with this issue which I am facing for the past 2 days. Your help would be appreciated. I cannot find it on the EIKON tutorials as well. Thank you.
-
Screening firms based on historical listing status over a certain period
Hello Guys, for a research project I need US firms’ fundamental financial data (BS, CF and P&L). Since usually Compustat North America database is used for this purpose I am seeking to meet the commonly used sample as accurate as possible. Retrieving the accounting data is straight forward, however, I face difficulties…
-
timeseries data in RDP
Hi Currently i get data (Open, Close, EV, MC) for a list of tickers (on daily basis) by using ek.get_data I want to get rid of opening eikon toolbar, how can I get this data with rdp? Thanks fields = ["TR.PriceClose.date;TR.PriceOpen;TR.PriceClose;TR.EV;TR.CompanyMarketCap"] prices_df,err = ek.get_data( ric, fields,…
-
RDP prints for no reason
I have recently started to use the RDP API (Python 3.9.7) instead of the Eikon API. I have come across some strange behavior: The Following prints after every request, http://localhost:9060/api/rdp /discovery/search/v1/lookup None None and every once in a while I also see the following UserWarning: Unclosed…
-
Are a company's reported numbers on the Eikon database for a given financial year?
I am getting fundamental data for the constituents of an index, for a given financial year. How can I tell if a company's full year financials are on the Eikon database for the chosen year? Eg if I use get_data to get financials for FY2022, is there a data item I can use that shows whether a company's 2022 numbers are…
-
How to get quarterly EPS estimate data on Eikon?
Hi there, Could you please teach me how to retrieve data for "quarterly" estimate EPS on Eikon, not yearly. thanks,
-
rkd api catalogue url
Hello Team, We are using RKD api from a few months. Below is the URL for API catalogue UI: https://www.trkd.thomsonreuters.com/SupportSite/TestApi/Catalog This url now shows 'Site can't be reached'. Could you please provide a valid URL from where we can access the API catalogue on web UI.
-
How can you get financial data relating to a specific business segment of a company through the api?
I have attached a screenshot of the data I would like to be able to extract using a python script. For example data such as: Rio Tinto 'External Revenue' from Aluminium in 2020 or Rio Tinto 'Employees' in the Aluminium business segment in 2020 (screenshot is taken on a Workspace desktop)
-
Why the fundamental data for some companies are missing?
AAN.N does issue annual reports but the code above returns me an empty dataframe Can someone please tell me where is wrong?
-
Fetching daily data into a monthly workfile in eviews does not give me the latest value
In the new datastream online database. I am downloading LCPCASH into a monthly workfile: fetch(d=datastream,c=l) LCPCASH. The value being downloaded for May does not correspond to yesterday's close.
-
Does the API support reading forecast data?
Is it possible to read fundamental forecast data such as "SDDP NRD SYSTEM PRICE FORECAST" and similar through the API?
-
API Returns Wrong Data: get_data returns Annual data when 'FRQ': 'FQ' is specified
The Eikon Python API looks awesome and the data available from the data grid looks very extensive which is great. Unfortunately, on literally my very first test after installation, I tried to get some quarterly fundamental data, but it seems the API is returning only annualized data when I request quarterly data…