Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Data

EPS (5-Year Growth, Annualized)

To be added
Returns the annualized percent change in EPS over the past 5 years.

How calculated

(sum of EPS from past 1 year minus sum of EPS for year ended 5 years ago) divided by sum of EPS for year ended 5 years ago, and divide this by 5.

Example usage

=EPSFiveYearAnnualizedGrowth("MSFT")

Sector:    

Industry: 

 
USD
  
  
()
Optionable:   Market Cap:   90-day average vol:

Previous close:   Open:   Bid:   Ask:
52 week range    
   
   

Download MarketXLS Stock Rankings Whitepaper

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Login to add to your watchlist
overview
Option
financials
value
quality
technical
estimates
peers
news
Trend Analysis & Forecast
data
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder/CEO of MarketXLS. With over six years of experience, I've helped 2500+ customers implement personalized investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.
Get started today
Legal
DisclaimerPrivacy PolicyLicense AgreementTerms of UseRefund PolicyDMCA Policy
Company
Contact UsTeamAffiliates
Resources
MarketXLS statusStatus
Knowledge BaseServicesMarketXLS ReviewOptions Trading Plugin
Demos
Book your personal DemoVideo TutorialsVersion History
Data Sources
Toronto Stock Exchange
barchart
quotemedia
FRED data
Nasdaq
iex cloud
Financial Market Data powered by Quotemedia.com. All rights reserved. View the Terms of Use. Data delayed by 15 minutes unless indicated. Real-time data subscriptions available through our data partners and require additional exchange subscription agreements.

MarketXLS does “not” provide its own datafeed or any API access to users of the software for any commercial purposes of the user. The software is for personal use only as defined in our License Agreement. Users may not use the data provided in violation of the terms of our License Agreement.

Information provided in this solution is obtained from sources believed to be reliable. The publishers are not responsible for any errors or omissions contained herein or delivered through the software. Data and functionality of this software is subject to many factors including but not limited to internet connectivity, data interruptions, server breakdowns, trading halts etc.

Financial Market Data copyright © 2019 QuoteMedia. Data delayed 15 minutes unless otherwise indicated (view delay times for all exchanges). RT=Real-Time, EOD=End of Day, PD=Previous Day. Market Data powered by QuoteMedia. Terms of Use.

All data on this website is Copyright © MarketXLS.

© 2021 MarketXLS Limited