In its most basic form, you can look up a stock for a date range and STOCKHISTORY will spill an array of dates and closing prices: Note: I’ve linked it to a Stock Data Type in cell B3, but you could just as easily enter the stock symbol in double quotes inside the formula e.g...