Excel Formula Reference: Stock Analysis

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

  • All these formulas require both a stock ticker and period, for example: =EPF.Yahoo.EPS.Estimate.Average.Quarter("AAPL",0)
  • To specify the current quarter/year use 0 for the second pararmeter; to specify the next quarter/year use 1 etc.

EPS Revisions

Yahoo Finance EPS Revisions

All of these formulas require a stock ticker and period, for example: =EPF.Yahoo.EPS.Estimate.Average.Annual("AAPL",1) provides the average EPS estimate for the next year for Apple stock.

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.


Growth Estimates

Yahoo Finance Growth Estimates

All of these formulas require a stock ticker and period, for example: =EPF.Yahoo.Growth.Estimate.Annual("AAPL",5) provides the 5 year annual growth estimate for Apple stock.

Formula Description
EPF.Yahoo.Growth.Estimate.Quarter Quarterly Growth Estimate.
EPF.Yahoo.Growth.Estimate.Annual Annual Growth Estimate.