Registered User Joined: 3/31/2005 Posts: 17
|
Hello,
Can a PCF be created that averages the three highest closes in the last 20 days?
I would like to look at charts where today’s close is greater than the average of the 3 highest closes over the previous 20 days. As an example, on 4/6/10 AIG closed at 35.91 and the average of the highest 3 closes from the previous 20 days was 35.47 (36.24 on 3/10/10; 35.11 on 3/11/10 and 35.06 on 4/5/10).
Thanks in advance for any help.
Eric
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A technique for finding these values is described in the PCF for Order Statistics topic, but the formulas will be rather long if written for 20-Periods:
PCF for Order Statistics
-Bruce Personal Criteria Formulas TC2000 Support Articles
|