Excel Forum

Excel Magic Trick 747: Expected Returns and Standard Deviation Single Cell Array Formula

Download file: http://people.highline.edu/mgirvin/
See how to create a single cell formula that can do complex calculations to calculate Expected Return & Standard Deviation on a portfolio of stocks. This formula is great because it avoids large sets of calculations in many cells.

Got a Question? Ask it Here in the Forum.