tsimamora
07-16-2015, 09:14 PM
Hi everyone,
I am a newbie in VBA and in this forum and I am in need of your help. :) I am trying to write a code for calculating portfolio volatility using co-variance matrix:
13937
The Port_Vol function that I created does not work when I included "Square Root (^0.5)". But if I didn't include Square Root, the function works just fine.
I need to include the Square Root in order to calculate the real value of volatility. Can you help me with this?
Thank you very much beforehand!
I am a newbie in VBA and in this forum and I am in need of your help. :) I am trying to write a code for calculating portfolio volatility using co-variance matrix:
13937
The Port_Vol function that I created does not work when I included "Square Root (^0.5)". But if I didn't include Square Root, the function works just fine.
I need to include the Square Root in order to calculate the real value of volatility. Can you help me with this?
Thank you very much beforehand!