Posts

Showing posts from April, 2012

Apple vs Microsoft Stock Performance

I decided to enter The Tableau Interactive Biz Viz Contest and since I needed to use a financial data set, I chose to compare Apple vs Microsoft Stock Performance. Having been a big Microsoft fan back in the 90's, I thought it'd be interesting to compare Microsoft against the hottest company at the moment, Apple. Both companies have had interesting peaks and valleys. While Microsoft has been on the decline, Apple has been on a tear. It was interesting to look at the historical min, max, average stock price, and average volume of the two stocks. I then calculated the % daily difference to see the changes in close price compared to the prior day. Then I took it a step further by looking at the % difference by year using the adjusted closing (which takes into account any dividends/stock splits). It was neat to see the % difference by month too. Another way to look at the data was to construct a candlestick chart to see the high, low, open, and close each day. And to see the