Excel Forum
Similar Content
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Average Cells Excluding Zeros in Excel
Tutorial: Exclude zeros while averaging cells in Excel. This method removes all zeros from the equa...



Excel Array Formula Series 14.4: Stock Portfolio Analysis


See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to calculate individual stock return and standard deviation given different assumed states of the future economy.

See how to use probability, stock weights and assumed stock returns to calculate individual stock return and standard deviation and Portfolio Return & Standard Deviation.

See of to use the MMULT to matrix algebra. See of to use the COLUMN and TRANSPOSE functions to create a vertical array of ones.

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.





Got a Question? Ask it Here in the Forum.