Stock-Analysis

Deliverable 1

* tickerIndex is set to zero before looping*

* Arrays are created*

Loops through all rows

unsure about if statements For the if statements, I referenced the original script if statements as provided in Module 2 in regard to If/Then

Deliverable 2

Purpose

The purpose of this project is to use a method called refactoring to help analyze bigger datasets, and perhaps having the code run more quickly.

I used Sub AllStocksAnalysis() done in the Module as a template to complete this challenge.

With the Module Work, I was able to output the Values for Ticker, daily Volume and Return for the year 2018. I was able to execute 'AllStocksAnalysis' more than once:

Results

When I initially ran the Refactored Analysis, I had run into a challenge. The only thing calculated was the run time. the execution time for the Refactored Analysis only ran once and showed the below output: Additional, the output included a blank table with wrong conditional formatting:

2018 with original

Initally the run time for the original script was approximately 33 seconds

The run time for the refactored script was approximately 1.25 seconds which is significantly less than the original output

Summary

I would say that a big advantage to refactoring code would be the specifcally the run time. When running my code specifically, I saw that the execution time original script in comparison to the refactored script was largely significant. It went from 33 seconds to 1.25 seconds. When I analyzing big data especially real world data, I think that a smaller run time would be easier to work with overall. Additionally with conditional formatting, instead of scanning through large data, it is visually at ease to see the distinct differences within the data.