Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Price proximity near a 5 year range Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
deepshub
Posted : Wednesday, October 15, 2014 1:00:36 PM
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

Bruce_L
Posted : Wednesday, October 15, 2014 1:16:53 PM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.