Step 1: Choose your date range.
Select the date variable and range for the query.

The Forecast Period End Date is the ending month and year of the fiscal period to which the estimate applies. The Activation Date is the date that the forecast/actual was recorded by Thomson Reuters. The Announce Date is the date that the forecast/actual was reported. The Review Date is Most recent date that an estimate was confirmed as accurate. Note that for Long Term Growth estimates, you must NOT select "Forecast Period End Date" as the Date Variable in Step One or the query will not return any estimates.
to
Step 2: Apply your company codes.

Using Ticker Symbols and Cusips

You can further refine the search by selecting values for the IBES Universe (U.S. and/or International files), IBES Measure (e.g., EPS) and Forecast Period Indicator (FPI).

Note that for FPI = 0 (Long-Term Growth) estimates, you must NOT select "Forecast Period End Date" as the Date Variable in Step One or the query will not return any results (for FPI = 0).

  •  
  •  
  •  

Select an option for entering company codes.

Please enter Company codes separated by a space.
Example: IBM MSFT AAPL [ Code Lookup ]
Save code list to Saved Codes
Browse…
Upload a plain text file (.txt), having one code per line.
Choose from your saved codelists.
Search the entire database.
This method allows you to search the entire database of records. Please be aware that this method can take a very long time to run because it is dependent upon the size of the database.
       

Measures (non-EPS may be sparse)

Select the items you would like to include in your search.

Selected 1

Select 22

Forecast Period Indicator (FPI)

Select the items you would like to include in your search.

Selected 1

Select 32

Step 3: Query Variables.

Select the desired IBES variables to be included in the output.

See Variable Descriptions for a description of each data item.

How does this work?

Selected 8

Select

Select 3

Select 14

Step 4: Select query output.

Please select the variables by which you would like your results sorted.

1.

2.

3.

Select the desired format of the output file. For large data requests, select a compression type to expedite downloads. If you enter your email address, you will receive an email that contains a URL to the output file when the data request is finished processing.

Output Format
 
 
 
 
 
 
 
 
 
 
 
Compression Type
 
 
 
Date Format


Detail History - Detail File with Actuals

Library: ibes
File: det
Update Schedule: Quarterly

Detail Estimate is the core of the Detail History product. This file contains analyst-by-analyst estimates for annual, quarterly, semi-annual and long terms growth periods.Quarterly estimates and long-term growth forecasts are most prominent for US and Canadian companies. Semi-annual estimates are available for Japanese companies.

It is possible for a contributing broker to provide multiple revisions to an estimate on the same day. In this scenario, all estimates are available in the Detail history files and only the most current estimate is included in the mean.

In the non-US files, for estimates received on a Parent-company basis a "P" appears in field CURRFL of this file. If an estimate was received on a Consolidated-company basis then an indicator is not present in field CURRFL. In the US file, if the Canadian Currency field CURRFL is C, the estimate was received in Canadian currency. If the indicator is not present, the estimate is in US Dollars.

The Currency field (CURR) and the Primary/Diluted Flag (PDF) in this file are Estimate specific. When programming against the data, it is important not to confuse these fields with the Currency field in the Report Currency file (REPORT_CURR) and the Primary/Diluted Indicator in the Identifier file. The records in the Report Currency file and 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 an analyst's forecast is received with different Currency or Primary/Diluted indicators on the estimate level versus the existing company level, the estimate value will appear as adjusted to the company level basis. The indicators reflect the basis in which the estimate was received. Users may "unadjust" the data if they choose using data provided in the Identifier or Exchange Rate files.

Timestamps are provided with the Activation, Announce and Confirmation dates included in this file.

Variable Reference

Variable Name Data Type Variable Description Help
ACTDATS NUM Activation Date, SAS Format
ACTDATS_ACT NUM Activation Date of the Actual, from the Detail Actual File, SAS Format
ACTTIMS NUM Activation Time, SAS Format
ACTTIMS_ACT NUM Activation Time of the Actual, from the Detail Actual File, SAS Format
ACTUAL NUM Actual Value, from the Detail Actuals File
ANALYS NUM Analyst Code
ANNDATS NUM Announce Date, SAS Format
ANNDATS_ACT NUM Announce Date of the Actual, from the Detail Actuals File, SAS Format
ANNTIMS NUM Announce Time, SAS Format
ANNTIMS_ACT NUM Announce Time of the Actual, from the Detail Actuals File, SAS Format
CNAME CHAR Company Name
CURR CHAR Currency
CURR_ACT CHAR Currency from the detail Actuals File
CURRFL CHAR Canadian Currency (Estimate Level)
CUSIP CHAR CUSIP (8-digit)
ESTIMATOR NUM Estimator
FPEDATS NUM Forecast Period End Date, SAS Format
OFTIC CHAR Official Ticker
PDF CHAR Primary/Diluted Flag(Estimate Level)
REPORT_CURR CHAR Report Currency from Report Currency File
REVDATS NUM Review Date, SAS Format
REVTIMS NUM Review Time, SAS Format
TICKER CHAR I/B/E/S Ticker
USFIRM NUM U.S. Firm (USFIRM=0 if from .INT, and USFIRM=1 if from .US file)
VALUE NUM Estimate Value
1.  Merging International I/B/E/S with Compustat Global
2.  Getting LTG Estimates from IBES
3.  Distinguishing between Investment Bank Firms and "Independent Research" Fir...
4.  Calculating the Number of Analysts Making Earnings Forecasts for Each Firm
5.  Differences Observed between Reported EPS Values in Compustat and the Actua...
6.  First Call Vs. IBES
7.  Finding Historical Data on 5-year Projected Growth Rates
8.  Analyst Treatment of Voluntary Expensing of Stock Options
9.  Price for Accessing the IBES Database
10.  Identifying Analysts in IBES that are Based Outside the US
11.  IBES Estimate Dates: Coming after the Forecast Period End Date
12.  Locating a Pre 2002 Version of the IBES Data
13.  Many Instances of Missing Values for the STDEV (Standard Deviation) in the ...
14.  Merging PACAP and IBES
15.  Duplicate PERMNOs: Using the CRSP MSFNAMES File to Create a Historical CUSI...
16.  Joining IBES Adjustment Split Factor with the Detail History File
17.  Program act.sas Using EPS Figures Adjusted for Stock Splits
18.  Difference Between IBES Earnings Announcement Date and Compustat Announceme...
19.  Analyst Following of a Firm Uncovered by IBES
20.  Finding Information about the Number of Shares Outstanding
21.  Matching IBES Detail Recommendations with Detail History File
22.  OFTIC Being a Numeric Number
23.  Locating the Standard Deviation of Analysts' Forecasts for All UK Companies
24.  IBES Broker Transaction Files
25.  Translating SEDOL Code into Country Full Names and Obtaining the Currency
26.  Analysts' Schedules in releasing their Earning Forecast; Ways to Construct ...
27.  Examining FPI
28.  Datasets Dowloaded in April and in September are the Same Dataset but Conta...
29.  Earnings Forecast Data Estimators and Analysts Vs. Recommendation Data Esti...
30.  Understanding IBES Currency Variables
31.  Getting a List of Companies whose Initial Recommendation by a Particular Br...
32.  IBES Detail History Unadjusted: Observations where ANNDATS is Far before FP...
33.  Finding Dividend Announcement Data (Announcement Date and Amount) and Analy...
34.  Paper "Rewriting History": Claims Non-Trivial Number of Additions, Deletion...
35.  IBES Detail History: Tickers for which Most Estimates were Reported on One ...
36.  Finding the Country Codes in IBES
37.  Differences Between Compustat and IBES EPS/CPS Numbers
38.  Computing Consensus Forecast and Consensus Recommendation from the IBES Det...
39.  Computing Consensus Forecast and Consensus Recommendation at the End of the...
40.  Effective Split Dates in IBES: Locating the Actual Stock Split Dates
41.  Checking which Brokers and Tickers have been Excluded from the Most Current...
42.  Prices in IBES Being Aligned with Actuals and Forecasts in Terms of Diluted...
43.  Detail History File: Meanings of the Date Variables
44.  Variable Definition Found in the IBES Glossary, but Can't Find the Data for...
45.  Effect of Announce Date of Earnings (ANNDATS) on the Forecast Period Indica...
46.  About IBES
47.  More Records in SATSUM (Adjusted Summary) than in STATSUMU (Unadjusted Summ...
48.  ANNDATS <= ACTDATS: Some Situations where This is Not the Case
49.  Forecasting Data from Major Companies Listed on the European Stock Markets
50.  STDEV: Calculated on the Forecasts Issued During the Month or on All Foreca...
51.  Explaining the Post-Earnings Announcement Drift Research Application
52.  Source of IBES Historical Timestamp
53.  Locating Price-to-Earnings Forecasts to Infer the Forecasts of Price
54.  Treatment of Cases where the Analysts Provide a Range for their Price Targe...
55.  IBES Unadjusted Forecasts: Fixing the Problem for IBES Unadjusted Forecasts...
56.  IBES Summary File Downloads Generate Multiple Records for a Single CUSIP/S...
57.  Screening for Canadian Companies
58.  Finding Industry Recommendations in IBES
59.  Individual Estimates: Adjusted for Primary or Diluted According to the Cons...
60.  Analyst Names with Two or More Distinct Codes
61.  LTG & FVYGRO
62.  Meaning of 00:00:00 Values in the IBES Announcement Time (anntims)
63.  Locating a 5-year Historical Growth Actuals
64.  Significant Increase in the Number of Additional Measures in IBES Due to An...
65.  Definition of IBES CPS
66.  ESTIMATOR (in Data Estimated History) & EMASKCD (in Detail Recommendation H...
67.  Possibility of Isolating the Notices of Termination Issued by Analysts from...
68.  Merging IBES with Compustat Cusip
69.  Running SAS Code that Uses IBES Files(ACTU, STATSUMU, DETU, and Others) and...
70.  Identifying Type of Analyst (Sell Side, Buy Side, Independent)
71.  Single Analyst Code was Related with an Abnormally High Number of Brokers w...
72.  Estimator Code Vs. Analyst Code; Removing Stopped and Excluded Estimates
73.  Getting a 12 Month Forward Consensus Estimation for the P/E Ratio of the S&...
74.  WRDS Not Receiving Merrill Lynch's Estimates Individually
75.  Ibes academic version
76.  Thomson Reuters: Price Target Variable (varname PTG)
77.  Finding the Mean EPS Estimate at the Time of the Earnings Release for a Giv...
78.  IBES Detail History: Tickers for which Most Estimates were Reported on One ...
79.  Converting IBES Industry Codes to SIC Codes
80.  Obtaining the "life cycle" for Each Brokerage Firm in IBES
81.  Estimates on a Primary vs. Diluted basis
82.  Merging with CRSP or Compustat
83.  Variable FPI: Relationship to IBES Date Variables
84.  Meaning of the Analyst Codes in IBES International Data
85.  Top Down Forecasts Vs. Bottom Up Forecasts
86.  Fewer observations for BROKER code 00211 between the December, 2002 Version...
87.  "0" Code for an Analyst
88.  Unadjusting Accuracy Issues
89.  "Stopped Estimates"
90.  Differences between IBES Glossary and variables listed in IBES database on ...
91.  Computing the Consensus Meidan/Mean Forecasts in the Summary File
92.  Price Used when Calculating the Forecast Accuracy
93.  No Output for Long-Term Growth Rates
94.  Matching an Analyst's Detail History Estimates for a Company with the Assoc...
95.  ADRs and Canadian Firms Covered in IBES
96.  Aggregating the Six Digit Group Codes (SIGC)
97.  Data Item "actual EPS": Reported or Restated Data
98.  IBES Estimate Flag (ESTFLAG)
99.  Using 6 Digit CUSIPs to Merge IBES and CRSP Data
100.  Variables: ESTFLAG, ACTUALF, and CCOPCF
101.  Locating the Number of Analysts Following a Stock
102.  First Call: Inclusion of Conference Call Data
103.  Variables in Detail History File: CURRFL and CURR

The Institutional Brokers Estimates System provides consensus and detail forecasts from security analysts, including earnings per share, revenue, cash flow, long-term growth projections and stock recommendations.

Path on WRDS Server: /wrds/ibes/sasdata

Position Variable Name Type Length Description
1 TICKER Char 6 IBES Ticker Symbol
2 CUSIP Char 8 CUSIP/SEDOL
3 OFTIC Char 6 Official Ticker Symbol
4 CNAME Char 16 Company Name
5 ACTDATS Num 8 Activation Date, SAS Format
6 ESTIMATOR Num 8 Contributing estimator code
7 ANALYS Num 8 Analyst Code
8 CURRFL Char 1 Canadian Currency Flag (Estimate Level)
9 PDF Char 1 Primary/Diluted Flag (Estimate Level)
10 FPI Char 1 Forecast Period Indicator
11 MEASURE Char 3 Measure (Data Type Indicator)
12 VALUE Num 8 Estimate Value
13 CURR Char 3 Currency
14 USFIRM Num 8 USFIRM=0 if from .INT file and USFIRM=1 if from .US file
15 FPEDATS Num 8 Forecast Period End Date, SAS Format
16 ACTTIMS Num 8 Activation Time, SAS Format
17 REVDATS Num 8 Review Date, SAS Format
18 REVTIMS Num 8 Review Time, SAS Format
19 ANNDATS Num 8 Announce Date, SAS Format
20 ANNTIMS Num 8 Announce time, SAS Format
21 ACTUAL Num 8 Actual Value, from the Detail Actuals File
22 ACTDATS_ACT Num 8 Activation date of the Actual, from the Actuals File
22 ANNDATS_ACT Num 8 Announce date of the Actual, from the Detail Actuals File
23 ACTTIMS_ACT Num 8 Activation time of the Actual, from the Actuals File
23 ANNTIMS_ACT Num 8 Announce time of the Actual, from the Detail Actuals File
24 CURR_ACT Char 3 Currency from the Detail Actuals file
25 report_curr Char 3 Report Currency