Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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..
|
|
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
|
|
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
|
|
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
|
|
Guest-1 |