Kickstarting with Excel

Overview of Project

Purpose

The purpose of this project was to evaluate green stock options using the criteria of Total Daily Volume and rate of Return. This project uses VBA and Excel to process data from 2017 and 2018 to arrive at these criteria.

Results

The images below illustrate the volatility of the stock market. In 2017, 11 out of the 12 stocks analysed had a profitable rate of return. However, 2018 is essentially an inversion; only 2 out of the same 12 stocks had a profitable year. Even given the significant gains many of these stocks earned in 2017, the substantial dive they take in 2018 should give the investor pause. ENPH and RUN appear to be the most reliable, but taking a look at a larger set of data would be advised.

Summary

Advantages and disadvantages to refactoring code

The advantages of refactoring code include creating more streamlined code that performs more quickly and efficiently. The drawbacks may include adding an additional step before a final product is reached and the possiblity of introducing new errors in the process of revision.

Advantages and disadvantages of the original and refactored code for this project

The primary advantage in refactoring this code was the enhanced performance. In the original code, the 2017 and 2018 macros ran in .584 seconds and .757 respectively. In the refactored code, the macros were executed in .078 seconds for 2017 and .113 for 2018. The disadvantages are, again, additional time investment and the possiblity of introducing new errors.