peterm
02-24-2009, 05:27 PM
Hi all, this is my first post. I appreciate any help in advance.
In the attached spreadsheet there is a data set that is highlighted in yellow. This is a covariance formula (correlation * standard dev asset1 * standard dev asset 2). I am trying to automate this in VBA so when i click the button at the top, the covariance matrix is filled in using that formula automatically.
I was trying to write something using offsets, but kept getting data type mismatch errors.
I am hoping someone might be able to point me in the right direction as to how I might go about doing this!
Many thanks!!!!
Pete
In the attached spreadsheet there is a data set that is highlighted in yellow. This is a covariance formula (correlation * standard dev asset1 * standard dev asset 2). I am trying to automate this in VBA so when i click the button at the top, the covariance matrix is filled in using that formula automatically.
I was trying to write something using offsets, but kept getting data type mismatch errors.
I am hoping someone might be able to point me in the right direction as to how I might go about doing this!
Many thanks!!!!
Pete