EPS Growth (Historical) Formula in Excel

EPS Growth (Historical) is a powerful MarketXLS function that helps you quickly measure a company's historical growth in earnings per share. By using this formula in Excel, you can analyze EPS trends, compare different companies, and make more informed investment decisions. In this guide, you’ll learn how to use the EPS Growth (Historical) formula, its parameters, practical examples, and best practices.

Understanding EPS Growth (Historical)

• The EPS Growth (Historical) formula returns the growth in earnings per share for a specific year or quarter.
• It helps investors and analysts identify trends in profitability, assisting with valuation and performance comparisons.
• Use this formula when you want to track a stock’s earnings improvement or decline over various periods.

? Pro Tip: Combine EPS Growth (Historical) results with other key fundamentals like revenue growth, net income, and profit margins to get a broader picture of a company’s financial health.

Syntax and Parameters

=hf_EPS_Growth(Symbol, year, [quarter], [TTM])

?? Note: The function returns "NA" if the symbol is invalid or if your MarketXLS license does not support historical fundamental data.

Return Value

• Typically returns a numeric value representing the EPS growth rate (e.g., 0.15 for 15% growth).
• Returns "NA" if data is not available or an error occurs during the data retrieval process.

Examples and Usage

Below are a few ways to use the hf_EPS_Growth formula in Excel:

1. Basic Usage by Year

   =hf_EPS_Growth("MSFT", 2022)

   Retrieves EPS growth for Microsoft in the year 2022 (quarter defaults to 1).

2. Specific Quarter and TTM

   =hf_EPS_Growth("MSFT", "2022", "2", "TTM")

   Retrieves EPS growth for Microsoft in Q2 2022 on a trailing twelve months basis.

3. Using Special Keywords (Last Quarter, Last Year)

   =hf_EPS_Growth("MSFT", "lq")
   =hf_EPS_Growth("MSFT", "ly")

   • "lq" automatically references the most recent quarter.
   • "ly" references the most recent full year.

4. Going Back Further Periods

   =hf_EPS_Growth("MSFT", "lq-1")
   =hf_EPS_Growth("MSFT", "ly-1")

   • "lq-1" references the quarter prior to the last quarter reported.
   • "ly-1" references one year prior to the last year reported.

5. Using Different Date Input Styles

   • Cell reference:

     =hf_EPS_Growth("MSFT", A1)

   • Direct date string:

     =hf_EPS_Growth("MSFT", "2024-03-15")

   • Excel date function:

     =hf_EPS_Growth("MSFT", TEXT(A1,"yyyy-mm-dd"))

? Pro Tip: Combine multiple calls to hf_EPS_Growth to compare year-over-year and quarter-over-quarter EPS trends for a deeper financial analysis.

Common Questions

1. What happens if I use an invalid symbol?

   • The formula returns "NA" if the symbol is not recognized or supported.

2. Why do I see "NA" in some cells?

   • This usually indicates data is unavailable, you have a licensing limitation, or there’s an error with the web query.

3. Can I use the function for multiple stocks simultaneously?

   • Yes. You can drag the formula down or across your Excel sheet for different ticker symbols.

4. How often is the data updated?

   • MarketXLS typically updates historical fundamentals daily. However, it depends on the data provider and subscription level.

5. Are there performance considerations when using this function?

   • Since hf_EPS_Growth fetches data from an external service, performance depends on internet connectivity and dataset size. Minimizing the number of simultaneous calls can help optimize speed.

?? Note: Ensure you have the right MarketXLS subscription plan that includes historical fundamentals to use this function seamlessly.