manc1n1/VBA-challenge

VBA Challenge

Table of Contents

• Description
• Installation
• Usage
• Credits

Description

A Visual Basic Script that loops through all the stocks for one year and outputs the following information:

• The ticker symbol.

• Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year.

• The percentage change from the opening price at the beginning of a given year to the closing price at the end of that year.

As well as:

• Add functionality to your script to return the stock with the "Greatest % Increase", "Greatest % Decrease", and "Greatest Total Volume".

• Make the appropriate adjustments to your VBA script to enable it to run on every worksheet (that is, every year) at once.

Installation

1. Clone the repo

   git clone https://github.com/manc1n1/VBA-challenge.git

2. Change directories to VBA-challenge

   cd VBA-challenge

3. Run the Visual Basic Script in your .xlsm file.

Usage

1. Run the macro in the .xlsm file.

Credits

Starter Code Download