IBES US and International Recommendation Detail History

There are 4 files for US history recommendation detail and International history recommendation detail.

# Name Member Type File Description
1 BKTRANS DATA Broker Translation File
2 DETAIL DATA Detail Recommendation File
3 ID DATA ID File
4 STOP DATA Recommendation Stop File

 

BKTRANS (Brocker Translation File)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
1 BrokerID Char 8 Broker ID
2 BrokerNm Char 16 Broker Name
4 End_date Num 8 End Date YYYYMMDD
3 StrtDate Num 8 Start Date YYYYMMDD

 

DETAIL (Detail Recommendation File)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
4 ActiveDt Num 8 Activation Date YYYYMMDD
5 ActiveTm Char 8 Activation Time HH:MM:SS
13 AnalstMc Num 8 Analyst Mask Code
3 AnalstNm Char 40 Analyst Name
14 AnnoucDt Num 8 Announce Date YYYYMMDD
15 AnnoucTm Char 8 Annouce Time HH:MM:SS
2 BrokerID Char 8 Broker ID
12 BrokerMc Num 8 Broker Mask Code
8 BrokerRc Char 5 Broker Rec Code
9 BrokerTx Char 20 Broker Text
10 IBESRc Char 8 IBES Rec Code
11 IBESTx Char 16 IBES Text
6 ReviewDt Num 8 Review Date YYYYMMDD
7 ReviewTm Char 8 Review Time HH:MM:SS
1 ticker Char 6 IBES Ticker

 

ID (ID File)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
3 CoName Char 16 Company Name
2 Cusip Char 8 Cusip/Sedol
9 End_Date Num 8 End Date YYYYMMDD
5 HmMktCD Char 15 Home Market Code
7 MscipFlg Char 1 MSCIP Flag
4 O_Tiker Char 6 Official Ticker
6 SigCD Char 6 SIG Code
8 StrtDate Num 8 Start Date
1 Ticker Char 6 IBES Ticker

 

STOP (Recommendation Stop File)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
3 ActiveDt Num 8 Activation Date YYYYMMDD
2 BrokerID Char 8 Broker ID
4 activeTm Char 8 Activation Time HH:MM:SS
1 ticker Char 6 IBES Ticker

 

 

IBES Recommendation Summary History

There are 2 files for US summary history recommendation and summary International history recommendation.

# Name Member Type File Description
1 ID DATA ID File
2 RECM DATA Recommendation File


ID (ID file)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
5 CoName Char 16 Company Name
13 Country Char 2 County
2 Cusip Char 8 Cusip/Sedol
15 ExCntry Char 2 Exchange Country
14 ExchgID Char 6 Exchange ID
4 HmMktCD Char 8 Home Market Code
16 InstrMnt Char 6 Instrument Type
10 MscipFlg Char 1 MSCIP Flag
3 O_Tiker Char 6 Official Ticker
9 PC_Flag Char 1 P/C Flag
7 PD_Flag Char 1 P/D Flag
12 SigCD Char 6 SIG Code
17 StrtDate Num 8 Start Date YYYYMMDD
1 Ticker Char 6 IBES Ticker
11 UnActFlg Char 1 Uniform Actual Flag
8 currency Char 3 Currency
6 dilut Num 8 Dilution Factor


RECM (Recommendation File)

Alphabetic List of Variables and Attributes
# Variable Type Len Description
9 BuyPct Num 8 Buy %
11 HoldPct Num 8 Hold %
3 Mean Num 8 Mean
6 Num_Recm Num 8 Number of recommendations
8 Num_dwn Num 8 Number of recommendations down
7 Num_up Num 8 Number of recommendations up
10 SellPct Num 8 Sell %
2 Stat_per Num 8 Stat Period YYYYMMDD
1 Ticker Char 6 IBES Ticker
4 median Num 8 Median
5 std Num 8 Standard Deviation