This assignment consisted of calculating simple statistics for some security data. The calculations and formatting were automated through VBA for Excel.
The "Hard" version of the assignment was completed which consisted of calculating Total volume
, Yearly Change
, Percent Change
on each year's worth of data and for each security. After that, the Highest % Increase
, Highest % decrease
, and Highest Volume
stats were show for each year along with the ticker that reached that ranking