PE Ratio 5 Year Average - MarketXLS Analytics
Description
Returns the PE Ratio 5 Year Average which indicates a company's valuation based on its current share price relative to its average earnings over a 5-year period.
Syntax
PERatioFiveYearAverage(ByVal Symbol)Examples
=PERatioFiveYearAverage("MSFT")
Data Type: float
Historical Data Available: No
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?