Stock Market Analysis Using VB Macro in Excel. Summarizes one year of stock data from 2015, though the code can run on any year. The macro loops through the data extraxcting the ticker symbol, and ...