Historical Price Range Analysis in Excel - Find Highs & Lows for Any Date Range

Published by MarketXLS Limited

About this tutorial

Historical price range analysis in Excel using MarketXLS. Learn how to find the lowest and highest stock prices between any two dates, 52-week highs and lows, and multi-week price ranges - all with simple Excel functions. Functions covered: - CUSTOM_DATES_LOW - Lowest price between any two dates - CUSTOM_DATES_HIGH - Highest price between any two dates - FIFTYTWOWEEKHIGH / FIFTYTWOWEEKLOW - Trailing 52-week range - X_WEEK_HIGH / X_WEEK_LOW - Custom week ranges Book a free demo: https://marketxls.com/demo MarketXLS is an institutional-grade, Excel-first investment research platform for professionals. Get real-time and historical stock data, options analytics, and 1,000+ functions directly in Excel. Try MarketXLS: https://marketxls.com #Excel #StockData #MarketXLS #HistoricalPrices #InvestmentResearch

Browse all MarketXLS video tutorials