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

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