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

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.