Sean;
Thanks for your suggestions. I also could see no way to use the canned, stdev(data array,prds), function. I achieved what I needed with the following formula. This gives me the standard deviation of 5 different MA's at the same point in time.
1stprd:=Input("Enter 1st prd",3,15,5);
2ndprd:=Input("Enter 2nd prd",6,30,13);
3rdprd:=Input("Enter 3rd prd",13,60,22);
4thprd:=Input("Enter 4th prd",22,120,50);
5thprd:=Input("Enter 5th prd",50,240,100);
MAavg:=((Mov(C,1stprd,E)+Mov(C,2ndprd,E)+Mov(C,3rdprd,E)
+Mov(C,4thprd,E)+Mov(C,5thprd,E))/5);
Sqrt((Power(Mov(C,1stprd,E)-MAavg,2)+Power(Mov(C,2ndprd,E)-MAavg,2)
+Power(Mov(C,3rdprd,E)-MAavg,2)+Power(Mov(C,4thprd,E)-MAavg,2)
+Power(Mov(C,5thprd,E)-MAavg,2))/5)
Thanks again,
John
(Red print not significant. Don't know how to remove.) |
