Calculate the Sharpe Ratio with Excel

Calculate the Sharpe Ratio with Excel

瀏覽:1397
日期:2024-07-23
VBA for the Sharpe Ratio A cleaner solution is the following VBA function. Function SharpeRatio(InvestReturn, RiskFree) As Double Dim AverageReturn As Double Dim StandardDev As Double Dim ExcessReturn() As Double Dim nValues As Integer nValues ......看更多