| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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.
|
|
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
|
|
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.
|
|
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
|
|
|
Guest-1 |