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

VVBA language excel Assignment nr 2 - VBA Instructions Using data in 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

GRADUATE CERTIFICATE IN PROJECT MANAGEMENT PROJ5010: PROJECT PROCUREMENT AND STRATEGIC SOURCING. CASE STUDIES CONTENTS 1. Proj5010: The World Bank RFP Case Study covers 1. Assignment 1: Marks = 5 2....

Need help with Management Accounting assignment (need excel part completed)!!! AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND...

Looking for accounting tutor to complete this assignment. Need and A grade for reasonable price given easy deadline. AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO THE PERIOD UNDER...

ALL DATA RELATES TO THE PERIOD UNDER CONSIDERATION IN THIS REVIEW, AND ACTUAL AND STANDARD COSTS PER UNIT ARE UNCHANGED FROM THE PREVIOUS PERIOD AYB225 ASSIGNMENT SEMESTER 1 2015 ALL DATA RELATES TO...

think about what procedural changes would have the biggest positive impact, without being excessively costly for our lab members at every level (including undergrads!). Reference: the Lab Data Check...

PROJ592 COURSE PROJECT GUIDELINES Course Project Part 1Due Week 1 (graded, 40 points) MS Project Tutorials 5 points 1. Before starting your Course Project assignments, watch the MS Project videos and...

All the required info is attached. Make sure to address the the requirement stated 1-4. any question let me know. Case Study: Tarheel Textiles (5-7 pages) (The IIA Research Foundation, Case Studies...

113``` IST 461 - Business Analysis Assignment 3 Due by midnight on Sunday of the week it has been assigned. Consider the following scenario: "Take Me Away", a nation-wide Vacation Rental Company, is...

Study Guide Strategic Business Management By A. J. Cataldo About the Author A. J. Cataldo is currently a professor of accounting at West Chester University, in West Chester, Pennsylvania. He holds a...

EAC 594 Business Communications for the Digital Workplace Major Assignment GRADING 20% ASSIGNED: WEEK 5: MONDAY OCTOBER 3-7TH, 2022 DUE DATE: WEEK 9: FRIDAY NOVEMBER 11TH 2022 @ 11:59 pm BLACKBOARD...

You are the audit supervisor of Tokota Associates and are currently planning the audit of your existing client, Chipantepante PLC, a listed company. During a recent visit to the company you obtained...

The following items are taken from the 2006 balance sheet of Yahoo! Inc. (All dollars are in thousands.) Intangible assets ................... $3,374,379 Common stock .................... 5,292,545...

BE16.9 (LO 2) Cleveland Company has a non-trading equity investment portfolio valued at $4,000. Its cost was $3,300. Prepare the journal entry at year-end.

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

(Appendices) Courtney, age 22, is a junior at a large midwestern university. In late March, she filed applications for summer jobs with three companies. However, she does not want to start work until...

(Appendices) The Unemployment Insurance Modernization Act was included in the fiscal stimulus package of early 2009. The act was designed to modernize and make corrections to serious defects found in...

(Appendices) Kelly, age 35, spends most of her time at home taking care of her home and children. However, she works all day Friday and Saturday in her husbands computer store. She receives no...