How do I calculate a standard deviation of a portfolio?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 52 weekly returns of 5 different stocks. I weighted the stocks each
with 20 %. Now I want to calculate the standard deviation of this portfolio.
Can somebody help me ?
 
I assume you have a table something like this:

Date Stock1 Stock2 Stock3 Stock4 Stock5 Total
1/1/04 <data>

Say it's in A1:G53. To get statistics on the total, use formulas like these in cells
outside of the table:

=AVERAGE(G2:G53)
=STDEV(G2:G53)

Look up Function in Excel Help, and you'll see this page:

Worksheet functions listed by category

Database
Date and Time
External
Engineering
Financial
Information
Logical
Lookup and Reference
Math and Trigonometry
Statistical
Text and Data


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top