Registered User Joined: 9/20/2005 Posts: 18
|
Hello Bruce:
Can we write PCF to calculate the difference between today price and the lowest price in past 5 years, place the scan as a column on a watchlist and sort it by the difference. So if values is positive it would indicate that the current price is above the lowest low of last 5 years and vice versa
Thanks
Deepak
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You could use something like the following in TC2000 version 7 for a net difference:
C - MINL1260
Or the following for a % difference:
100 * (C / MINL1260 - 1)
But you could do this in TC2000 version 12.4 because there is only 500 bars of data available in any given time frame. So you would need to use something besides a daily time frame.
So you could use something like the following in TC2000 version 12.4 in a weekly time frame for the net:
C - MINL260
Or the following for the percent:
100 * (C / MINL260 - 1)
Note that none of these formulas would actually calculate at all for any symbols with less than five years of data.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|