RCI i mistake it. where is? please teach me
RCI code is
Function RCI(price As Range) As Single
Dim n As Long, i As Long
Dim x As Single
n = price.Count
x = 0
For i = 1 To n
x = x + (Application.Rank(price(i), price) - i) ^ 2
Next i
RCI = 600 * x / (n ^ 3 - n) - 100
End Function
can't run...