ConsEst functions return an aggregate statistic (consensus) of the estimates from the analysts covering the stock. Please note that many parameter combinations can have lots of N/As. For example most analysts give estimates for Current and Next Year EPS & Sales, but not two or three years out.

Consensus Statistics:

ConsEstCnt    Number of estimates
ConsEstHi    Highest estimate
ConsEstLow    Lowest estimate
ConsEstMean    Average estimate
ConsEstMedian    Median estimate
ConsEstStdDev    Standard Deviation of estimates
ConsEstUp    Number of analysts revising estimate up in past 75 days
ConsEstDn    Number of analysts revising estimate down in past 75 days

Parameters:

cons_item: use one of the values in the table below. Items with a * must use period=0

period: After an item ending with Y or Q, use a digit between 0 and 3 to specify the number of periods you want to look forward. For example, ConsEstMean(#SALEQ,1) is the mean estimate of sales for the next quarter. For items ending with NTM and for #LTG and #PT the period offset must always be 0. Default if missing is 0.

weekAgo: To see if an item has changed recently, use the weekAgo parameter. For example, to see which stocks have increased their sales estimate for the next year in the last 2 weeks, use ConsEstMean(#SALEY, 1, 0) > ConsEstMean(#SALEY, 1, 2). Note that the further you go back, the sparser the data gets.

Items with a * must use period=0.

Examples:

ConsEstCnt(#EPSY,0):  returns the number of estimates for Current Year Sales. 

ConsEstMean(#EPSQ,1):  returns the average Next Quarter EPS. 

ConsEstHi(#EBITDAY,2):  returns the high estimate for EBITDA in the year after Next Year.