penny stocks and blue chip stocks excel

Upload: nadine-santiago

Post on 10-Jan-2016

38 views

Category:

Documents


2 download

DESCRIPTION

Penny Stocks and Blue Chip Stocks Excel

TRANSCRIPT

Table 1. Penny Stocks 2013 Weekly and Annual Mean Price Return

Table 2 Blue Chip Stocks 2013 Weekly and Annual Mean Price Return

Figure 1. Penny Stocks Weekly Mean Price Return

Figure 2. Blue Chip Stocks Weekly Mean Price Return

ra= Stock return

ri= index return

Basically, I computed the daily return or daily change of the stock price and PSE index.

Then, I computed for the covariance orthe relation on how the move together and divided the figure with the variance of PSEI.