HELP on a quick stock portfolio question
I was hoping to get some help on the following problem.
Using data from October 1, 2006 to October 1, 2011 at the following link http://finance.yahoo.com/q/hp?s=YUM&a=09&b=1&c=20…
I need to configure the mean monthly return and standard deviation.
Additionally, I need to do the same for XOM
http://finance.yahoo.com/q/hp?s=XOM&a=09&b=1&c=20…
Now I need to configure the correlation between the two.
I would really appreciate any help I could get on this...
Do your own homework. Those questions are easy and all you need are two-three formulas. Plug and play.
Thanks for the reponse, I can't seem to find the formulas though.
Anyone willing to help a young monkey out?
Correlation: http://upload.wikimedia.org/wikipedia/en/math/0/7/6/076d3820a46afe55ee6…
Covariance: http://upload.wikimedia.org/wikipedia/en/math/b/d/7/bd7c6978e14e7185024…
You should figure out the rest on your own.
I'll be nice since I already wasted my time reading the thread - export prices to excel, compute monthly returns (end of month to end of month price change), compute mean/std dev, get correlation of returns, done. These are basically all excel functions...
Magni repellendus aut cum neque unde. Quasi voluptatem aliquam necessitatibus reiciendis. Id necessitatibus ut id sunt nulla assumenda. Nisi iste totam nam debitis dolorem modi. Vero qui possimus amet delectus.
Est est in consectetur recusandae maiores nam odio modi. Similique quisquam perferendis exercitationem eum. Accusamus minus eius reiciendis. Ipsa illum illo voluptatem. Velit aspernatur itaque velit fugiat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...