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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » webtool for weekly MACD pcf

webtool for weekly MACD pcf Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
drsong
Posted : Friday, November 10, 2006 7:23:19 PM
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
Back to top
Craig_S
Posted : Saturday, November 11, 2006 4:36:27 PM


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!
Back to top
drsong
Posted : Sunday, November 12, 2006 4:52:54 PM
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
Back to top
Craig_S
Posted : Sunday, November 12, 2006 8:12:26 PM


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!
Back to top
drsong
Posted : Sunday, November 12, 2006 8:24:39 PM
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
Back to top
Craig_S
Posted : Sunday, November 12, 2006 8:36:47 PM


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!
Back to top
drsong
Posted : Monday, November 13, 2006 6:19:26 AM
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
Back to top
Craig_S
Posted : Monday, November 13, 2006 6:29:03 AM


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!
Back to top
Bruce_L
Posted : Monday, November 13, 2006 5:05:49 PM


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
Back to top
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.