Skip to content

Latest commit

 

History

History
4 lines (3 loc) · 518 Bytes

README.md

File metadata and controls

4 lines (3 loc) · 518 Bytes

Stock-Data-Analysis

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