Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 7/23/2005 Posts: 39
|
Hi, I remember I came cross a webtool to generate weekly exp MACD when it cross signal or zero line. I can't find it any more. I would like to have help with weekly exp MACD(5,34,5) when it cross above signal line but below zero and MACD close to zero. Thanks Song
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
You would have gotten the link via the Peter Worden Winning Stock Selection Simplified II video.
Grab the video and put it in your computer. The link is on the opening menu of the video.
- Craig Here to Help!
|
|
Registered User Joined: 7/23/2005 Posts: 39
|
Hi, Dear Craig I have tried the webtool and I noticed the formula is for simple MACD. I am not sure what MACD period means? Is it for moving average of MACD? I would like the formula for expotential MACD(5,34,5). Thank Song
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
It is for exponential, not simple.
Your short: 5 Your long: 34 Your MACD period: 5 Your lookback (how many bars back can the cross happen in): ?? (up to you) Your days/bar: 5
- Craig Here to Help!
|
|
Registered User Joined: 7/23/2005 Posts: 39
|
Hi, the webtool would not generate formula and give error message as "periods must be different". Song
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Did you put at least 1 in for lookback? Are you short and longs different numbers?
- Craig Here to Help!
|
|
Registered User Joined: 7/23/2005 Posts: 39
|
yes, I got error when I used 5 for short and 34 for long and 5 for MACD. when I change MACD to anything other than 5, It works. very strange. Song
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Hmmm... sure enough (I just tried it as well).
Let me play with it a bit. I or Bruce will get a formula up here for you today.
- Craig Here to Help!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
Weekly Exponential MACD(5,34,5) Histogram Crossing Up Thru Zero:
(25 * .333559032545198 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) + 4 * .0571980645061175 * (C + 33 / 35 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / 29 - .11119698203496 * (C + 2 / 3 * (2 * C5 + 2 / 3 * (3 * C10 + 2 / 3 * (4 * C15 + 2 / 3 * (5 * C20 + 2 / 3 * (6 * C25 + 2 / 3 * (7 * C30 + 2 / 3 * (8 * C35 + 2 / 3 * (9 * C40 + 2 / 3 * (10 * C45 + 2 / 3 * (11 * C50 + 2 / 3 * (12 * C55 + 2 / 3 * (13 * C60 + 2 / 3 * (14 * C65 + 2 / 3 * (15 * C70 + 2 / 3 * (16 * C75 + 2 / 3 * (17 * C80 + 2 / 3 * (18 * C85 + 2 / 3 * (19 * C90 + 2 / 3 * (20 * C95 + 2 / 3 * (21 * C100 + 2 / 3 * (22 * C105 + 2 / 3 * (23 * C110))))))))))))))))))))))) > 0 AND (25 * .333559032545198 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85 + 2 / 3 * (C90)))))))))))))))))) + 4 * .0571980645061175 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585 + 33 / 35 * (C590))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) / 29 - .11119698203496 * (C5 + 2 / 3 * (2 * C10 + 2 / 3 * (3 * C15 + 2 / 3 * (4 * C20 + 2 / 3 * (5 * C25 + 2 / 3 * (6 * C30 + 2 / 3 * (7 * C35 + 2 / 3 * (8 * C40 + 2 / 3 * (9 * C45 + 2 / 3 * (10 * C50 + 2 / 3 * (11 * C55 + 2 / 3 * (12 * C60 + 2 / 3 * (13 * C65 + 2 / 3 * (14 * C70 + 2 / 3 * (15 * C75 + 2 / 3 * (16 * C80 + 2 / 3 * (17 * C85 + 2 / 3 * (18 * C90 + 2 / 3 * (19 * C95 + 2 / 3 * (20 * C100 + 2 / 3 * (21 * C105 + 2 / 3 * (22 * C110 + 2 / 3 * (23 * C115))))))))))))))))))))))) <= 0
Weekly Exponential MACD(5,34) Below Zero:
.333559032545198 * (C + 2 / 3 * (C5 + 2 / 3 * (C10 + 2 / 3 * (C15 + 2 / 3 * (C20 + 2 / 3 * (C25 + 2 / 3 * (C30 + 2 / 3 * (C35 + 2 / 3 * (C40 + 2 / 3 * (C45 + 2 / 3 * (C50 + 2 / 3 * (C55 + 2 / 3 * (C60 + 2 / 3 * (C65 + 2 / 3 * (C70 + 2 / 3 * (C75 + 2 / 3 * (C80 + 2 / 3 * (C85)))))))))))))))))) - .0571980645061175 * (C + 33 / 35 * (C5 + 33 / 35 * (C10 + 33 / 35 * (C15 + 33 / 35 * (C20 + 33 / 35 * (C25 + 33 / 35 * (C30 + 33 / 35 * (C35 + 33 / 35 * (C40 + 33 / 35 * (C45 + 33 / 35 * (C50 + 33 / 35 * (C55 + 33 / 35 * (C60 + 33 / 35 * (C65 + 33 / 35 * (C70 + 33 / 35 * (C75 + 33 / 35 * (C80 + 33 / 35 * (C85 + 33 / 35 * (C90 + 33 / 35 * (C95 + 33 / 35 * (C100 + 33 / 35 * (C105 + 33 / 35 * (C110 + 33 / 35 * (C115 + 33 / 35 * (C120 + 33 / 35 * (C125 + 33 / 35 * (C130 + 33 / 35 * (C135 + 33 / 35 * (C140 + 33 / 35 * (C145 + 33 / 35 * (C150 + 33 / 35 * (C155 + 33 / 35 * (C160 + 33 / 35 * (C165 + 33 / 35 * (C170 + 33 / 35 * (C175 + 33 / 35 * (C180 + 33 / 35 * (C185 + 33 / 35 * (C190 + 33 / 35 * (C195 + 33 / 35 * (C200 + 33 / 35 * (C205 + 33 / 35 * (C210 + 33 / 35 * (C215 + 33 / 35 * (C220 + 33 / 35 * (C225 + 33 / 35 * (C230 + 33 / 35 * (C235 + 33 / 35 * (C240 + 33 / 35 * (C245 + 33 / 35 * (C250 + 33 / 35 * (C255 + 33 / 35 * (C260 + 33 / 35 * (C265 + 33 / 35 * (C270 + 33 / 35 * (C275 + 33 / 35 * (C280 + 33 / 35 * (C285 + 33 / 35 * (C290 + 33 / 35 * (C295 + 33 / 35 * (C300 + 33 / 35 * (C305 + 33 / 35 * (C310 + 33 / 35 * (C315 + 33 / 35 * (C320 + 33 / 35 * (C325 + 33 / 35 * (C330 + 33 / 35 * (C335 + 33 / 35 * (C340 + 33 / 35 * (C345 + 33 / 35 * (C350 + 33 / 35 * (C355 + 33 / 35 * (C360 + 33 / 35 * (C365 + 33 / 35 * (C370 + 33 / 35 * (C375 + 33 / 35 * (C380 + 33 / 35 * (C385 + 33 / 35 * (C390 + 33 / 35 * (C395 + 33 / 35 * (C400 + 33 / 35 * (C405 + 33 / 35 * (C410 + 33 / 35 * (C415 + 33 / 35 * (C420 + 33 / 35 * (C425 + 33 / 35 * (C430 + 33 / 35 * (C435 + 33 / 35 * (C440 + 33 / 35 * (C445 + 33 / 35 * (C450 + 33 / 35 * (C455 + 33 / 35 * (C460 + 33 / 35 * (C465 + 33 / 35 * (C470 + 33 / 35 * (C475 + 33 / 35 * (C480 + 33 / 35 * (C485 + 33 / 35 * (C490 + 33 / 35 * (C495 + 33 / 35 * (C500 + 33 / 35 * (C505 + 33 / 35 * (C510 + 33 / 35 * (C515 + 33 / 35 * (C520 + 33 / 35 * (C525 + 33 / 35 * (C530 + 33 / 35 * (C535 + 33 / 35 * (C540 + 33 / 35 * (C545 + 33 / 35 * (C550 + 33 / 35 * (C555 + 33 / 35 * (C560 + 33 / 35 * (C565 + 33 / 35 * (C570 + 33 / 35 * (C575 + 33 / 35 * (C580 + 33 / 35 * (C585)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) < 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |