-
What is the syntax to use Percent changes on Estimate/Fundamental Data Items
Hi, We have an excel syntax for percent changes. Example: =@RDP.Data("AAPL.O","PERCENT_CHG(TR.FCFMean(Frq=FY SDate=0 EDate=4),wsize=-3)","Frq=FY SDate=0 EDate=4 Period=FY1 CH=Fd RH=IN",H35) How do we code this in Phyton? Regards, Dan Gabriel
-
Relative financial periods are not correctly retrieved
When retrieving period data for several RICS with LSEG API the financial periods, periodenddates and values seem to be correct for several periods, but for the relative financial periods always "FY0" is given. How must I change the statement to get the correct rfperiods? This is my program: # list of RICS for…
-
Annual fundamentals data and institutional holdings data
Hello I am trying to download fundamentals data for a number of years (2000-2024) and RICs. The code I use is like this: data_items = [ "TR.CIKNumber", "TR.NAICSIndustryGroupCode", "TR.TotalAssets.date", "TR.NumberOfAnalysts", "TR.TotalCurrentAssets" ] parameters = { "SDate": start_date, "EDate": end_date, "Frq": "Y",…
-
Data item definition in Refinitiv Data Library
My formal colleague left a Python code (refinitiv.data) for entity search purpose (part of it is as below), which is running fine. But I want to get deep dive on the entity information, now I couldn't find any document like a data dictionary for me to know what get_data() returns, and what are the items meaning in returns.…
-
ReadTimeouts when Running In .py file and not in Jupyter Notebook
Hi everyone, When I run the following requests in the syntax that you see below , in a Jupyter Notebook, the requests do not timeout, however, if this is run from a Python file, I see that it is more prone to ReadTimeout errors. Is there a way that I can go about fixing this error, and know why this is occurring? tasks =…
-
how to get balance sheet item value from financial-statements API in RDP
Given concept code, where can i find the item value of the concept code? please give an demo of a concept code.
-
Optimizing Eikon API Calls for Retrieving Fundamental Data
Hey everyone, I'm working on a project on a codebook workspace where I need to pull a lot of fundamental data(322 fields) for various companies using their RICs via the Refinitiv Eikon API. The problem I'm facing is that the process is taking way too long, and I'm frequently running into gateway timeouts (Error code 2504).…
-
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…
-
Reporting frequency for Fundamental Data
I am interesting to extract the reporting frequency of fundametal data. For example, for apple i would like to get the output Quarterly as the company reports quarterly data. How could I get this value?
-
Data Library for .NET not working for RDP API company fundamentals
The client is using the Data Library for .NET (or RD Library for .NET). Please advise on the below query they are facing when trying to access the Company Snapshot and Pricing Streaming using the Data Library for .NET. It includes the Refinitiv.Data.Content.Data.FundamentalAndReference request. However, using this request…
-
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",…
-
How to retreive SIC codes via Eikon Data API?
So far I have searched for the data item via DIB and formula wizzard quite extensively. I have found NAICS, TRBCs and several else but no SICs. Have I missed it? How can I retrieve it via Eikon Data API?
-
Download single contributor IBIS python api
Hello! I am working with the python API to get IBIS estimation of financial statements for some companies. In the codecreator, I can find information about the mean. However, I am interested in the distribution of forecast instead of one single indicator. For instance, I am interested in General Motors (GM) historical…
-
Issue to retrieve RICS list for a given bond using Refinitiv Data under C#
Dear Developer community. i'm facing an issue to retrieve Ric list for a given ISIN by using Refinitiv Data (version beta4) under C#. Indeed, i'm used to retieve this list using TR.RICS field with Excel and also Python (as shown below), but it doesn't work when using FundamentalAndReference module under .Net and i have no…
-
Income statement irregularities from data API
Hello - when running the following screen, through the refinitiv.data Python API a few anomylies come up, and I hope you could help me understand why these are happening. You can see my code down below that's giving rise to these questions. * The column for asset turnover is coming out blank. However, when I run this…
