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 :)

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

That works perfect, and it's faster and more flexibl than having to key in a complex formula! 12.4 rocks!!!

Bruce I need the following Moving VWAP formulas

13 Period

26 period

52 period

78 period

Thanks

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

Thanks Patftest

AND Bruce I got this figured out - Save your time for someone else

Thanks. I appreciate the heads up if you already have it working.