Registered User
Joined: 9/6/2005
Posts: 26
|
I have reviewed the site but I cant seem to locate the help I seek.
I am trying to build a PCF based on MACD 12,26 period 9...and I am looking to scan for stocks where the MACD of 12,26 is crossing up through period of 9 one day ago and below the zero line. I would also like to create the reverse of that scan, above zero.
I have the following:
(XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC9.1,12) - XAVG(XAVGC26.1,9)) AND (XAVGC12.2 - XAVGC26.2) < (XAVG(XAVGC9.2,12) - XAVG(XAVGC26.2,9))
i am not getting consitent results, Please send help! thanks!
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
Below 0 crossing up
(XAVGC12 - XAVGC26) < 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) < 0 AND ((XAVGC12.1 - XAVGC26.1) < (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) > (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
Above 0 crossing down
(XAVGC12 - XAVGC26) > 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) > 0 AND ((XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) < (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
|
Registered User
Joined: 9/6/2005
Posts: 26
|
THanks! that is it!!! I forgot the > < 0!! thank you very much!
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
If I read pcarma correctly, I believe this is what he wants:
Just combine two PCFs from below with an AND
MACD below 0 Today and MACD x Up SL9 Yesterday
(XAVGC12.0 - XAVGC26.0) >0 AND (XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)) AND (XAVGC12.2 - XAVGC26.2) < (XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9))
To reverse the MACD crossing down just reverse the > and <
Below are some Exp MACD PCF’s
Exp MACD 12,26 Above or Below 0 Line
(XAVGC12.0 - XAVGC26.0) >0 Exp MACD Above 0, Today
(XAVGC12.1 - XAVGC26.1) >0 Exp MACD Above 0, Yesterday
(XAVGC12.0 - XAVGC26.0) <0 Exp MACD Below 0, Today
(XAVGC12.1 - XAVGC26.1) <0 Exp MACD Below 0, Yesterday
Exp MACD12,26,9 Crossing (X) UP Exp SL9, Today, or (Exp Histogram (X) UP 0)
(XAVGC12 - XAVGC26) > (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) AND (XAVGC12.1 - XAVGC26.1) < (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))
Exp MACD12,26,9 Crossing (X) UP Exp SL9, Yesterday, or (Exp Histogram (X) UP 0)
(XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)) AND (XAVGC12.2 - XAVGC26.2) < (XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9))
Thanks
Winnie
|
Registered User
Joined: 10/7/2004
Posts: 1,006
|
Just spotted the arrow in the wrong direction for MACD below 0
MACD below 0 Today and MACD x Up SL9 Yesterday
(XAVGC12.0 - XAVGC26.0) <0 AND (XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)) AND (XAVGC12.2 - XAVGC26.2) < (XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9))
|
Registered User
Joined: 9/6/2005
Posts: 26
|
winnie, thanks for the input.
|
Registered User
Joined: 9/6/2005
Posts: 26
|
Stockguy helped me build the MACD formula below- and I am trying to tweek it a little. I'd like to add criteria that filters out the daily macd turning up (like the first formula) but I want to show only stocks that have a positive monthly MACD...so the filter will sort out all stocks that have the MACD crossing up 1 day ago and then find thaose that meet that criteria and also have a positive monthly MACD... Is this possible?
Below 0 crossing up
(XAVGC12 - XAVGC26) < 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) < 0 AND ((XAVGC12.1 - XAVGC26.1) < (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) > (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
Above 0 crossing down
(XAVGC12 - XAVGC26) > 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) > 0 AND ((XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) < (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
pcarma,
Please try the following:
Raw Daily Exponential MACD 12,26,9 below Zero, xUp Trigger and Raw Monthly above Zero:
XAVGC12 < XAVGC26 AND XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 <= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND .153984303064341 * (C + 11 / 13 * (C21 + 11 / 13 * (C42 + 11 / 13 * (C63 + 11 / 13 * (C84 + 11 / 13 * (C105 + 11 / 13 * (C126 + 11 / 13 * (C147 + 11 / 13 * (C168 + 11 / 13 * (C189 + 11 / 13 * (C210 + 11 / 13 * (C231 + 11 / 13 * (C252 + 11 / 13 * (C273 + 11 / 13 * (C294 + 11 / 13 * (C315 + 11 / 13 * (C336 + 11 / 13 * (C357 + 11 / 13 * (C378 + 11 / 13 * (C399 + 11 / 13 * (C420 + 11 / 13 * (C441 + 11 / 13 * (C462 + 11 / 13 * (C483 + 11 / 13 * (C504 + 11 / 13 * (C525 + 11 / 13 * (C546 + 11 / 13 * (C567 + 11 / 13 * (C588 + 11 / 13 * (C609 + 11 / 13 * (C630 + 11 / 13 * (C651 + 11 / 13 * (C672 + 11 / 13 * (C693 + 11 / 13 * (C714 + 11 / 13 * (C735 + 11 / 13 * (C756 + 11 / 13 * (C777 + 11 / 13 * (C798 + 11 / 13 * (C819 + 11 / 13 * (C840 + 11 / 13 * (C861)))))))))))))))))))))))))))))))))))))))))) > .0741468444601841 * (C + 25 / 27 * (C21 + 25 / 27 * (C42 + 25 / 27 * (C63 + 25 / 27 * (C84 + 25 / 27 * (C105 + 25 / 27 * (C126 + 25 / 27 * (C147 + 25 / 27 * (C168 + 25 / 27 * (C189 + 25 / 27 * (C210 + 25 / 27 * (C231 + 25 / 27 * (C252 + 25 / 27 * (C273 + 25 / 27 * (C294 + 25 / 27 * (C315 + 25 / 27 * (C336 + 25 / 27 * (C357 + 25 / 27 * (C378 + 25 / 27 * (C399 + 25 / 27 * (C420 + 25 / 27 * (C441 + 25 / 27 * (C462 + 25 / 27 * (C483 + 25 / 27 * (C504 + 25 / 27 * (C525 + 25 / 27 * (C546 + 25 / 27 * (C567 + 25 / 27 * (C588 + 25 / 27 * (C609 + 25 / 27 * (C630 + 25 / 27 * (C651 + 25 / 27 * (C672 + 25 / 27 * (C693 + 25 / 27 * (C714 + 25 / 27 * (C735 + 25 / 27 * (C756 + 25 / 27 * (C777 + 25 / 27 * (C798 + 25 / 27 * (C819 + 25 / 27 * (C840 + 25 / 27 * (C861 + 25 / 27 * (C882 + 25 / 27 * (C903 + 25 / 27 * (C924 + 25 / 27 * (C945 + 25 / 27 * (C966 + 25 / 27 * (C987 + 25 / 27 * (C1008 + 25 / 27 * (C1029 + 25 / 27 * (C1050 + 25 / 27 * (C1071 + 25 / 27 * (C1092 + 25 / 27 * (C1113 + 25 / 27 * (C1134 + 25 / 27 * (C1155 + 25 / 27 * (C1176 + 25 / 27 * (C1197 + 25 / 27 * (C1218 + 25 / 27 * (C1239 + 25 / 27 * (C1260 + 25 / 27 * (C1281 + 25 / 27 * (C1302 + 25 / 27 * (C1323 + 25 / 27 * (C1344 + 25 / 27 * (C1365 + 25 / 27 * (C1386 + 25 / 27 * (C1407 + 25 / 27 * (C1428 + 25 / 27 * (C1449 + 25 / 27 * (C1470 + 25 / 27 * (C1491 + 25 / 27 * (C1512 + 25 / 27 * (C1533 + 25 / 27 * (C1554 + 25 / 27 * (C1575 + 25 / 27 * (C1596 + 25 / 27 * (C1617 + 25 / 27 * (C1638 + 25 / 27 * (C1659 + 25 / 27 * (C1680 + 25 / 27 * (C1701 + 25 / 27 * (C1722 + 25 / 27 * (C1743 + 25 / 27 * (C1764 + 25 / 27 * (C1785 + 25 / 27 * (C1806 + 25 / 27 * (C1827 + 25 / 27 * (C1848 + 25 / 27 * (C1869))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Raw Daily Exponential MACD 12,26,9 above Zero, xDn Trigger and Raw Monthly below Zero:
XAVGC12 > XAVGC26 AND XAVGC12 - XAVGC26 < XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 >= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND .153984303064341 * (C + 11 / 13 * (C21 + 11 / 13 * (C42 + 11 / 13 * (C63 + 11 / 13 * (C84 + 11 / 13 * (C105 + 11 / 13 * (C126 + 11 / 13 * (C147 + 11 / 13 * (C168 + 11 / 13 * (C189 + 11 / 13 * (C210 + 11 / 13 * (C231 + 11 / 13 * (C252 + 11 / 13 * (C273 + 11 / 13 * (C294 + 11 / 13 * (C315 + 11 / 13 * (C336 + 11 / 13 * (C357 + 11 / 13 * (C378 + 11 / 13 * (C399 + 11 / 13 * (C420 + 11 / 13 * (C441 + 11 / 13 * (C462 + 11 / 13 * (C483 + 11 / 13 * (C504 + 11 / 13 * (C525 + 11 / 13 * (C546 + 11 / 13 * (C567 + 11 / 13 * (C588 + 11 / 13 * (C609 + 11 / 13 * (C630 + 11 / 13 * (C651 + 11 / 13 * (C672 + 11 / 13 * (C693 + 11 / 13 * (C714 + 11 / 13 * (C735 + 11 / 13 * (C756 + 11 / 13 * (C777 + 11 / 13 * (C798 + 11 / 13 * (C819 + 11 / 13 * (C840 + 11 / 13 * (C861)))))))))))))))))))))))))))))))))))))))))) < .0741468444601841 * (C + 25 / 27 * (C21 + 25 / 27 * (C42 + 25 / 27 * (C63 + 25 / 27 * (C84 + 25 / 27 * (C105 + 25 / 27 * (C126 + 25 / 27 * (C147 + 25 / 27 * (C168 + 25 / 27 * (C189 + 25 / 27 * (C210 + 25 / 27 * (C231 + 25 / 27 * (C252 + 25 / 27 * (C273 + 25 / 27 * (C294 + 25 / 27 * (C315 + 25 / 27 * (C336 + 25 / 27 * (C357 + 25 / 27 * (C378 + 25 / 27 * (C399 + 25 / 27 * (C420 + 25 / 27 * (C441 + 25 / 27 * (C462 + 25 / 27 * (C483 + 25 / 27 * (C504 + 25 / 27 * (C525 + 25 / 27 * (C546 + 25 / 27 * (C567 + 25 / 27 * (C588 + 25 / 27 * (C609 + 25 / 27 * (C630 + 25 / 27 * (C651 + 25 / 27 * (C672 + 25 / 27 * (C693 + 25 / 27 * (C714 + 25 / 27 * (C735 + 25 / 27 * (C756 + 25 / 27 * (C777 + 25 / 27 * (C798 + 25 / 27 * (C819 + 25 / 27 * (C840 + 25 / 27 * (C861 + 25 / 27 * (C882 + 25 / 27 * (C903 + 25 / 27 * (C924 + 25 / 27 * (C945 + 25 / 27 * (C966 + 25 / 27 * (C987 + 25 / 27 * (C1008 + 25 / 27 * (C1029 + 25 / 27 * (C1050 + 25 / 27 * (C1071 + 25 / 27 * (C1092 + 25 / 27 * (C1113 + 25 / 27 * (C1134 + 25 / 27 * (C1155 + 25 / 27 * (C1176 + 25 / 27 * (C1197 + 25 / 27 * (C1218 + 25 / 27 * (C1239 + 25 / 27 * (C1260 + 25 / 27 * (C1281 + 25 / 27 * (C1302 + 25 / 27 * (C1323 + 25 / 27 * (C1344 + 25 / 27 * (C1365 + 25 / 27 * (C1386 + 25 / 27 * (C1407 + 25 / 27 * (C1428 + 25 / 27 * (C1449 + 25 / 27 * (C1470 + 25 / 27 * (C1491 + 25 / 27 * (C1512 + 25 / 27 * (C1533 + 25 / 27 * (C1554 + 25 / 27 * (C1575 + 25 / 27 * (C1596 + 25 / 27 * (C1617 + 25 / 27 * (C1638 + 25 / 27 * (C1659 + 25 / 27 * (C1680 + 25 / 27 * (C1701 + 25 / 27 * (C1722 + 25 / 27 * (C1743 + 25 / 27 * (C1764 + 25 / 27 * (C1785 + 25 / 27 * (C1806 + 25 / 27 * (C1827 + 25 / 27 * (C1848 + 25 / 27 * (C1869))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
You may wish to review the following:
Understanding MACD
PCF Formula Descriptions
Cascades of Moving Averages
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
|