week-5

Question 1

IF-THEN-ELSE

Answer 1

Sub Lesson05p03()
For i = 2 To 5
If Cells(i, 2) = “Non Advisory” Then
If Cells(i, 3) = “Online” Then
Rate1 = 0.0028
Else
Rate1 = 0.00375
End If
Else
If Cells(i, 3) = “Online” Then
Rate1 = 0.0033
Else
Rate1 = 0.005
End If
End If
Cells(i, 7) = Cells(i, 4) * Rate1
Next i
End Sub

Question 2

Global Minimum Variance Portfolio

Answer 2

lowest risk portfolio
minimize variance
w(T) Sw - portfolio variance
make subject to 1(T)w = 1