Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
Data

Price within 52-week Range

To be added
Compares the current price to the 5-year price range. For example, if the lowest price for past 5 years was $50, and the highest was $100, and the current price is $75, then the value is 50% because 75 is located 50% of the distance between 50 and 100.

How calculated

(current price - 52-wk low) / (52-wk high - 52-wk low)

Example usage

=Pricewithin52weekRange("MSFT")
Price within 52-week Range
StockPrice within 52-week Range
Agilent Technologies Inc. logo

Agilent Technologies Inc.

Sector: 
Healthcare
   

Industry: 
Diagnostics & Research

131.41
 
USD
  
5.03
  
(3.98%)
Optionable: Yes  Market Cap: 36,001 M  90-day average vol: 1,421,766

Previous close: 126.38  Open: 128.79  Bid: 132.2  Ask: 132.2
52 week range    
112.52   
   165.68
Peers   
TMO / 
PKI / 
DHR / 
TER / 
NATI / 
ILMN / 
AME / 
BRKR / 
GE / 
Last updated: Wednesday 5th October 2022
73
MarketXLS Rank marketxls
70
Value marketxls
69
Technical marketxls
81
Quality marketxls

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
Are you?
twitterstocktwits
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today