Find opportunities

Functions Templates Pricing

Search for a stock

PE Ratio 5 year average

New

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")

Legal

Disclaimer Privacy Policy License Agreement Terms of Use Refund Policy DMCA Policy

Company

Contact Us Team Affiliates

Resources

MarketXLS status

Knowledge Base Services MarketXLS Review Options Trading Plugin

Demos

Book your personal Demo Video Tutorials Version 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

MarketXLS Youtube

MarketXLS Twitter

MarketXLS Linkedin

MarketXLS Facebook

MarketXLS G2