PE Ratio 5 year average

  Live
The ratio for valuing a company that measures its current share price relative to its earnings over a period of 5 years

Example usage

=PERatioFiveYearAverage("msft")

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!

Legal
DisclaimerPrivacy PolicyLicense AgreementTerms of UseRefund Policy
Company
Contact UsTeamAffiliates
Resources
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
Illustrations designed by Freepik

Disclaimer
None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. None of the information providers or their affiliates will advise you personally concerning the nature, potential, value, or suitability of any particular security, portfolio of securities, transaction, investment strategy, or other matter.
MarketXLS Scores and rankings are meant only for informational purposes. They are not intended to be investment advice or a recommendation to buy or sell any security.

Trade at your Own Risk
Stocks, options, and investing, in general, are risky and can and result in considerable loss. None of the strategies, stocks, or information discussed or presented are financial or trading advice or recommendations. The author assumes no liability, including for errors and omissions. Everything presented is the author’s ideas and opinions only.

There are considerable risks involved in implementing any investment strategies. The author does not provide financial advice of any kind. The stocks, options, and strategies discussed are simply ideas only and are not financial advice or recommendations. The author may or may not at any time be holding securities discussed. Trade at your own risk.

No Investment Recommendations or Professional Advice
Nothing on the site should be construed as an offer to sell, a solicitation of an offer to buy, or a recommendation for any security or product. The author is not offering any professional advice of any kind. Reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.