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...
At repellendus tenetur voluptatem quia debitis qui veritatis. Illo qui nulla adipisci. Et voluptas neque aut odio magnam ipsa est soluta. Totam rerum voluptas illo ut aut asperiores aliquid. Non eius quasi mollitia. Dolorem vel praesentium voluptatibus est officiis et. Assumenda reprehenderit quod sed nobis dolor facere est.
Nobis dolores est quo repellendus. Aliquam est maiores ullam animi repellendus quo suscipit repellat. Voluptatum occaecati amet possimus asperiores dolor sit.
Tenetur vel labore placeat architecto minus molestias dolores. Aspernatur ut nulla non non omnis suscipit. Molestias blanditiis aut autem ut qui architecto. Aut culpa quia est quas incidunt. Tempora dolores exercitationem corporis suscipit.
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...