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 |

VWAP Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
AlphaMan01
Posted : Thursday, March 13, 2014 11:54:50 AM
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 :)

 

 

 

Bruce_L
Posted : Thursday, March 13, 2014 12:01:52 PM


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
AlphaMan01
Posted : Thursday, March 13, 2014 12:19:56 PM
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!!!

Aces4Me
Posted : Wednesday, April 13, 2016 9:26:12 AM
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

patftest
Posted : Wednesday, April 13, 2016 4:37:52 PM
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

 

Aces4Me
Posted : Thursday, April 14, 2016 8:54:10 AM
Registered User
Joined: 4/30/2015
Posts: 197

Thanks Patftest

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

Bruce_L
Posted : Tuesday, April 19, 2016 1:37:47 PM


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
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.