-
In this work, I used to VBA scripting for analyze real stock market data,
-
Created a script that will loop through each year of stock data and grab the total amount of volume each stock had over the year.
-
Created a script that will loop through all the stocks and take the following info.
-
Yearly change from what the stock opened the year at to what the closing price was.
-
The percent change from the what it opened the year at to what it closed.
-
The total Volume of the stock
-
Ticker symbol
-
-
Created conditional formatting that will highlight positive change in green and negative change in red.
-
Created a script to locate the stock with the "Greatest % increase", "Greatest % Decrease" and "Greatest total volume".
-
Notifications
You must be signed in to change notification settings - Fork 0
Using VBA and doing Stock Market Analysis. What is VBA ? VBA is Visual Basic for Applications, a programming language developed by Microsoft and predominantly used with Microsoft Office applications like Word and Excel.
RussCob/VBA-Wall-Street-Analysis
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Using VBA and doing Stock Market Analysis. What is VBA ? VBA is Visual Basic for Applications, a programming language developed by Microsoft and predominantly used with Microsoft Office applications like Word and Excel.
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published