Technical Trading Excel Project 10 points [Please note that I have replaced this assignment with Bond excel project as per last week's announcement. Hope you find it more interesting. Please complete the assignment in Excel and upload the excel file in Canvas by November 2 midnight. Please use 3 different worksheets [to list students' name in Worksheet 1, and to answer 2 questions in the other 2 Worksheets]. The name of the Excel file should be "P4_last name/s". To get full credit, you must use Excel functions where applicable and link all calculations.] 1. Please go to finance.yahoo.com to find the monthly dividend-adjusted closing prices for the most recent four years for any company of your choice. Also collect the closing level of the S&P 500 Index over the same period. a) Calculate the four-month moving average of both the stock and the S&P 500 over time. For each series, use Excel to plot the moving average against the actual level of the stock price or index. Examine the instances where the moving average and price series cross. Is the stock more or less likely to increase when the price crosses through the moving average? Does it matter whether the price crosses the moving average from above or below? How reliable would an investment rule based on moving averages be? Perform your analysis for both the stock price and the S&P 500. b) Calculate and plot the relative strength index (RSI) of the stock compared to the S&P 500 over the sample period. Find all instances in w