Pilot: PSEI Stock Dashboard

Hello! Thanks for visiting my blog. I've been trying to setup a blog where I can follow the footsteps of data visualization gurus and jedis by making information more accessible and easy to understand. It has been a stagnant idea for a while, but I've finally gotten around to making something publish-worthy (I hope).

I have been collecting Philippine stock price data for certain stocks since mid-2014. I just take the current price (based on Bloomberg) every week for these stocks. It might sound like a lot of work, but I just take 3 minutes every weekend to do it. Not bad.

From the data I've collected, I created a simple dashboard hosted on Tableau Public. Feel free to use it to look at stocks that might interest you.

Enjoy!

P.S. Sorry about the awkward dashboard positioning and shoddy blog design. I'll fix this next time!

---

 
HOW TO INTERPRET THIS DASHBOARD

Watchlist Summary

This contains the list of stocks that I follow. You will immediately see their current price (as of the latest update), their price during the week prior to the latest update, and the % change of the stock.

Green -> the stock went up
Red -> the stock went down

Correlation Matrix

For the non-stats people: Broadly speaking, correlation is a measure (between -1 and 1) of the relationship of two sets of data. In this case, correlation measures whether Stock A moves with (positive correlation), opposite (negative correlation), or with no relation to (zero/no correlation) Stock B.

You can hover over the cells in the matrix to see the actual correlation values. The darker the color, the stronger the relationship.

Correlation can be useful when determining which stocks to invest in. You generally want to invest in stocks that are not strongly correlated to each other. For correlated stocks, when one goes up, the other is likely to go up as well. Great! But if one crashes, the other might crash with it. In short, don't put all your eggs in one basket and diversify your investments.

Time Series (Line Chart) and Other Measures

Aside from seeing how the stock moves over time, it is also to good look at the standard deviation (St. Dev) and coefficient of variance (CV). Both St. Dev and CV measure the stock price variation or how erratic the prices can be. Stocks with high variation are usually considered high risk options.

The CV is just a scaled measure of St. Dev. It is generally better to use the CV when comparing the "riskiness" of two stocks.