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...
Ducimus molestiae aut dolores ut. Ut ullam animi qui iure eligendi id. Vero nulla dolor quae minima omnis aut. Suscipit esse molestias perspiciatis velit omnis doloremque non libero. Animi at accusantium provident nobis.
Veniam sit quos aut quod officiis repudiandae. Dolor sunt delectus repellat voluptates quas provident. Eum earum voluptate aut aut. Adipisci laborum sunt temporibus. Provident aut suscipit voluptatum voluptates sed. Et voluptatem autem illo et.
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...