• 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 » 20 Week Exp MA and 40 Week Exp MA

20 Week Exp MA and 40 Week Exp MA Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
vworden
Posted : Friday, March 7, 2008 10:45:59 PM
Registered User
Joined: 5/8/2005
Posts: 36
 Hi,

I'm looking for a PFC to scan for stocks, which have been trending up, but just pulled back to 40 Week Exp MA. and also for 20 Week Exp MA.

Appreciate your help.
Back to top
Bruce_L
Posted : Monday, March 10, 2008 9:46:39 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 Can you provide objective and detailed definitions of what you mean by "trending up" and "pulled back"?

It should probably be noted that if your definition requires multiple uses of the 20-Week or 40-Week Exponential Moving Average, the formula will quickly become impractical. I'll provide just the formulas for the averages to give you an idea why:

20-Period Exponential Moving Average (Weekly):

.0953245136006837 * (C + 19 / 21 * (C5 + 19 / 21 * (C10 + 19 / 21 * (C15 + 19 / 21 * (C20 + 19 / 21 * (C25 + 19 / 21 * (C30 + 19 / 21 * (C35 + 19 / 21 * (C40 + 19 / 21 * (C45 + 19 / 21 * (C50 + 19 / 21 * (C55 + 19 / 21 * (C60 + 19 / 21 * (C65 + 19 / 21 * (C70 + 19 / 21 * (C75 + 19 / 21 * (C80 + 19 / 21 * (C85 + 19 / 21 * (C90 + 19 / 21 * (C95 + 19 / 21 * (C100 + 19 / 21 * (C105 + 19 / 21 * (C110 + 19 / 21 * (C115 + 19 / 21 * (C120 + 19 / 21 * (C125 + 19 / 21 * (C130 + 19 / 21 * (C135 + 19 / 21 * (C140 + 19 / 21 * (C145 + 19 / 21 * (C150 + 19 / 21 * (C155 + 19 / 21 * (C160 + 19 / 21 * (C165 + 19 / 21 * (C170 + 19 / 21 * (C175 + 19 / 21 * (C180 + 19 / 21 * (C185 + 19 / 21 * (C190 + 19 / 21 * (C195 + 19 / 21 * (C200 + 19 / 21 * (C205 + 19 / 21 * (C210 + 19 / 21 * (C215 + 19 / 21 * (C220 + 19 / 21 * (C225 + 19 / 21 * (C230 + 19 / 21 * (C235 + 19 / 21 * (C240 + 19 / 21 * (C245 + 19 / 21 * (C250 + 19 / 21 * (C255 + 19 / 21 * (C260 + 19 / 21 * (C265 + 19 / 21 * (C270 + 19 / 21 * (C275 + 19 / 21 * (C280 + 19 / 21 * (C285 + 19 / 21 * (C290 + 19 / 21 * (C295 + 19 / 21 * (C300 + 19 / 21 * (C305 + 19 / 21 * (C310 + 19 / 21 * (C315 + 19 / 21 * (C320 + 19 / 21 * (C325 + 19 / 21 * (C330 + 19 / 21 * (C335 + 19 / 21 * (C340 + 19 / 21 * (C345))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

40-Period Exponential Moving Average (Weekly):

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

You may wish to review the following:

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Cascades of Moving Averages
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
vworden
Posted : Wednesday, March 12, 2008 6:35:41 PM
Registered User
Joined: 5/8/2005
Posts: 36
 Hi,

Thank You for the PCFs Bruce.
What I am trying to scan is --
1. Today's price is above 20 week exp
2. Above 40 week exp
3. 20 week exp is above 40 week exp
4. Stock pulling back to 40 week exp on less volume

Appreciate your help.
Back to top
Bruce_L
Posted : Thursday, March 13, 2008 8:49:28 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (vworden)
Today's price is above 20 week exp

Please try the following:

C > .0953245136006837 * (C + 19 / 21 * (C5 + 19 / 21 * (C10 + 19 / 21 * (C15 + 19 / 21 * (C20 + 19 / 21 * (C25 + 19 / 21 * (C30 + 19 / 21 * (C35 + 19 / 21 * (C40 + 19 / 21 * (C45 + 19 / 21 * (C50 + 19 / 21 * (C55 + 19 / 21 * (C60 + 19 / 21 * (C65 + 19 / 21 * (C70 + 19 / 21 * (C75 + 19 / 21 * (C80 + 19 / 21 * (C85 + 19 / 21 * (C90 + 19 / 21 * (C95 + 19 / 21 * (C100 + 19 / 21 * (C105 + 19 / 21 * (C110 + 19 / 21 * (C115 + 19 / 21 * (C120 + 19 / 21 * (C125 + 19 / 21 * (C130 + 19 / 21 * (C135 + 19 / 21 * (C140 + 19 / 21 * (C145 + 19 / 21 * (C150 + 19 / 21 * (C155 + 19 / 21 * (C160 + 19 / 21 * (C165 + 19 / 21 * (C170 + 19 / 21 * (C175 + 19 / 21 * (C180 + 19 / 21 * (C185 + 19 / 21 * (C190 + 19 / 21 * (C195 + 19 / 21 * (C200 + 19 / 21 * (C205 + 19 / 21 * (C210 + 19 / 21 * (C215 + 19 / 21 * (C220 + 19 / 21 * (C225 + 19 / 21 * (C230 + 19 / 21 * (C235 + 19 / 21 * (C240 + 19 / 21 * (C245 + 19 / 21 * (C250 + 19 / 21 * (C255 + 19 / 21 * (C260 + 19 / 21 * (C265 + 19 / 21 * (C270 + 19 / 21 * (C275 + 19 / 21 * (C280 + 19 / 21 * (C285 + 19 / 21 * (C290 + 19 / 21 * (C295 + 19 / 21 * (C300 + 19 / 21 * (C305 + 19 / 21 * (C310 + 19 / 21 * (C315 + 19 / 21 * (C320 + 19 / 21 * (C325 + 19 / 21 * (C330 + 19 / 21 * (C335 + 19 / 21 * (C340 + 19 / 21 * (C345))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

QUOTE (vworden)
Above 40 week exp

Please try the following:

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

QUOTE (vworden)
20 week exp is above 40 week exp

Please try the following:

.0953245136006837 * (C + 19 / 21 * (C5 + 19 / 21 * (C10 + 19 / 21 * (C15 + 19 / 21 * (C20 + 19 / 21 * (C25 + 19 / 21 * (C30 + 19 / 21 * (C35 + 19 / 21 * (C40 + 19 / 21 * (C45 + 19 / 21 * (C50 + 19 / 21 * (C55 + 19 / 21 * (C60 + 19 / 21 * (C65 + 19 / 21 * (C70 + 19 / 21 * (C75 + 19 / 21 * (C80 + 19 / 21 * (C85 + 19 / 21 * (C90 + 19 / 21 * (C95 + 19 / 21 * (C100 + 19 / 21 * (C105 + 19 / 21 * (C110 + 19 / 21 * (C115 + 19 / 21 * (C120 + 19 / 21 * (C125 + 19 / 21 * (C130 + 19 / 21 * (C135 + 19 / 21 * (C140 + 19 / 21 * (C145 + 19 / 21 * (C150 + 19 / 21 * (C155 + 19 / 21 * (C160 + 19 / 21 * (C165 + 19 / 21 * (C170 + 19 / 21 * (C175 + 19 / 21 * (C180 + 19 / 21 * (C185 + 19 / 21 * (C190 + 19 / 21 * (C195 + 19 / 21 * (C200 + 19 / 21 * (C205 + 19 / 21 * (C210 + 19 / 21 * (C215 + 19 / 21 * (C220 + 19 / 21 * (C225 + 19 / 21 * (C230 + 19 / 21 * (C235 + 19 / 21 * (C240 + 19 / 21 * (C245 + 19 / 21 * (C250 + 19 / 21 * (C255 + 19 / 21 * (C260 + 19 / 21 * (C265 + 19 / 21 * (C270 + 19 / 21 * (C275 + 19 / 21 * (C280 + 19 / 21 * (C285 + 19 / 21 * (C290 + 19 / 21 * (C295 + 19 / 21 * (C300 + 19 / 21 * (C305 + 19 / 21 * (C310 + 19 / 21 * (C315 + 19 / 21 * (C320 + 19 / 21 * (C325 + 19 / 21 * (C330 + 19 / 21 * (C335 + 19 / 21 * (C340 + 19 / 21 * (C345)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0488272275519639 * (C + 39 / 41 * (C5 + 39 / 41 * (C10 + 39 / 41 * (C15 + 39 / 41 * (C20 + 39 / 41 * (C25 + 39 / 41 * (C30 + 39 / 41 * (C35 + 39 / 41 * (C40 + 39 / 41 * (C45 + 39 / 41 * (C50 + 39 / 41 * (C55 + 39 / 41 * (C60 + 39 / 41 * (C65 + 39 / 41 * (C70 + 39 / 41 * (C75 + 39 / 41 * (C80 + 39 / 41 * (C85 + 39 / 41 * (C90 + 39 / 41 * (C95 + 39 / 41 * (C100 + 39 / 41 * (C105 + 39 / 41 * (C110 + 39 / 41 * (C115 + 39 / 41 * (C120 + 39 / 41 * (C125 + 39 / 41 * (C130 + 39 / 41 * (C135 + 39 / 41 * (C140 + 39 / 41 * (C145 + 39 / 41 * (C150 + 39 / 41 * (C155 + 39 / 41 * (C160 + 39 / 41 * (C165 + 39 / 41 * (C170 + 39 / 41 * (C175 + 39 / 41 * (C180 + 39 / 41 * (C185 + 39 / 41 * (C190 + 39 / 41 * (C195 + 39 / 41 * (C200 + 39 / 41 * (C205 + 39 / 41 * (C210 + 39 / 41 * (C215 + 39 / 41 * (C220 + 39 / 41 * (C225 + 39 / 41 * (C230 + 39 / 41 * (C235 + 39 / 41 * (C240 + 39 / 41 * (C245 + 39 / 41 * (C250 + 39 / 41 * (C255 + 39 / 41 * (C260 + 39 / 41 * (C265 + 39 / 41 * (C270 + 39 / 41 * (C275 + 39 / 41 * (C280 + 39 / 41 * (C285 + 39 / 41 * (C290 + 39 / 41 * (C295 + 39 / 41 * (C300 + 39 / 41 * (C305 + 39 / 41 * (C310 + 39 / 41 * (C315 + 39 / 41 * (C320 + 39 / 41 * (C325 + 39 / 41 * (C330 + 39 / 41 * (C335 + 39 / 41 * (C340 + 39 / 41 * (C345 + 39 / 41 * (C350 + 39 / 41 * (C355 + 39 / 41 * (C360 + 39 / 41 * (C365 + 39 / 41 * (C370 + 39 / 41 * (C375 + 39 / 41 * (C380 + 39 / 41 * (C385 + 39 / 41 * (C390 + 39 / 41 * (C395 + 39 / 41 * (C400 + 39 / 41 * (C405 + 39 / 41 * (C410 + 39 / 41 * (C415 + 39 / 41 * (C420 + 39 / 41 * (C425 + 39 / 41 * (C430 + 39 / 41 * (C435 + 39 / 41 * (C440 + 39 / 41 * (C445 + 39 / 41 * (C450 + 39 / 41 * (C455 + 39 / 41 * (C460 + 39 / 41 * (C465 + 39 / 41 * (C470 + 39 / 41 * (C475 + 39 / 41 * (C480 + 39 / 41 * (C485 + 39 / 41 * (C490 + 39 / 41 * (C495 + 39 / 41 * (C500 + 39 / 41 * (C505 + 39 / 41 * (C510 + 39 / 41 * (C515 + 39 / 41 * (C520 + 39 / 41 * (C525 + 39 / 41 * (C530 + 39 / 41 * (C535 + 39 / 41 * (C540 + 39 / 41 * (C545 + 39 / 41 * (C550 + 39 / 41 * (C555 + 39 / 41 * (C560 + 39 / 41 * (C565 + 39 / 41 * (C570 + 39 / 41 * (C575 + 39 / 41 * (C580 + 39 / 41 * (C585 + 39 / 41 * (C590 + 39 / 41 * (C595 + 39 / 41 * (C600 + 39 / 41 * (C605 + 39 / 41 * (C610 + 39 / 41 * (C615 + 39 / 41 * (C620 + 39 / 41 * (C625 + 39 / 41 * (C630 + 39 / 41 * (C635 + 39 / 41 * (C640 + 39 / 41 * (C645 + 39 / 41 * (C650 + 39 / 41 * (C655 + 39 / 41 * (C660 + 39 / 41 * (C665 + 39 / 41 * (C670 + 39 / 41 * (C675 + 39 / 41 * (C680 + 39 / 41 * (C685 + 39 / 41 * (C690)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

QUOTE (vworden)
Stock pulling back to 40 week exp on less volume

We still need a detailed and objective definition of "pulling back" to write this. We also need to know what you see as "less volume". Do you want to compare the volume for just two bars or do you want to compare average volumes in some way?
-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.