Get current stock price

To get the current market price of a stock, you can use the "Stocks" Data Type and a simple formula. In the example shown, Data Types are in column B, and the formula in cell D5, copied down, is: =B5.Price The result in column C is the current price for each of the stock Data Types in column B. These prices will change when the Data Type is refreshed. Note: you can use the STOCKHISTORY function to get the last available close price and other historical pricing at daily, weekly, and monthly intervals. The STOCKHISTORY function is a "pure" formula approach, the approach described here requires the Stocks Data Type.