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

whats wrong with this pcf: Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
almtreeservices
Posted : Wednesday, March 15, 2017 3:41:55 PM
Registered User
Joined: 12/30/2012
Posts: 39

 

C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10 and C > (XAVGC9 * .98) AND C < (XAVGC9 * 1.02) and V > 400000 and ATR15>.40 and C => 8.00  and  XAVGC17 > XAVGC43. I'm looking for volume greater than 400,000 but this brings up stocks that don't trade near that much (rbcn)?

How would I change it to get stocks trading an average of 400,000 in tha last 60 days? Thank you.


 

 

 

Bruce_L
Posted : Wednesday, March 15, 2017 3:53:46 PM


Worden Trainer

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

This doesn't return true for RBCN currently.

If you have modified the Condition Formula and it is being used in your layout as a WatchList Column or EasyScan Condition for example, you will need to remove and re-add the Condition Formula to the layout.

This is because when you add the Condition Formula, it adds a copy which is not linked to the original in any way. Changing the original will not change the copy, which is why you need to remove the copy and re-add the Condition Formula if you want any changes reflected in your layout.

That said, your formula currently checks for the volume of the current bar being greater than 400000 shares.

V > 400000

You would want to change this to the following to check for the average volume over the most recent 60 bars being at least 400000 shares

AVGV60 >= 400000

This would result in the following overall Condition Formula (v17+ only).

C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10) AND ABS(C / XAVGC9 - 1) < .02 AND AVGV60 >= 400000 AND ATR15 > .4 AND C >= 8 AND XAVGC17 > XAVGC43



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
almtreeservices
Posted : Wednesday, March 15, 2017 3:59:29 PM
Registered User
Joined: 12/30/2012
Posts: 39

 

So, if I understand correctly, I have to remove the condition from the column in my watchlist, then make the changes, then add it back to the watchlist?

Bruce_L
Posted : Wednesday, March 15, 2017 4:06:52 PM


Worden Trainer

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

You seem to understand.

You could change the Condition Formula before or after removing the column from your WatchList, but you have to change the Condition Formula before adding the WatchList Column back to your WatchList.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
almtreeservices
Posted : Wednesday, March 15, 2017 4:08:22 PM
Registered User
Joined: 12/30/2012
Posts: 39

 

Thanks Bruce - that's very helpful.

Bruce_L
Posted : Wednesday, March 15, 2017 4:22:24 PM


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.