H36 fx M N O R S T U V W X Y Z AA AB A B C D E F G H 13 14 15 16 CSL COH SYD TCL FMG RIO 17 2019/11/18 -0.0187 0.0013 -0.0011 -0.0040 0.0474 0.0054 18 19 20 2019/11/25 0.0500 2019/12/2 2019/12/9 -0.0103 0.0399 0.0299 0.0184 0.0239 0.0299 -0.0088 -0.0159 0.0022 -0.0171 0.0183 -0.0115 -0.0228 -0.0501 0.0040 0.0786 0.0490 21 2019/12/16 0.0120 0.0410 0.0315 0.0286 0.0212 0.0300 22 2019/12/23 -0.0037 -0.0079 0.0165 0.0013 0.0046 -0.0112 23 2019/12/30 -0.0112 -0.0306 -0.0572 -0.0445 -0.0230 -0.0113 24 2020/1/6 0.0763 0.0306 0.0420 0.0517 -0.0047 0.0105 25 2020/1/13 0.0027 0.0339 0.0212 0.0231 0.0642 0.0271 26 2020/1/20 0.0347 -0.0195 -0.0699 0.0076 0.0896 -0.0198 27 28 CSL CSL Limited 29 COH Cochlear Limited 30 SYD Sydney Airport Limited 31 TCL Transurban Group 32 FMG Fortescue Metals Group Limited 33 34 35 CSL COH SYD TCL FMG RIO 36 2019/11/18 37 2019/11/25 38 2019/12/2 39 2019/12/9 40 2019/12/16 41 2019/12/23 42 43 44 2019/12/30 2020/1/6 2020/1/13 45 2020/1/20 46 47 48 49 Name Moving Average Market Status + Ready 79% Task 3 (25%) This task is a modified version of the "If statements 2" section of your VBA 3 homework. Your task is to fix the structural errors and output to the spreadsheet. You can move the code around but you cannot copy code from your homework. You must adhere to the following conditions for this task: 1) If the stock return for that week is less than -2% then the corresponding blue cell should contain the text " 5%" 3) If a stock has a negative return and at least three other stock have a negative return in that week, the corresponding blue cells for those stocks should read "Bear Market" and any stocks that have positive returns in that week should have corresponding blue cells that read "Contrarian" 4) If a stock return for that week is more than double the average return of that stock AND not more than 6%, then the corresponding blue cell should contain the text "Bull Week" - Condition (3) take precedence over conditions (1) and (2) Condition (4) takes precedence over conditions (1), (2) and (3) If conditions (1) - (4) are all false, copy the returns over to the blue cells