1. The excel file closing stock prices provides data for four stocks over a 6 month period.
A. Develop a spreadsheet module for forecasting each of the stock prices using simple moving average and simple exponential smoothing.
B. Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. (You might consider using data tables to facilitate your search).
A moving average forecast and exponential smoothing forecast has been performed on stock prices in EXCEL. Further calculations for Forecast Accuracy Measures (Forecast Error, MAD, MSE, MAPD) has been shown in Excel for the two different Forecast techniques and the accuracy of the two forecasts has been compared using these calculations.