Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/19/2015 Posts: 459
|
Hello.
Is there a way trigger an alert after a certain number of bars after open, and where the alert contains a value?
I want an alert 25 minutes after the open and where the alert contains a the VWAP value.
Is something like this possible?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can write an indicator formula (with significant limitations) which will return the numeric value of the calculations for a VWAP only at exactly 25 bars after the open (this is for v18).
IIF(SinceTrue(O1 = O'11/01/18' AND H1 = H'11/01/18' AND L1 = L'11/01/18' AND C1 = C'11/01/18' AND V1 = V'11/01/18', 25) = 24, AVG((O + H + L + C) * V, 25) / 4 / AVGV25, 1 / 0)
But I am not quite sure of a practical way to use this as an alert which would return the VWAP. Maybe create this as a Custom PCF Indicator and then create an alert for when it is greater than zero?
It also has significant limitations as mentioned earlier. The date would need to be edited each day. It only works for symbols where the open, high, low, close, and volume of the last intraday bar of the previous trading day are distinct enough that other bars will not also trigger the condition in the SinceTrue() function.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Bruce, thank you for taking a look and for offering some ideas. I appreciate it, as always.
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Bruce, could I please be helped with a formula that looks for "current close is less than or equal to 1.25% of [the mvwap value below]?
AVG((O + H + L + C) * V, 90) / 4 / AVGV90
Thank you very much.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I doubt you actually want what you requested.
C <= .0125 * AVG((O + H + L + C) * V, 90) / 4 / AVGV90
I suspect you actually want within 1.25% of Moving VWAP.
ABS(C / (AVG((O + H + L + C) * V, 90) / 4 / AVGV90) - 1) <= .0125
Or possibly at or below but within 1.25% of Moving VWAP.
.9875 * AVG((O + H + L + C) * V, 90) / 4 / AVGV90 < C AND C <= AVG((O + H + L + C) * V, 90) / 4 / AVGV90
Or possibly at least 1.25% below Moving VWAP.
C <= .9875 * AVG((O + H + L + C) * V, 90) / 4 / AVGV90
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 11/19/2015 Posts: 459
|
Yes, you are exactly correct. I phrased the request badly.
Thanks, Bruce. As always, way above+beyond.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |