Excel Array Formula Series 14.3 Portfolio Standard Deviation
See how to create array formulas for Portfolio Return & Standard Deviation. See the array functions: MMULT, COLUMN, TRANSPOSE. See how to do this given different assumed states of the future economy. See how to use probability, stock weights and assumed stock returns to calculate 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 …
If you're new to FYInance, we're going to make it worth your while to subscribe to our FYInance RSS feed. It will keep you up to date, on your terms!