Skip to content

VBA coding problem to craft analytics and data exploration of stock data intially provided in Excel.

Notifications You must be signed in to change notification settings

soderquista/vba-challenge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

vba-challenge

VBA coding problem to craft analytics and data exploration of generated stock data. See "module2solved.bas" for VBA script.

methods

In this challenge, iterated through stock data to track statistics across each ticker symbol and also reported on best and worst performers for each year, including Greatest % Increase, Greatest % Decrease, and Total Volume of the stock. Runs dynamically and can run on multiple sheets at once for improved functionality.

results

Compare output of first year (2018solved.png) to rubric accordingly: ExpectedResults

About

VBA coding problem to craft analytics and data exploration of stock data intially provided in Excel.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages