| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/10/2013
Posts: 91
|
Is there a way to have a watchlist column that displays the high of a candle when an indicator passes a specific criteria. Example:
Volume spikes 2 times its moving average 3 bars ago. Would there be a way to see the price high of that candle in a watchlist column.
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Yes, you could use the following formula but it will only show the High if the Volume spike happened exactly 2 bars ago.
IIF(V3 > AVGV50.3 *2, H3, 0)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Yes, you can do this. Let's say you are comparing the current volume to the 21 period simple moving average of volume from 3 bars ago.
IIF(V > 0 AND V >= 2 * AVGV21.3, H, 1 / 0)
Or volume 3 bars ago was at least twice its 30 period simple moving average from 3 bars ago.
IIF(V3 > 0 AND V3 >= 2 * AVGV30.3, H3, 1 / 0)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/10/2013
Posts: 91
|
great thanks alot!!!! I have another formula that I will be playing with as far as this is concerned so I will use this for the foundation.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |