n=1 时y=sin(1)*x1
n=2 y=sin(1/2)*x1+sin(2/2)*x2
n=3 y=sin(1/3)*x1+sin(2/3)*x2+sin(3/3)*x3;
n=4 y=sin(1/4)*x1+sin(2/4)*x2+sin(3/4)*x3+sin(4/4)*x4;
.
.
.
n=n y=sin(1/n)*x1+sin(2/n)*x2+.....sin(n/n)*xn; x1-xn用收盘价
这个用金字塔语言很难写出来，这个不是循环就行的，所以帮你转到了高级区看看会不会用VBA写