The VBA of Wall Street
Script loops through all the stocks for one year and output the following information. (Sub Stock()
-
The ticker symbol.
-
Yearly change from opening price at the beginning of a given year to the closing price at the end of that year.
-
The percent change from opening price at the beginning of a given year to the closing price at the end of that year.
-
The total stock volume of the stock.
*If a stock has a positive change, it will be green, if negative, it will be red
There is also summary statistic, Bonus MaxSum [Sub MaxVals()] will output
- "Greatest % increase", "Greatest % decrease" and "Greatest total volume" for each year
There is also a total summary statistics using arrays [Sub GOAT()]
- Creates the greatest of all worksheets and outputs on the first worksheet
Clear All resets all the code from Column 5 onwards