VBA-Stock-Analysis is a Visual Basic Application (VBA) project which analyzes generated stock market data.
This Stock-Analyzer Virtual Basic Scripting file loops through one year of stock data, reads and stores all the appropriate values from each row. The application creates columns for each stock, including the ticker symbol, yearly change ($), percent change, and the total volume of stock. Conditional formatting is applied to the yearly change and percent change columns, to visualize positive change highlighting in green and negative change highlighting in red.
This application also returns the stock symbol and value with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume" of that year (within the worksheet).
This application is enabled in every worksheet in the workbook at once. After all outputs are generated, auto-fit function is applied to cells on each sheet to resize cells and display all data properly.