I/B/E/S Detail History (with Actuals)

Detail

The Detail File is the core of the Detail Estimate History. At it's essence it is a timeline of 9 years of earnings forecast changes. Each of the other files provided augments the Detail File. The Detail File contains Analyst by Analyst estimates for as many as five fiscal year periods and four quarterly forecasts as well as long term growth estimates for each security followed

	Variable Name	Type	Variable Label
	ANALYS	Num	Analyst Code
	BROKER	Num	Broker Code
	CURR	Char	Currency
	CURRFL	Char	Currency Flag (Estimate Level)
	ESTDATX	Char	Estimate Date (Original IBES Format)
	ESTDATS	Num	Estimate Date (SAS Format)
	FPEDATX	Char	Forecast Period End Date (Original IBES Format)
	FPEDATS	Num	Forecast Period End Date (SAS Format)
	FPI	Char	Forecast Period Indicator
	MEASURE	Char	Measure (Data Type Indicator)
	PDF	Char	Primary/Diluted Flag (Estimate Level)
	REVDATX	Char	Review Date (Original IBES Format)
	REVDATS	Num	Review Date (SAS Format)
	TICKER	Char	I/B/E/S Ticker Symbol
	VALUE	Num	Estimate Value
	USFIRM	Num	1 If US Firm, 0 Otherwise
	ACTUAL	Num	Actual Value
	REPDATS	Num	Report Date, SAS Format

Notes

• The Broker Code and Analyst Code fields are provided as numbered codes. This has been done for programming ease.
• There are some Canadian companies that are also listed on US exchanges. Estimates for these companies are generally provided in the company's reporting currency.
• The Currency flag and Primary Diluted Flag in this file are estimate specific. When programming against the data it is important not to confuse these fields with the Currency Indicator and Primary/Diluted Indicator in the Identifier File. The records in the Identifier File are Company specific. It is very important to note that all data in the Detail File is completely adjusted. That is, if a single analyst's forecast was received with a different Currency or Primary/Diluted indicators on the company and estimate level it appears on an adjusted basis. The flags appear so that users may unadjust the data if they choose using data provided in the Identifier or Exchange Rate files.
• The ACTUAL and REPDATS variables were merged into this file from the Actuals data. You can use a web query to extract these data from this file by using the "Detail + Actuals" Merged Query.