|
Featured Tutorial
Featured Macro
Excel Finance Class 105: Expected Return & Standard Deviation For Portfolio -- Estimating Future
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to calculate Expected Returns and Standard Deviation for a portfolio of stocks. See how to do it long hand and in a single cell formula. See the functions SUMPRODUCT and SQRT.
See how to calculate Expected Returns and Standard Deviation for a portfolio of stocks. See how to do it long hand and in a single cell formula. See the functions SUMPRODUCT and SQRT.