Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Value
Returns analysts' consensus EPS for the current financial year.
Syntax
=EarningsEstimates_consensusEpsEstimatesTrends_currentEst_fr1_value(Symbol)Excel Templates Using Earnings Estimates Consensus Eps Estimates Trends Current Est Fr1 Value
These ready-made MarketXLS templates call EarningsEstimates_consensusEpsEstimatesTrends_currentEst_fr1_value() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Estimates formulas you can use in the same worksheet:
- Earnings Estimates Consensus Eps Estimates Trends Current Est Fr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Current Est Qr2 Value
- Earnings Estimates Consensus Eps Estimates Trends Days30Ago Fr1 Month Year
- Earnings Estimates Consensus Eps Estimates Trends Days30Ago Fr1 Value
- Earnings Estimates Consensus Eps Estimates Trends Days30Ago Fr2 Month Year
Market data in your Excel sheets
1 billion usable data points on stocks, options, ETFs, and fundamentals, with simple Excel formulas.
See plans
▶
How does MarketXLS work?