Excel Formula Reference: Stock Estimates and Revisions

Excel Price Feed provides Excel formulas for both analyst EPS estimates and revisions.

  • All these formulas require both a stock ticker and period, for example: =EPF.Yahoo.EPS.Estimate.Average.Quarter("AAPL",0)
  • Yahoo Finance generally provides 4 data periods: current quarter, next quarter, current year and next year.
    To specify the current quarter/year use 0 for the second pararmeter; to specify the next quarter/year use 1
  • For example the forumla: EPF.Yahoo.EPS.Estimate.Average.Annual("AAPL",1) will retrieve the average EPS estimate for the next year.

Yahoo Finance EPS Revisions

Formula Description
EPF.Yahoo.EPS.Estimate.Average.Quarter Quarterly EPS Average Estimate.
EPF.Yahoo.EPS.Estimate.Average.Annual Annual EPS Average Estimate.
EPF.Yahoo.EPS.Revisions.UpLast7Days.Quarter Number of Quarterly EPS Revisions
Up in the last 7 days.
EPF.Yahoo.EPS.Revisions.UpLast7Days.Annual Number of Annual EPS Revisions
Up in the last 7 days.
EPF.Yahoo.EPS.Revisions.UpLast30Days.Quarter Number of Quarterly EPS Revisions
Up in the last 30 days.
EPF.Yahoo.EPS.Revisions.UpLast30Days.Annual Number of Annual EPS Revisions
Up in the last 30 days.
EPF.Yahoo.EPS.Revisions.DownLast7Days.Quarter Number of Quarterly EPS Revisions
Down in the last 7 days.
EPF.Yahoo.EPS.Revisions.DownLast7Days.Annual Number of Annual EPS Revisions
Down in the last 7 days.
EPF.Yahoo.EPS.Revisions.DownLast30Days.Quarter Number of Quarterly EPS Revisions
Down in the last 30 days.
EPF.Yahoo.EPS.Revisions.DownLast30Days.Annual Number of Annual EPS Revisions
Down in the last 30 days.