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

weekly MVA crossover Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jaybird1
Posted : Sunday, August 5, 2007 4:31:32 PM
Registered User
Joined: 2/12/2005
Posts: 28
Looking for weekly crossover of Exponential Moving Averages. Would like to see the first time that wkly 10 exp MVA and wkly 20 Exp MVA are above wkly 30 Exp MVA. thanks
Bruce_L
Posted : Monday, August 6, 2007 10:18:36 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
In TeleChart, please try the following Personal Criteria Formulas:

Weekly EMA10 > EMA30 AND EMA20 > EMA30 but Not Last Week:

.181980276277401 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND NOT(.181980276277401 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515 + 29 / 31 * (C520)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515 + 29 / 31 * (C520)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

In Blocks, you can use the Moving Avg vs. Moving Avg Strategy Condition from the Web Library.

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
Cascades of Moving Averages

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jaybird1
Posted : Tuesday, August 7, 2007 6:01:43 PM
Registered User
Joined: 2/12/2005
Posts: 28
Thanks, but this does not produce the correct results. I am looking for the first time the 10 week EMA is above the 20 week EMA while the 20 week EMA is above the 30 week EMA. I hope this is clear.
Bruce_L
Posted : Tuesday, August 7, 2007 7:17:34 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
While your previous request did not reflect your intent, it seemed to be both clear and specific. Here are two possible interpretations of your new request:

Weekly EMA10 > EMA20 AND EMA20 > EMA30 but Not Last Week:

.181980276277401 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) > .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND NOT(.181980276277401 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))) > .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515 + 29 / 31 * (C520)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Weekly EMA10 xUp EMA20 since Last Week and EMA20 > EMA30:

.181980276277401 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) > .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .181980276277401 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))) <= .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

If neither of the above Personal Criteria Formulas reflects your intent, please provide specific examples so we can try to understand why and help you create a PCF that meets your requirements.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jaybird1
Posted : Wednesday, August 8, 2007 9:47:49 AM
Registered User
Joined: 2/12/2005
Posts: 28
Sorry, but that did not work either. You asked for an example. Please look at ULBI for a crossover up on 7/24/07 and on 1/24 crossover down for a sell(weekly).

I wrote a PCF for daily but can't convert to weekly.
(AVGC10 > XAVGC30 AND AVGC10 > XAVGC20 AND XAVGC20 > XAVGC30) AND (AVGC10.1 < XAVGC30.1 AND AVGC10.1 < XAVGC20.1 AND XAVGC20.1 < XAVGC30.1

Thanks
Bruce_L
Posted : Wednesday, August 8, 2007 10:22:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're daily formula can be shortened to:

AVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND AVGC10.1 < XAVGC20.1 AND XAVGC20.1 < XAVGC30.1

It should be noted that the 10-Period Moving Average in this formula is Simple, not Exponential. Is your charted 10-Period Moving Average Simple or Exponential?

What method are using to "backtest" the formula? If you are using a Custom Percent True, it should be noted that you would want to use the Daily formula on a Weekly chart, not the Weekly formula (which is only for use as a Personal Criteria Formula).

The daily versions of the three formulas already provided are:

EMA10 > EMA30 AND EMA20 > EMA30 but Not 1-Bar Ago:

XAVGC10 > XAVGC30 AND XAVGC20 > XAVGC30 AND NOT(XAVGC10.1 > XAVGC30.1 AND XAVGC20.1 > XAVGC30.1)

EMA10 > EMA20 AND EMA20 > EMA30 but Not 1-Bar Ago:

XAVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND NOT(XAVGC10.1 > XAVGC20.1 AND XAVGC20.1 > XAVGC30.1)

EMA10 xUp EMA20 and EMA20 > EMA30:

XAVGC10 > XAVGC20 AND XAVGC10.1 <= XAVGC20.1 AND XAVGC20 > XAVGC30

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jaybird1
Posted : Wednesday, August 8, 2007 10:54:16 AM
Registered User
Joined: 2/12/2005
Posts: 28
XAVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND XAVGC10.1 < XAVGC20.1 AND XAVGC20.1 < XAVGC30.1

Can you convert your above daily PCF to a weekly PCF?

Did you look at the example of a weekly ULBI chart to understand the crossover I am looking for?

This is my last try. I will not ask anymore?
Thanks for your help and your patience.
Bruce_L
Posted : Wednesday, August 8, 2007 1:26:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'll keep trying to help as long as you are willing to keep going.

When I have a Weekly chart for ULBI with a bar displayed for 7/24/07, I show the EMA20 xUp EMA30 between the 7/24/07 bar and the 7/31/07 bar. The EMA10 is above the EMA20 and the EMA30 for both the 7/24/07 bar and the 7/31/07 bar however. A weekly version of:

XAVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND XAVGC10.1 < XAVGC20.1 AND XAVGC20.1 < XAVGC30.1

Would not have caught this crossup because EMA10 would not have been below EMA20 for the 7/24/07 bar.

Weekly versions of (provided above):

EMA10 > EMA30 AND EMA20 > EMA30 but Not 1-Bar Ago:

XAVGC10 > XAVGC30 AND XAVGC20 > XAVGC30 AND NOT(XAVGC10.1 > XAVGC30.1 AND XAVGC20.1 > XAVGC30.1)

EMA10 > EMA20 AND EMA20 > EMA30 but Not 1-Bar Ago:

XAVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND NOT(XAVGC10.1 > XAVGC20.1 AND XAVGC20.1 > XAVGC30.1)

Would have both returned True when used as Personal Criteria Formula on 7/31/07.

I suggest trying the daily versions of all of the formulas as Custom Percent True Indicators on a Weekly chart to see which formulas would detect the type of crossovers desired. The following topic contains a video demonstrating how this could be accomplished:

Visually Backtesting Specific Symbols

The Weekly versions can only be used as Personal Criteria Formulas and will only return True on the date that the crossover actually happens. They will not return True if the crossover happened recently, but was not actually for the current Weekly bar.

The Weekly version of:

XAVGC10 > XAVGC20 AND XAVGC20 > XAVGC30 AND XAVGC10.1 < XAVGC20.1 AND XAVGC20.1 < XAVGC30.1

Is:

.181980276277401 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) > .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .181980276277401 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))) < .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) < .0645789155461771 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515 + 29 / 31 * (C520))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jaybird1
Posted : Wednesday, August 8, 2007 2:06:20 PM
Registered User
Joined: 2/12/2005
Posts: 28
This PCF seem to catch the crossings UP! Thanks That is What I was looking for.

What do I need to change in PCF to show crossover DOWN?
Bruce_L
Posted : Wednesday, August 8, 2007 2:10:37 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You would reverse the > and < signs. The Weekly version of:

XAVGC10 < XAVGC20 AND XAVGC20 < XAVGC30 AND XAVGC10.1 > XAVGC20.1 AND XAVGC20.1 > XAVGC30.1

Is:

.181980276277401 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170))))))))))))))))))))))))))))))))))) < .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .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)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) < .0645789155461771 * (C + 29 / 31 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .181980276277401 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))) > .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND .0953245136006837 * (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 + 19 / 21 * (C350)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) > .0645789155461771 * (C5 + 29 / 31 * (C10 + 29 / 31 * (C15 + 29 / 31 * (C20 + 29 / 31 * (C25 + 29 / 31 * (C30 + 29 / 31 * (C35 + 29 / 31 * (C40 + 29 / 31 * (C45 + 29 / 31 * (C50 + 29 / 31 * (C55 + 29 / 31 * (C60 + 29 / 31 * (C65 + 29 / 31 * (C70 + 29 / 31 * (C75 + 29 / 31 * (C80 + 29 / 31 * (C85 + 29 / 31 * (C90 + 29 / 31 * (C95 + 29 / 31 * (C100 + 29 / 31 * (C105 + 29 / 31 * (C110 + 29 / 31 * (C115 + 29 / 31 * (C120 + 29 / 31 * (C125 + 29 / 31 * (C130 + 29 / 31 * (C135 + 29 / 31 * (C140 + 29 / 31 * (C145 + 29 / 31 * (C150 + 29 / 31 * (C155 + 29 / 31 * (C160 + 29 / 31 * (C165 + 29 / 31 * (C170 + 29 / 31 * (C175 + 29 / 31 * (C180 + 29 / 31 * (C185 + 29 / 31 * (C190 + 29 / 31 * (C195 + 29 / 31 * (C200 + 29 / 31 * (C205 + 29 / 31 * (C210 + 29 / 31 * (C215 + 29 / 31 * (C220 + 29 / 31 * (C225 + 29 / 31 * (C230 + 29 / 31 * (C235 + 29 / 31 * (C240 + 29 / 31 * (C245 + 29 / 31 * (C250 + 29 / 31 * (C255 + 29 / 31 * (C260 + 29 / 31 * (C265 + 29 / 31 * (C270 + 29 / 31 * (C275 + 29 / 31 * (C280 + 29 / 31 * (C285 + 29 / 31 * (C290 + 29 / 31 * (C295 + 29 / 31 * (C300 + 29 / 31 * (C305 + 29 / 31 * (C310 + 29 / 31 * (C315 + 29 / 31 * (C320 + 29 / 31 * (C325 + 29 / 31 * (C330 + 29 / 31 * (C335 + 29 / 31 * (C340 + 29 / 31 * (C345 + 29 / 31 * (C350 + 29 / 31 * (C355 + 29 / 31 * (C360 + 29 / 31 * (C365 + 29 / 31 * (C370 + 29 / 31 * (C375 + 29 / 31 * (C380 + 29 / 31 * (C385 + 29 / 31 * (C390 + 29 / 31 * (C395 + 29 / 31 * (C400 + 29 / 31 * (C405 + 29 / 31 * (C410 + 29 / 31 * (C415 + 29 / 31 * (C420 + 29 / 31 * (C425 + 29 / 31 * (C430 + 29 / 31 * (C435 + 29 / 31 * (C440 + 29 / 31 * (C445 + 29 / 31 * (C450 + 29 / 31 * (C455 + 29 / 31 * (C460 + 29 / 31 * (C465 + 29 / 31 * (C470 + 29 / 31 * (C475 + 29 / 31 * (C480 + 29 / 31 * (C485 + 29 / 31 * (C490 + 29 / 31 * (C495 + 29 / 31 * (C500 + 29 / 31 * (C505 + 29 / 31 * (C510 + 29 / 31 * (C515 + 29 / 31 * (C520))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

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