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 |

Timed Alert Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
0002ct
Posted : Thursday, November 1, 2018 10:04:14 AM
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?


 

Bruce_L
Posted : Thursday, November 1, 2018 10:22:18 AM


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
0002ct
Posted : Thursday, November 1, 2018 3:47:58 PM
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.

0002ct
Posted : Monday, November 5, 2018 8:41:55 AM
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.

 

 

Bruce_L
Posted : Monday, November 5, 2018 9:45:50 AM


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
0002ct
Posted : Monday, November 5, 2018 2:07:49 PM
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.

 

Bruce_L
Posted : Monday, November 5, 2018 2:14:22 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.