hi everyone trying to get the portfolio variance using this formula
B9:E9 is the stocks individual weight & B4:E7 is a variance-covariance matrix
its an array formula so im using cse but keep getting value error
does anyone know what im missing?
Do you want a 4x4 array as the result? If so, move the TRANSPOSE.
Do you want a single value as the result? If so, move the TRANSPOSE to the second parameter:
When you multiply an array with a rows and b columns by one with c rows and d columns, b must equal c and the answer will be a rows by d columns.
thank you very much, great advice@Brad Yundt