2-Excel VBA
Data across all years (tabs) are looped through and each Ticker (stock) with its yearly change, total stock volumne are displayed in the first tab using VBA. Positive yearly change tickers are highlighted in green (denoting good trend) and negative yearly change tickers are highlighted in red background (denoting bad trend).
Also, Ticker (stock) with greatest % increase, decrease and greatest total volume is also calculated and displayed in the first tab using VBA.
ResultScreenShot.png is the results screenshot. And Script.txt is the vba used to produce the results.