To create the chart, follow these steps: Enter your data into a worksheet. Check out the data in the worksheet. Select the data that go into the chart. For this example, that’s cells A1 through E8. Click Insert | Recommended Charts, and select the chart type. Curiously, Excel does not recommend the Stock chart. In this article, we will experiment with using the exponential smoothing methods to forecast stock prices. We will start by using single exponential smoothing, followed by double exponential smoothing, and finally triple exponential smoothing (a.k.a. Holt-Winters method). Let’s say you want to retrieve stock prices for Google. Enter the stock symbol in a cell in the spreadsheet (GOOG). Once you’ve entered the stock symbol, click the ‘Custom Dates’ button in the menu. You will be presented with a custom date selection popup window. In this window, select the date range for which you want to get the stock prices.