| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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.
|
|
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
|
|
Registered User
Joined: 8/16/2006
Posts: 37
|
Thats exactly what I needed.....you guys are the best, thanks Bruce!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |