Analysis of Stocks based on their opening day and clasing days for each year.
Clone the project and use with the raw data.
The Script will return Total Volume, Yearly increase/decrease, and increase/decrease percent. Morever, for each year, the script will summarize the data to display the stock with the largest volume, greates increase and greatest decrease.
The screenshots display analysis for each Stock year.
Limitations - Certain Stocks did not have data for openeing day. They have been ignored and the percent change has been listed to 0 for them.
MS Excel VBA
- **Pratyush painuly {ALIAS : Praty}