Question: 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


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 data 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.e. 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 bere [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. Calculated daily rate of change s Dute (Adjusted) Daily Clowing Price c. Next, sont the rate of change from smallest to largest onder. (Note in Excel, before performing the sert function, it is better to first highlight rate of change column, copy and paste next to this column using "paste special as "les". Now you are ready to use Excel's Duta Sort function to sert 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 megative percentage and the date. (1 mark)
Step by Step Solution
3.49 Rating (149 Votes )
There are 3 Steps involved in it
a httpsfinanceyahoocomquoteATMNZhistoryperiod11577836800period21626912000interval1d... View full answer
Get step-by-step solutions from verified subject matter experts
