Registered User Joined: 12/10/2004 Posts: 14
|
Need PCF for difference between the MACD line and signal line. MACD 40-85-45
Thank you for your help! Jonedyer
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
One way to write a Personal Criteria Formula for a Weekly MACD Histogram 40,85,45 is:
.429679602457283 * (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))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + .0256067419517758 * (C + 42 / 43 * (C5 + 42 / 43 * (C10 + 42 / 43 * (C15 + 42 / 43 * (C20 + 42 / 43 * (C25 + 42 / 43 * (C30 + 42 / 43 * (C35 + 42 / 43 * (C40 + 42 / 43 * (C45 + 42 / 43 * (C50 + 42 / 43 * (C55 + 42 / 43 * (C60 + 42 / 43 * (C65 + 42 / 43 * (C70 + 42 / 43 * (C75 + 42 / 43 * (C80 + 42 / 43 * (C85 + 42 / 43 * (C90 + 42 / 43 * (C95 + 42 / 43 * (C100 + 42 / 43 * (C105 + 42 / 43 * (C110 + 42 / 43 * (C115 + 42 / 43 * (C120 + 42 / 43 * (C125 + 42 / 43 * (C130 + 42 / 43 * (C135 + 42 / 43 * (C140 + 42 / 43 * (C145 + 42 / 43 * (C150 + 42 / 43 * (C155 + 42 / 43 * (C160 + 42 / 43 * (C165 + 42 / 43 * (C170 + 42 / 43 * (C175 + 42 / 43 * (C180 + 42 / 43 * (C185 + 42 / 43 * (C190 + 42 / 43 * (C195 + 42 / 43 * (C200 + 42 / 43 * (C205 + 42 / 43 * (C210 + 42 / 43 * (C215 + 42 / 43 * (C220 + 42 / 43 * (C225 + 42 / 43 * (C230 + 42 / 43 * (C235 + 42 / 43 * (C240 + 42 / 43 * (C245 + 42 / 43 * (C250 + 42 / 43 * (C255 + 42 / 43 * (C260 + 42 / 43 * (C265 + 42 / 43 * (C270 + 42 / 43 * (C275 + 42 / 43 * (C280 + 42 / 43 * (C285 + 42 / 43 * (C290 + 42 / 43 * (C295 + 42 / 43 * (C300 + 42 / 43 * (C305 + 42 / 43 * (C310 + 42 / 43 * (C315 + 42 / 43 * (C320 + 42 / 43 * (C325 + 42 / 43 * (C330 + 42 / 43 * (C335 + 42 / 43 * (C340 + 42 / 43 * (C345 + 42 / 43 * (C350 + 42 / 43 * (C355 + 42 / 43 * (C360 + 42 / 43 * (C365 + 42 / 43 * (C370 + 42 / 43 * (C375 + 42 / 43 * (C380 + 42 / 43 * (C385 + 42 / 43 * (C390 + 42 / 43 * (C395 + 42 / 43 * (C400 + 42 / 43 * (C405 + 42 / 43 * (C410 + 42 / 43 * (C415 + 42 / 43 * (C420 + 42 / 43 * (C425 + 42 / 43 * (C430 + 42 / 43 * (C435 + 42 / 43 * (C440 + 42 / 43 * (C445 + 42 / 43 * (C450 + 42 / 43 * (C455 + 42 / 43 * (C460 + 42 / 43 * (C465 + 42 / 43 * (C470 + 42 / 43 * (C475 + 42 / 43 * (C480 + 42 / 43 * (C485 + 42 / 43 * (C490 + 42 / 43 * (C495 + 42 / 43 * (C500 + 42 / 43 * (C505 + 42 / 43 * (C510 + 42 / 43 * (C515 + 42 / 43 * (C520 + 42 / 43 * (C525 + 42 / 43 * (C530 + 42 / 43 * (C535 + 42 / 43 * (C540 + 42 / 43 * (C545 + 42 / 43 * (C550 + 42 / 43 * (C555 + 42 / 43 * (C560 + 42 / 43 * (C565 + 42 / 43 * (C570 + 42 / 43 * (C575 + 42 / 43 * (C580 + 42 / 43 * (C585 + 42 / 43 * (C590 + 42 / 43 * (C595 + 42 / 43 * (C600 + 42 / 43 * (C605 + 42 / 43 * (C610 + 42 / 43 * (C615 + 42 / 43 * (C620 + 42 / 43 * (C625 + 42 / 43 * (C630 + 42 / 43 * (C635 + 42 / 43 * (C640 + 42 / 43 * (C645 + 42 / 43 * (C650 + 42 / 43 * (C655 + 42 / 43 * (C660 + 42 / 43 * (C665 + 42 / 43 * (C670 + 42 / 43 * (C675 + 42 / 43 * (C680 + 42 / 43 * (C685 + 42 / 43 * (C690 + 42 / 43 * (C695 + 42 / 43 * (C700 + 42 / 43 * (C705 + 42 / 43 * (C710 + 42 / 43 * (C715 + 42 / 43 * (C720 + 42 / 43 * (C725 + 42 / 43 * (C730 + 42 / 43 * (C735 + 42 / 43 * (C740 + 42 / 43 * (C745 + 42 / 43 * (C750 + 42 / 43 * (C755 + 42 / 43 * (C760 + 42 / 43 * (C765 + 42 / 43 * (C770 + 42 / 43 * (C775 + 42 / 43 * (C780 + 42 / 43 * (C785 + 42 / 43 * (C790 + 42 / 43 * (C795 + 42 / 43 * (C800 + 42 / 43 * (C805 + 42 / 43 * (C810 + 42 / 43 * (C815 + 42 / 43 * (C820 + 42 / 43 * (C825 + 42 / 43 * (C830 + 42 / 43 * (C835 + 42 / 43 * (C840 + 42 / 43 * (C845 + 42 / 43 * (C850 + 42 / 43 * (C855 + 42 / 43 * (C860 + 42 / 43 * (C865 + 42 / 43 * (C870 + 42 / 43 * (C875 + 42 / 43 * (C880 + 42 / 43 * (C885 + 42 / 43 * (C890 + 42 / 43 * (C895 + 42 / 43 * (C900 + 42 / 43 * (C905 + 42 / 43 * (C910 + 42 / 43 * (C915 + 42 / 43 * (C920 + 42 / 43 * (C925 + 42 / 43 * (C930 + 42 / 43 * (C935 + 42 / 43 * (C940 + 42 / 43 * (C945 + 42 / 43 * (C950 + 42 / 43 * (C955 + 42 / 43 * (C960 + 42 / 43 * (C965 + 42 / 43 * (C970 + 42 / 43 * (C975 + 42 / 43 * (C980 + 42 / 43 * (C985 + 42 / 43 * (C990 + 42 / 43 * (C995 + 42 / 43 * (C1000 + 42 / 43 * (C1005 + 42 / 43 * (C1010 + 42 / 43 * (C1015 + 42 / 43 * (C1020 + 42 / 43 * (C1025 + 42 / 43 * (C1030 + 42 / 43 * (C1035 + 42 / 43 * (C1040 + 42 / 43 * (C1045 + 42 / 43 * (C1050 + 42 / 43 * (C1055 + 42 / 43 * (C1060 + 42 / 43 * (C1065 + 42 / 43 * (C1070 + 42 / 43 * (C1075 + 42 / 43 * (C1080 + 42 / 43 * (C1085 + 42 / 43 * (C1090 + 42 / 43 * (C1095 + 42 / 43 * (C1100 + 42 / 43 * (C1105 + 42 / 43 * (C1110 + 42 / 43 * (C1115 + 42 / 43 * (C1120 + 42 / 43 * (C1125 + 42 / 43 * (C1130 + 42 / 43 * (C1135 + 42 / 43 * (C1140 + 42 / 43 * (C1145 + 42 / 43 * (C1150 + 42 / 43 * (C1155 + 42 / 43 * (C1160 + 42 / 43 * (C1165 + 42 / 43 * (C1170 + 42 / 43 * (C1175 + 42 / 43 * (C1180 + 42 / 43 * (C1185 + 42 / 43 * (C1190 + 42 / 43 * (C1195 + 42 / 43 * (C1200 + 42 / 43 * (C1205 + 42 / 43 * (C1210 + 42 / 43 * (C1215 + 42 / 43 * (C1220 + 42 / 43 * (C1225 + 42 / 43 * (C1230 + 42 / 43 * (C1235 + 42 / 43 * (C1240 + 42 / 43 * (C1245 + 42 / 43 * (C1250 + 42 / 43 * (C1255 + 42 / 43 * (C1260 + 42 / 43 * (C1265 + 42 / 43 * (C1270 + 42 / 43 * (C1275 + 42 / 43 * (C1280 + 42 / 43 * (C1285 + 42 / 43 * (C1290 + 42 / 43 * (C1295 + 42 / 43 * (C1300 + 42 / 43 * (C1305 + 42 / 43 * (C1310 + 42 / 43 * (C1315 + 42 / 43 * (C1320 + 42 / 43 * (C1325 + 42 / 43 * (C1330 + 42 / 43 * (C1335 + 42 / 43 * (C1340 + 42 / 43 * (C1345 + 42 / 43 * (C1350 + 42 / 43 * (C1355 + 42 / 43 * (C1360 + 42 / 43 * (C1365 + 42 / 43 * (C1370 + 42 / 43 * (C1375 + 42 / 43 * (C1380 + 42 / 43 * (C1385 + 42 / 43 * (C1390 + 42 / 43 * (C1395 + 42 / 43 * (C1400 + 42 / 43 * (C1405 + 42 / 43 * (C1410 + 42 / 43 * (C1415 + 42 / 43 * (C1420 + 42 / 43 * (C1425 + 42 / 43 * (C1430 + 42 / 43 * (C1435 + 42 / 43 * (C1440 + 42 / 43 * (C1445 + 42 / 43 * (C1450 + 42 / 43 * (C1455 + 42 / 43 * (C1460 + 42 / 43 * (C1465)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - .43085427703804 * (C + 22 / 23 * (C5 + 22 / 23 * (C10 + 22 / 23 * (C15 + 22 / 23 * (C20 + 22 / 23 * (C25 + 22 / 23 * (C30 + 22 / 23 * (C35 + 22 / 23 * (C40 + 22 / 23 * (C45 + 22 / 23 * (C50 + 22 / 23 * (C55 + 22 / 23 * (C60 + 22 / 23 * (C65 + 22 / 23 * (C70 + 22 / 23 * (C75 + 22 / 23 * (C80 + 22 / 23 * (C85 + 22 / 23 * (C90 + 22 / 23 * (C95 + 22 / 23 * (C100 + 22 / 23 * (C105 + 22 / 23 * (C110 + 22 / 23 * (C115 + 22 / 23 * (C120 + 22 / 23 * (C125 + 22 / 23 * (C130 + 22 / 23 * (C135 + 22 / 23 * (C140 + 22 / 23 * (C145 + 22 / 23 * (C150 + 22 / 23 * (C155 + 22 / 23 * (C160 + 22 / 23 * (C165 + 22 / 23 * (C170 + 22 / 23 * (C175 + 22 / 23 * (C180 + 22 / 23 * (C185 + 22 / 23 * (C190 + 22 / 23 * (C195 + 22 / 23 * (C200 + 22 / 23 * (C205 + 22 / 23 * (C210 + 22 / 23 * (C215 + 22 / 23 * (C220 + 22 / 23 * (C225 + 22 / 23 * (C230 + 22 / 23 * (C235 + 22 / 23 * (C240 + 22 / 23 * (C245 + 22 / 23 * (C250 + 22 / 23 * (C255 + 22 / 23 * (C260 + 22 / 23 * (C265 + 22 / 23 * (C270 + 22 / 23 * (C275 + 22 / 23 * (C280 + 22 / 23 * (C285 + 22 / 23 * (C290 + 22 / 23 * (C295 + 22 / 23 * (C300 + 22 / 23 * (C305 + 22 / 23 * (C310 + 22 / 23 * (C315 + 22 / 23 * (C320 + 22 / 23 * (C325 + 22 / 23 * (C330 + 22 / 23 * (C335 + 22 / 23 * (C340 + 22 / 23 * (C345 + 22 / 23 * (C350 + 22 / 23 * (C355 + 22 / 23 * (C360 + 22 / 23 * (C365 + 22 / 23 * (C370 + 22 / 23 * (C375 + 22 / 23 * (C380 + 22 / 23 * (C385 + 22 / 23 * (C390 + 22 / 23 * (C395 + 22 / 23 * (C400 + 22 / 23 * (C405 + 22 / 23 * (C410 + 22 / 23 * (C415 + 22 / 23 * (C420 + 22 / 23 * (C425 + 22 / 23 * (C430 + 22 / 23 * (C435 + 22 / 23 * (C440 + 22 / 23 * (C445 + 22 / 23 * (C450 + 22 / 23 * (C455 + 22 / 23 * (C460 + 22 / 23 * (C465 + 22 / 23 * (C470 + 22 / 23 * (C475 + 22 / 23 * (C480 + 22 / 23 * (C485 + 22 / 23 * (C490 + 22 / 23 * (C495 + 22 / 23 * (C500 + 22 / 23 * (C505 + 22 / 23 * (C510 + 22 / 23 * (C515 + 22 / 23 * (C520 + 22 / 23 * (C525 + 22 / 23 * (C530 + 22 / 23 * (C535 + 22 / 23 * (C540 + 22 / 23 * (C545 + 22 / 23 * (C550 + 22 / 23 * (C555 + 22 / 23 * (C560 + 22 / 23 * (C565 + 22 / 23 * (C570 + 22 / 23 * (C575 + 22 / 23 * (C580 + 22 / 23 * (C585 + 22 / 23 * (C590 + 22 / 23 * (C595 + 22 / 23 * (C600 + 22 / 23 * (C605 + 22 / 23 * (C610 + 22 / 23 * (C615 + 22 / 23 * (C620 + 22 / 23 * (C625 + 22 / 23 * (C630 + 22 / 23 * (C635 + 22 / 23 * (C640 + 22 / 23 * (C645 + 22 / 23 * (C650 + 22 / 23 * (C655 + 22 / 23 * (C660 + 22 / 23 * (C665 + 22 / 23 * (C670 + 22 / 23 * (C675 + 22 / 23 * (C680 + 22 / 23 * (C685 + 22 / 23 * (C690 + 22 / 23 * (C695 + 22 / 23 * (C700 + 22 / 23 * (C705 + 22 / 23 * (C710 + 22 / 23 * (C715 + 22 / 23 * (C720 + 22 / 23 * (C725 + 22 / 23 * (C730 + 22 / 23 * (C735 + 22 / 23 * (C740 + 22 / 23 * (C745 + 22 / 23 * (C750 + 22 / 23 * (C755 + 22 / 23 * (C760 + 22 / 23 * (C765 + 22 / 23 * (C770 + 22 / 23 * (C775))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
You can just add a > 0 to the end to check for it being positive or a < 0 to check for it being negative.
How to create a Personal Criteria Forumula (PCF)
Cascades of Moving Averages
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|