I/B/E/S provides powerful insight into the depth of the I/B/E/S quality database of historical estimates, which has been the proving
ground for new, innovative investment strategies for 30 years. The database has a superior reputation for historical data, and is
especially known for its unparalleled quality and depth among both practitioners and academicians.
<Note> I/B/E/S places restrictions on the use of its data. You must state that you have acknowledged and agreed to the conditions
for use as set by Thomson Financial. Please review the "How to Access" and "Statement of Conditions" on Drive R:\. If
you plan to use I/B/E/S data for research, send an email with a description of the project that uses the I/B/E/S data to the
UNT I/B/E/S Research Coordinator. Currently that is Dr. James Conover of the FIREL Department:
File Format (Detail Earnings Estimate History)
The Daily Detailed Earnings Estimate History is setup in a
relational database format. It is comprised of 10 data files. The joining
variable key for most of the files is the I/B/E/S Ticker. The I/B/E/S ticker is a unique identifier assigned to each security that is
consistent throughout the I/B/E/S history (thus no survivorship bias). Most other common identifiers (CUSIP, SEDOL, Official
Ticker, Company Name) are subject to change over time. If one of these variables is your preference each is available in 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.
Identifier File: provides ancillary data for informational purposes. It can be linked to the Detail File using the I/B/E/S Ticker. There
are 12 data fields within the file.
Adjustments File: deals primarily with splits. All data in the detail file appears on a split adjusted basis. This means that historical
data appears on the same basis as current data. The data in the file is provided for those clients who wish to "unsplit" the data and
use it as it originally appeared.
I/B/E/S International Edition
Sample Programs to Read I/B/E/S
1. U.S. Detail File
Input Ticker $ 1-6 Broker 8-12 Analyst 14-19 Currency $ 20-21 PD $ 22-23 Indicator $ 24-25 Measure $ 27-29 End 31-34 Value 36-44 .2 Est yymmdd7. Review yymmdd7.;
Format Est yymmdd6. Review yymmdd6.;
U.S. Detail File Output Screenshot:
2. U.S. Identifier File
DataIdentifier; infile 'R:\IBES\Data\Idfild.us'; input Ticker $ 1-6 cusip $ 8-15 Symbol $ 17-22 Coname $ 24-39 Dilution $ 41-45 PD $ 47 CanCur $ 49 MSCIP $51 Actuals $53 SIG 55-60 Start yymmdd7.; format Start yymmdd6.;
U.S. Identifier File Output:
3. U.S. Adjustments File
DataAdjustment; infile 'R:\IBES\Data\Adjfild.us'; input Ticker $ 1-6 Adjustment 8-14 .2 Split yymmdd7.;; format Split yymmdd6.;
U.S. Adjustment File Output:
4. U.S. Excluded Estimates File
Input Ticker $ 1-6 Broker 8-12 Analyst 14-19 Indicator $ 21 Measure $ 23-25 End 27-30 Value 32-40 .2 Est yymmdd7. Exclude yymmdd7. Flag $ 56;
Format Est yymmdd6. Exclude yymmdd6.;
5. U.S. Broker Translations File
6. U.S. S/I/G Codes File
input SIG 1-6 Sector_Abbrev $ 8-15 Sector $ 17-40 Industry_Abbrev $ 42-49 Industry $ 51-74 Group_Abbrev $ 76-83 Group $85-108;
U.S. S/I/G Codes File Output:
7. U.S. Stopped Estimates File
DataStopped; infile 'R:\IBES\Data\stpfilat.us'; input Ticker $ 1-6 Broker 8-12 Periodicity $ 14 Measure $ 16-18 End $ 20-23 Stop $ 25-30;
8. U.S. Exchange Rate File
DataFX; infile 'R:\IBES\Data\canxfild.usc.txt'; input Publication $ 1-6 Rate 8-19 Currency $21-23;
U.S. Exchange Rate File Output:
9. U.S. Report Currency File
DataCurrency; infile 'R:\IBES\Data\Curfild.us'; input Ticker $ 1-6 Date $ 8-13 Currency $ 15-17;
U.S. Report Currency File Output:
10. U.S. Actuals Files
DataActuals; infile 'R:\IBES\Data\actfildc.us'; input Ticker $ 1-6 Measure $ 8-10 Periodicity $ 12-14 End $ 16-19 Value 21-29 .2 Report $31-36;
FIRST CALL I/B/E/S Online.
I/B/E/S Detail History User's Guide U.S. Edition.
I/B/E/S Detail History User's Guide International Edition.