VVBA language excel

Assignment nr 2 - VBA Instructions Using data in "Assignment Sheet 2.xlsm" write scripts that: 1. Clean RI data, only keeping the firms with at least 36 consecutive months. 2. For firms' matching criteria 1) calculate monthly returns using variable Rl (after cleaning in 1 above). 3. Find basic info presented in sheet "Results". Each script must run individually. Sheet "IDs" lists all relevant firm IDs and sheet "RI" includes data for the variable "Total Return Index", which can be used to calculate stock returns. All variables were retrieved from Datastream. Expected outcome Fill the following sheets in file "Assignment Sheet 2.xlsm": 1. "Clean_RI" 2. "Returns" 3. "Results" Assignment nr 2 - VBA Instructions Using data in "Assignment Sheet 2.xlsm" write scripts that: 1. Clean RI data, only keeping the firms with at least 36 consecutive months. 2. For firms' matching criteria 1) calculate monthly returns using variable Rl (after cleaning in 1 above). 3. Find basic info presented in sheet "Results". Each script must run individually. Sheet "IDs" lists all relevant firm IDs and sheet "RI" includes data for the variable "Total Return Index", which can be used to calculate stock returns. All variables were retrieved from Datastream. Expected outcome Fill the following sheets in file "Assignment Sheet 2.xlsm": 1. "Clean_RI" 2. "Returns" 3. "Results