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

VWMACD closing up through 9EMA...formula isn't working Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jbclem
Posted : Friday, January 5, 2018 12:27:13 AM
Gold Customer Gold Customer

Joined: 1/26/2005
Posts: 113

 I have a WMACD (Sir Tanstaali's version) plotted on a chart, along with a 9 bar exponential moving average of the VWMAC, and I've like to creat a Percent True formula to mark the chart when there is a crossover up though the moving average.  Below is my attempt which isn't working.  Could someone troubleshoot this and show where I've gone wrong. Here I've enclosed the VWMACD formula in parentheses, but I've also tried it without them.

((C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11) * (1 / 12 / AVGV12 - 1 / 26 / AVGV26) - (C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19 + C20 * V20 + C21 * V21 + C22 * V22 + C23 * V23 + C24 * V24 + C25 * V25) / 26 / AVGV26) <= XAVGC9.1 AND  ((C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11) * (1 / 12 / AVGV12 - 1 / 26 / AVGV26) - (C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19 + C20 * V20 + C21 * V21 + C22 * V22 + C23 * V23 + C24 * V24 + C25 * V25) / 26 / AVGV26) > XAVGC9

Thanks for any help,

John

 

Bruce_L
Posted : Friday, January 5, 2018 9:11:38 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

While this could be done in TC2000 v17 or newer.

XUP(SUM(C * V, 12) / SUM(V, 12) - SUM(C * V, 26) / SUM(V, 26), XAVG(SUM(C * V, 12) / SUM(V, 12) - SUM(C * V, 26) / SUM(V, 26) , 9))

I really don't have any good way to write this for TC2000 v7. The formula for the 9 period exponential moving average of the VWMACD would be more than 30 times longer than the base formula for the VWWACD.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jbclem
Posted : Friday, January 5, 2018 7:13:51 PM
Gold Customer Gold Customer

Joined: 1/26/2005
Posts: 113

I see my mistake, I was using the 9 period exponential moving average of the Close, not of the VWMACD.  What a pity that it's so hard to do this in v7 since that's the version I use and like the most..

Bruce_L
Posted : Monday, January 8, 2018 1:09:07 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

TC2000 v7 will unfortunately not be getting the new PCF syntax.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jbclem
Posted : Wednesday, January 10, 2018 5:05:18 PM
Gold Customer Gold Customer

Joined: 1/26/2005
Posts: 113

Bruce, I'm curious to know why there is so little attention paid to v7 and improving it (as in updating the pcf syntax).  Are there so few people using v7 that it's just not worth it, or is there some other reason.

What is the population of v7 users compared to the later versions users?

 

John

Bruce_L
Posted : Thursday, January 11, 2018 8:42:12 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

TC2000 v7 gets so little attention because it is no longer in development and has not been for more than ten years. It will not get any new features and will only get bug fixes for major issues. While we still offer the progarm for those that want, we do not advertise TC2000 v7 at all.

TC2000 is a privately held company and we do not discuss our subscriber figures.



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