Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Scan Formula based on Multiple of Average Volume, within last 5 days? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Chris_Moody
Posted : Wednesday, March 5, 2014 3:09:28 AM
Registered User
Joined: 8/23/2013
Posts: 9

Can someone PLEASE help me out with writing this formula for a Scan?

 

Volume is Greater than 3 times the 50 Day EMA within the last 5 trading days

 

Thanks for your help....

Chris_Moody
Posted : Wednesday, March 5, 2014 3:35:38 AM
Registered User
Joined: 8/23/2013
Posts: 9

This formula is returning the correct volume of current day and each of the past 5 days but it is comparing it to todays -- 3 times the the 50 Day EMA (Value) --

 

How can I get the volume of each day to compare to the -- 3 times the the 50 Day EMA (Value) -- for each of the past 5 days?

 

Thanks,,,,

Chris_Moody
Posted : Wednesday, March 5, 2014 3:37:27 AM
Registered User
Joined: 8/23/2013
Posts: 9

Here is the formula I was referring to in the post above....

 

V>(3*XAVGV50) OR V1>(3*XAVGV50) OR V2>(3*XAVGV50) OR V3>(3*XAVGV50) OR V4>(3*XAVGV50) OR V5>(3*XAVGV50)

Bruce_L
Posted : Wednesday, March 5, 2014 10:08:11 AM


Worden Trainer

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

If you want volume to be greater than three times the 50-period exponential moving average of volume at the time at least once during the the most recent five bars:

V > 3 * XAVGV50 OR V1 > 3 * XAVGV50.1 OR V2 > 3 * XAVGV50.2 OR V3 > 3 * XAVGV50.3 OR V4 > 3 * XAVGV50.4

If you want volume to be greater than three times the 50-period exponential moving average of volume at the time during all of the most recent five bars:

V > 3 * XAVGV50 AND V1 > 3 * XAVGV50.1 AND V2 > 3 * XAVGV50.2 AND V3 > 3 * XAVGV50.3 AND V4 > 3 * XAVGV50.4

If you want volume during the most recent five bars to be higher than three times the current 50-period exponential moving average of volume at least once (what you wrote above would work fine for this as well):

MAXV5 > 3 * XAVGV50

If you want volume during the most recent five bars to be higher than three times the current 50-period exponential moving average for all five bars:

MINV5 > 3 * XAVGV50

If you want something else, then we would need further clarification from you as to your actual intent.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Chris_Moody
Posted : Thursday, March 6, 2014 5:41:46 PM
Registered User
Joined: 8/23/2013
Posts: 9

Thanks Bruce...Perfect

Bruce_L
Posted : Friday, March 7, 2014 10:44:54 AM


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.