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 & PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
rli
Posted : Sunday, November 23, 2014 12:16:38 PM
Registered User
Joined: 9/13/2014
Posts: 11

Hi Bruce,

 

I'd like to write following PCF which meets following criteria:

*) 5 min. bar

*) VWAP = EMA9 = EMA20

http://www.weinotic.com/TC2000/VWAP.htm

 

I know there's the function of "Create Scan Condition" - with VWAP, but than I'm only able to choose above/below/crossing down/crossing up EMA9 or EMA20, but I'd like to have a PCF which have the same values - see above link.

thanks for your help

Rainer

Bruce_L
Posted : Monday, November 24, 2014 1:44:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

There really is'n't a way to calculate the VWAP in the Personal Criteria Formula Language (although you can calculate the Moving VWAP) as there isn't a way to determine the start of the trading day in an intrday PCF.

In addition, all three values are almost certainly not going to be exactly equal to each other (just because of the way they are calculated). Probably about the best you could do is to create a condition for the EMA9 and EMA20 to be within a certain percentage of each other.

ABS(XAVGC9 / XAVGC20 - 1) <= .001

And then create a condition for one of the moving averages to be crossing up through the VWAP by clicking on the VWAP and selecting Create Scan Condition to be used in the same EasyScan as the Condition Formula.

Create Conditions from Your Chart (5:25)

You can't actually OR this type of condition in an EasyScan however, so you would probably need to create four EasyScans. One EasyScan would check for VWAP xUp EMA9, another would check for VWAP xDn EMA9, another would check for VWAP xUp EMA20 and yet another would check for VWAP xDn EMA20.

Building a Scan with Multiple Conditions (7:29)



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