You are an investment advisor, and your client is interested in buying the XPO Logistics company stock. To make the best financial decision for your client, you want to forecast the direction of the stock and determine whether your client should buy the stock based on forecasting and quantitative analysis. You start the process by gathering data and determining what forecasting technique to use.
Complete the following steps.
Retrieve data on the closing price of the XPO stock (Symbol XPO) from January 1, 2020 to July 31, 2020. You can do this on multiple websites by using a search engine and inserting the name of the stock.
Using the time series forecasting method, moving average, compute the 10–, 30–, and 50–day continuous moving averages.
Show all data and computations for your moving averages.
o Take each number computed for the 10–day moving average, and record it in a table. Do the same for the 30– and 50–day averages.
o You can now either plot these data points in a graph or just compare them against each other to complete the next step.
Write your final analysis, and make a recommendation to your client:
o What is the data telling you?
o How do you explain it to your client?
o How accurate is this forecast for XPO?
o Can you develop a forecasting system or model that may be more reliable and accurate? Explain.