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
ConsEstRSD(...) Relative 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.
| cons_item | Estimate | period |
| #EPSY | EPS annual | |
| #EPSQ | EPS quarterly | |
| #EPSNTM | EPS next twelve months | * |
| #SALEY | Sales annual | |
| #SALEQ | Sales quarterly | |
| #SALENTM | Sales next twelve months | * |
| #EBITDAY | EBITDA annual | |
| #EBITDAQ | EBITDA quarterly | |
| #EBITDANTM | EBITDA next twelve months | * |
| #CAPXY | CapEx annual | |
| #CAPXQ | CapEx quarterly | |
| #CAPXNTM | CapEx next twelve months | * |
| #FCFY | Free cash flow annual | |
| #FCFQ | Free cash flow quarterly | |
| #FCFNTM | Free cash flow next twelve months | |
| #LTG | Long-term growth | * |
| #PT | Price target | * |
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.