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

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")
PE Ratio 5 year average
StockPE Ratio 5 year average
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: Healthcare   

Industry: Diagnostics & Research

124.71
 
USD
  
-0.30
  
(-0.24%)
Optionable: Yes  Market Cap: 36,257 M  90-day average vol: 2,116,144

Previous close: 125.01  Open: 124.64  Bid: 124.71  Ask: 127.55
52 week range    
96.80   
   160.27
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Wednesday 29th November 2023
75
MarketXLS Rank
80
Value
69
Technical
78
Quality

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

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