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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » weekly scan

weekly scan Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
msrio
Posted : Friday, January 15, 2010 2:29:39 PM
Registered User
Joined: 1/30/2005
Posts: 7
 When I scan weekly charts, I am looking for stocks over 15.00 per share that have closed above the 34 period moving average.  Will you tell me how to do this? Thank you
Back to top
Bruce_L
Posted : Friday, January 15, 2010 2:45:30 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 Please try using one of the following Personal Criteria Formulas as an EasyScan Condition:

Price above $15 and 34-Period SMA (Weekly):

C > 15 AND 33 * C > C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145 + C150 + C155 + C160 + C165

Price above $15 and 34-Period EMA (Weekly):

C > 15 AND C > .0571980645061175 * (C + 33 / 35 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Cascades of Moving Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
msrio
Posted : Friday, January 15, 2010 3:14:21 PM
Registered User
Joined: 1/30/2005
Posts: 7
QUOTE (msrio)
When I scan weekly charts, I am looking for stocks over 15.00 per share that have closed above the 34 period moving average.  Will you tell me how to do this? Thank you


Okay, thank you.  maybe I want to mostly see those stocks that have recently closed above the 34 moving average.. say four or five days.  How would I do that? 
Back to top
msrio
Posted : Friday, January 15, 2010 3:25:10 PM
Registered User
Joined: 1/30/2005
Posts: 7
 Can I find stocks that have most recently closed about the 34 period moving average maybe for the last 4 or 5 days.
Back to top
Bruce_L
Posted : Friday, January 15, 2010 3:45:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 I'm not quite sure I understand the last two questions, but you can add 5 Days to all of the Bars Ago parameters in the formulas to offset the results by one Weekly Bar to find items that have crossed up through the Moving Average instead of just finding symbols that are currently above the Moving Average.

Price above $15 and xUp 34-Period SMA (Weekly):

C > 15 AND 33 * C > C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145 + C150 + C155 + C160 + C165 AND 33 * C5 <= C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145 + C150 + C155 + C160 + C165 + C170

Price above $15 and xUp 34-Period EMA (Weekly):

C > 15 AND C > .0571980645061175 * (C + 33 / 35 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND C5 <= .0571980645061175 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585 + 33 / 35 * (C590))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.