Friday, February 24, 2017

Week 3 Investment

Microsoft Excel File


Hello everyone, this week I have run through some other stock evaluation, for example sharpe ratio, treynor ratio and information ratio to re-balancing my portfolio.

Basically, both two stock GOOG US and GOOGL US show higher value in three different measurement, therefore, more shares have been purchased in order to provide the maximum outcome. Even though some of the stock show positive value on one of the ratio but it might be lack of further research if we just buy it with only one positive outcome showed.

Besides, both NOV US and LCI US show negative result on three different ratio, therefore, it is signalling clear indication to sell these stocks and action had been take.

The detailed excel workout formulas have been uploaded on the link on the second sheet of the excel file.

Thank you very much.

No comments:

Post a Comment