VBA-challennge

VBA homework

1. In this repository you will find vb script that will extratct information from file with information from Stock Market and give the folloing output:

   • create a summary list with the yearly price change, % of yearly price change and the total tock volume per ticker symbol.
   • asign color values for positive yearly change and negative yearly change.

2. In the bonus part it should extract from the previous list, the following:

   • Code that will allow the subroutine to work on all worksheets bya jus running once
   • greatest yearly increase
   • greatest yearly dectease
   • greatest stock volume

3. You will also find screen shots from the results