Search results for query: *

Thanks super much Bob and Geoff! Now my formula works like a charm. I'll have use for the CONCATENATE function in another thing I'm working on... Best Regards Cashmire

Thank you very much Bob! I'll try your suggestion! Cashmire

Hi! A part of my formula is as follows: (MMULT(MMULT(TRANSPOSE($C$25:$C$29); VarCovar(INDIRECT("returns!b4:f" & H30)));$C$25:$C$29))*100)) The problem comes in this part: VarCovar(INDIRECT("returns!b4:f" & H30)) where VarCovar is a VBA function that creates a variance-covariance matrix...

Thank you very much! It worked like a charm:) -Cashmire

Hello! I have one sheet with "raw" stock price data and one sheet with the returns calculated from the raw price data. I have managed to create a userform that inserts a new row to both of the sheets and pastes the new prices that the user inserts in the userform, however I have not succeeded in...

Hello! Could someone pleasehelp me.. I would like to create a userform that pastes a value (that the user types into the textbox in the userform) in a specified cell in a specified sheet. Is that possible? Thank you, Cashmire

Solved it... the problem was just a cell format problem... Thanks anyway

Hello! I have this code for calculating the variance-covariance matrix for a portfolio consisting of 3 stocks. Somehow I can't seem to get it to work. Could someone please help me? Thank you:) Function VarCovar(rng As Range) As Variant Dim i As Integer Dim j As Integer Dim numCols...