## New version 17 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 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 05, 2018 12:27:13 AM
Gold Customer

Joined: 1/26/2005
Posts: 96

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 05, 2018 9:11:38 AM

Worden Trainer

Joined: 10/7/2004
Posts: 62,196

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 05, 2018 7:13:51 PM
Gold Customer

Joined: 1/26/2005
Posts: 96

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 08, 2018 1:09:07 PM

Worden Trainer

Joined: 10/7/2004
Posts: 62,196

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

Joined: 1/26/2005
Posts: 96

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: 62,196

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 Customer Training & Support - Ask a Trainer - TC2000 version 12/17 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 17 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.