Question Six: Mini Research on Stock and Return (Total 5 marks) Excel is required for this question Search online for The a2 Milk Company Limited (ATM.NZ) daily stock price from January 3, 2020 to July 22, 2021. a. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. The stata for the relevant period must be included in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence) (1 mark) Present the website and link here: b. Using the above data, calculate the daily rates of change (i.c. daily rates of return or daily holding period returns) of the downloaded stock prices, express the calculated rates in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of change. (1 mark) Present the rate of change formula bote: [Note: A daily rate of change refers to the rate of change in closing prices from one trading day to another For instance, the closing prices on July 12, 2021 and July 13, 2021 can be used to calculate one daily rate of change, that is, the prices from two trading days will give you one daily rate of change. If you have closing prices for n days, there will be (n-1) daily rates of change.) Suggested Excel table: To calculate the daily rate of change, set up your Excel table columns as specified below. Show respective closing prices and rates below each column Add Dwy Cloning hice calculated daily rate of charge Dund c. Next, sort the rate of change from smallest to largest order. (Note: in Excel, before performing the sort function, it is better to first highlight rate of change column, copy and paste next to this column using paste special" as "values". Now you are ready to use Excel's Data/Sort function to sort the dates and calculated daily rate of change (the pasted as "values" column) from "smallest to largest". Identify the biggest negative rate of change in percentage and the corresponding date. Include this sorted values in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence] In your Word answer file, clearly present in the space below the biggest negative percentage and the date (1 mark) Show the date here Question Six: Mini Research on Stock and Return (Total 5 marks) Excel is required for this question Search online for The a2 Milk Company Limited (ATM.NZ) daily stock price from January 3, 2020 to July 22, 2021. a. Download the above stock's daily closing price for the specified period. Save the data in an Excel file to perform the following calculations. The stata for the relevant period must be included in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence) (1 mark) Present the website and link here: b. Using the above data, calculate the daily rates of change (i.c. daily rates of return or daily holding period returns) of the downloaded stock prices, express the calculated rates in two decimal places. Evidence of calculations must be included in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence]. In your Word answer file space below, present the formula for calculating the rate of change. (1 mark) Present the rate of change formula bote: [Note: A daily rate of change refers to the rate of change in closing prices from one trading day to another For instance, the closing prices on July 12, 2021 and July 13, 2021 can be used to calculate one daily rate of change, that is, the prices from two trading days will give you one daily rate of change. If you have closing prices for n days, there will be (n-1) daily rates of change.) Suggested Excel table: To calculate the daily rate of change, set up your Excel table columns as specified below. Show respective closing prices and rates below each column Add Dwy Cloning hice calculated daily rate of charge Dund c. Next, sort the rate of change from smallest to largest order. (Note: in Excel, before performing the sort function, it is better to first highlight rate of change column, copy and paste next to this column using paste special" as "values". Now you are ready to use Excel's Data/Sort function to sort the dates and calculated daily rate of change (the pasted as "values" column) from "smallest to largest". Identify the biggest negative rate of change in percentage and the corresponding date. Include this sorted values in the Excel submission as supporting evidence (Mark deduction applies for lack of supporting evidence] In your Word answer file, clearly present in the space below the biggest negative percentage and the date (1 mark) Show the date here
