Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Pivot range sort Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Whammer1249
Posted : Thursday, October 23, 2008 1:44:37 PM
Registered User
Joined: 8/16/2006
Posts: 37
Can you help me with this? I just shared a chart called Pivot Range. I want to be able to sort a watchlist based on the "tightness" of the range. A percentage of the pivot range, if that makes sense. The pivot high minus the pivot low, divided by the close, so that I can sort by that number.
Bruce_L
Posted : Thursday, October 23, 2008 3:02:54 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
If I'm understanding correctly, you want to divide the absolute value of PR1 minus PR2, divide it by the Close to create a Ratio and then multiply this by a hundred to create a percentage. If so, the following RealCode Indicator should produce the desired result (and it can be Dragged and Dropped to the Watchlist to create a Raw Value Column).

Plot = 100 * System.Math.Abs(2 - (Price.High + Price.Low) / Price.Last) / 3

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Whammer1249
Posted : Thursday, October 23, 2008 3:38:04 PM
Registered User
Joined: 8/16/2006
Posts: 37
Thats exactly what I needed.....you guys are the best, thanks Bruce!
Bruce_L
Posted : Thursday, October 23, 2008 3:43:01 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-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.