Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/27/2013 Posts: 4
|
Greetings!
I know the VWAP can be charted. I also know the Price xUp VWAP 5min condition exists, but what I'd like to do is drop a column in a watchlist that shows which stocks are above the VWAP line. For that, I need a custom formula. Can you please help with that?
Thanks!
Ron :)
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There is no way to create a formula based on the VWAP indicator as the Personal Criteria Formula Language does not have syntax for referencing the time of day in an intraday PCF. It is possible to create formulas for the Moving VWAP, but I'm guessing you would have specified the moving part if that was what was actually of interest.
You can create a condition for price being above the VWAP in TC2000 version 12.4 in the same way you can create a condition for price crossing up through the VWAP. Selecting Add to an Existing WatchList or Scan after setting up the condition will allow you to use the condition as a WatchList Column.
Create Conditions from Your Chart
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/27/2013 Posts: 4
|
That works perfect, and it's faster and more flexibl than having to key in a complex formula! 12.4 rocks!!!
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
Bruce I need the following Moving VWAP formulas
13 Period
26 period
52 period
78 period
Thanks
|
|
Registered User Joined: 5/8/2015 Posts: 6
|
Bruce can answer when he gets back but I think the formulas are going to be lengthy.
You can get a pretty close approximation using the following:
(AVGC13 * AVGV13)/AVGV13
(AVGC26 * AVGV26)/AVGV26
(AVGC52 * AVGV52)/AVGV52
(AVGC78 * AVGV78)/AVGV78
|
|
Registered User Joined: 4/30/2015 Posts: 197
|
Thanks Patftest
AND Bruce I got this figured out - Save your time for someone else
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Thanks. I appreciate the heads up if you already have it working.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |