-
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
-
FCF estimated data from Eikon API doesn't match WS
Hi everyone, I'm confused why the historical free cash flow estimations don't match that of Workspace? Please have a look at the screenshots below: AAPL, Free cash flow estimations from Eikon API AAPL, historical free cash flow estimations from WS In the first photo, the free cash flow estimations (Mean) are highlighted in…
-
Can we pull up the EPS (Earnings per Share) guidance low value and guidance high value for WMT (S...
...ample RIC/Company) as the same values in the Estimates Page -> Guidance Summary in Workspace Codebook? I am using Codebook and code creator in pulling up the Guidance Low Value and guidance high value for WMT (My sample RIC). Can we pull up the EPS (Earnings Per Share) Guidance Low Value and Guidance High Value for WMT…
-
Extracting analyst estimates data using Not Null filter for period end date
Hi, I am trying to extract the analyst estimates data as mentioned in the code below - df, err = ek.get_data( instruments = ric_lst, fields = ['TR.EPSMean.periodenddate', 'TR.EPSMean', 'TR.EPSMean.date','TR.RevenueMean', 'TR.NetProfitMean'], parameters={'SDate':'2010-01-01','EDate':'2023-12-13','Period':'FQ1'}) The issue I…
-
Retrieiving recommendation date from I/B/E/S data
I am trying to retrieve the date when an analysts recommendation changed from the I/B/E/S data. I can see different items that detail the change but not when the change was made. What is the data item that we need to get this date? In Workspace you can see this as review date or recommendation date in the recommendation…
-
EPS Estimates Don't Align with Analyst Name or Analyst Code
Hi. I am trying to pull the EPS estimates, associated Broker Name, Analyst Name, Analyst Code, and Estimate Date for a variety of tickers and variety of dates that span between 1989 and the present. I have provided sample code below for pulling for a single ticker from 1989. Some of the values are <NA> for the EPS…
-
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…
-
date and fperiod in TR.NetprofitEstValue
I am trying to get data of field TR.NetprofitEstValue(Period=FQ1) I think FQ1 means it will get the next quarter's estimation. But in the following data I got: some 'date' is early than 'fperiod' more than 1 quarter. Why will this occur when I get FQ1 data? Or there are more examples or explain about FQ0/FQ1/FQ2/... and…
-
Mismatching of quarterly EPS surprise date and earning announcement dates
I'm doing a research on Taiwan market and retrieved earning surprise data from DataStream. for example, I collected quarterly earing surprise announcement dates (EPSISURDTE) and quarterly EPS surprise score (EPSISURSUE), I find EPSISURDTE is different from quarterly earnings announcement dates on TWSE. What is the…
-
How to retrieve interim IBES data
Hi everyone, Could you please let me know how to retrieve the interim estimates data using Eikon API. More specifically, I would like to reconstruct the table below. I was able to get yearly data using the following R code, but do now know what parameters should be changed to get the semi-annual data.…
-
Summary of revisions of sell side analysts' and economists' forecasts
I am instructed to post a following question here by Helpdesk. Hope someone can take care of it. I am looking for an efficient way of checking the latest revisions of (1) sell side analysts’ earnings estimates of individual company and (2) economists’ forecasts of macroeconomic variables (such as GDP QoQ). For (1),…
-
FIXED INCOME ETF
hI EVERYBODY, I´m currently trying to analyze a series of instruments in funds, these are majorly of Equities, but i have this issue : Using a particular case as an example(FLOT) FLOT.K, I would like to know the equivalent of obtaining the YAS (Yield and spread) analysis on bloomberg, to calculate the "expected return" of…
-
IBES data with python
how to download IBES data from python?
-
404 error when pulling I/B/E/S data
Hi, I am trying to get I/B/E/S data through the refinitiv API with python but I keep on getting a 404 error. I use python 3.7 and this is the endpoint I use: https://api.refinitiv.com/data/estimates/beta1/viewsummary/annual My authorizations are fine, I run other code examples and I get the data correctly. Also I am using…
-
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,
