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
Alcoa Corporation logo

Alcoa Corporation

Sector: 
Basic Materials
   

Industry: 
Aluminum

40.23
 
USD
  
2.84
  
(7.60%)
Optionable: Yes  Market Cap: 7,238 M  90-day average vol: 6,414,861

Previous close: 37.39  Open: 39.16  Bid: 40.39  Ask: 40.39
52 week range    
33.55   
   98.09
Peers   
ACH / 
KALU / 
CENX / 
NHYDY / 
AWCMY / 
BBL / 
Last updated: Wednesday 5th October 2022
56
MarketXLS Rank marketxls
80
Value marketxls
30
Technical marketxls
60
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