The-VBA-of-Wall-Street

--Stock scripting in VBA--

Background

This VBA script has been created to succinctly summarize the data for each unique stock. This then allows for analysis of the dataset provided to determine which stocks performed well over the year, while also outlining which stocks did not perform as well.

Methods

The VBA script has been created to loop through all stocks for one year and output the following information:

1. Ticker symbol.
2. Yearly change with conditional formatting.
3. Percentage change with conditional formatting.
4. Total stock volume of the stock.

Functionality to the VBA script to return the following data:

1. Greatest percent increase.
2. Greatest percent decrease.
3. Greatest total volume.

The VBA script was then enabled to run on every worksheet at once.

VBA Script File

The VBA script file can be read under the ‘VBA Stock Code’.

References

• Dataset provided by edX UofT Data Analytics, which had been generated by Trilogy Education Services, LLC.

---