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 |

Error in formula Argument missing near * Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Tarantel1
Posted : Thursday, October 5, 2017 1:03:32 PM
Gold Customer Gold Customer

Joined: 10/2/2017
Posts: 10

hi

mac, TC2000 12

my question

this is the code from http://freetraderchat.com/blog/top-5-tc2000-scans/

C > 10 AND AVGV5 > 2000 AND C > XAVGC50 AND C > O AND (L < XAVGC50 OR L1 < XAVGC50.1) AND C > XAVGC50 AND C >= .8 * MAXH252 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 there is alway a message: Error in formula  Argument missing near *

 

thanks for helping 

Bruce_L
Posted : Thursday, October 5, 2017 1:10:00 PM


Worden Trainer

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

I am going to guess that your computer is set to use the , as the decimal marker instead of using the . as the decimal marker which would be more common in the United States as the formula seems to work correctly for me.

Please try the following Condition Formula which multiples C >= .8 * MAXH252 by 10 to create 10 * C >= 8 * MAXH252 instead to eliminate the decimal marker.

C > 10 AND AVGV5 > 2000 AND C > XAVGC50 AND C > O AND (L < XAVGC50 OR L1 < XAVGC50.1) AND C > XAVGC50 AND 10 * C >= 8 * MAXH252 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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tarantel1
Posted : Thursday, October 5, 2017 2:20:16 PM
Gold Customer Gold Customer

Joined: 10/2/2017
Posts: 10

thanks for answering

but

that should show 

SCAN FOR STOCKS CONSOLIDATING IN TC2000

but thats not true

?

Bruce_L
Posted : Thursday, October 5, 2017 2:31:09 PM


Worden Trainer

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

Why would you think it is a formula for a scan for stocks consolidating in TC2000?

The formula is called Momo on the page to which you linked in your original post. I am pretty sure Momo is short for momentum, which does not imply consolidation.

"This is a good scan for discovering stocks that have momentum. This scan is designed to look for stocks that have a lot of ups and downs in the price action."

What it is actually checking for is something called a "Pocket Pivot". That is this part of the formula.

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

It then requires that price is above the 50 period exponential moving average with the low of the current or previous bar being below the 50 period exponential moving average. So price is crossing up through the 50 period exponential moving average. That is this part of the formula.

(L < XAVGC50 OR L1 < XAVGC50.1) AND C > XAVGC50

The fomula also requires price to be at least 10, average volume over the most recent 5 bars to be at least 2000 shares, the current price to be above the open and price to be at least 80% of its one year high.

C > 10 AND AVGV5 > 2000 AND C > O AND 10 * C >= 8 * MAXH252

None of these requirements would seem to be related to consolidation at all. If you have a specific unambiguous objective definition of consolidation in mind, we could try to help you implement your particular definition in TC2000.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Tarantel1
Posted : Friday, October 6, 2017 11:12:11 AM
Gold Customer Gold Customer

Joined: 10/2/2017
Posts: 10

thank you, I'm a beginner 

Bruce_L
Posted : Friday, October 6, 2017 11:23:13 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.