| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/10/2013 Posts: 41
|
Do you know how to write this in a formula so I can use it in Easy Scan.
Thanks, Aubrey
|
|
 Administration
Joined: 9/30/2004 Posts: 9,187
|
If you add the indicator to your chart, you can click on its name and select Create Scan Condition.
|
|
 Administration
Joined: 9/30/2004 Posts: 9,187
|
The formula the sum of the short and long ROC periods is rather simple:
((C - C11) / (C11) + (C - C14) / (C14)) * 100
But the formula to get the front-weighted moving average of the result will really long, even using the default period of 10. If you can't get what you need by creating a scan condition from the indicator on the chart let me know and I'll work on the long formula.
|
|
Registered User Joined: 3/10/2013 Posts: 41
|
Can you please tell me how I would write a PCF for the coppock. What I need is the daliy Coppock (11,14,10) to be greater than 0 and the weekly coppock (55,70,50) cross the zero line.
I can do this in a scan but prefer for this condition to be part of a colum.
Thanks.
|
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It is not possible to mix daily and weekly time frames in a single Personal Criteria Formula in TC2000 version 12.3, so you would still end up having to create an EasyScan and not be able to create a WatchList Column.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2013 Posts: 41
|
Bruce,
I hope this makes sense but I have taken the Coppock daily formula and multiplied by 5 to get a longer term formual - both coppock are still on a daily basis, but one is longer. Thanks
|
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I don't know that it has anything to do with a Weekly Coppock Curve (11,14,10), but a Condition Formula for a Daily Coppock Curve (11,14,10) being above zero when the Daily Coppock Curve (55,70,50) is crossing through zero in either direction can be written as:
10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) + 8 * (C2 / C16 + C2 / C13) + 7 * (C3 / C17 + C3 / C14) + 6 * (C4 / C18 + C4 / C15) + 5 * (C5 / C19 + C5 / C16) + 4 * (C6 / C20 + C6 / C17) + 3 * (C7 / C21 + C7 / C18) + 2 * (C8 / C22 + C8 / C19) + (C9 / C23 + C9 / C20) > 110 AND SGN(50 * (C / C55 + C / C70) + 49 * (C1 / C56 + C1 / C71) + 48 * (C2 / C57 + C2 / C72) + 47 * (C3 / C58 + C3 / C73) + 46 * (C4 / C59 + C4 / C74) + 45 * (C5 / C60 + C5 / C75) + 44 * (C6 / C61 + C6 / C76) + 43 * (C7 / C62 + C7 / C77) + 42 * (C8 / C63 + C8 / C78) + 41 * (C9 / C64 + C9 / C79) + 40 * (C10 / C65 + C10 / C80) + 39 * (C11 / C66 + C11 / C81) + 38 * (C12 / C67 + C12 / C82) + 37 * (C13 / C68 + C13 / C83) + 36 * (C14 / C69 + C14 / C84) + 35 * (C15 / C70 + C15 / C85) + 34 * (C16 / C71 + C16 / C86) + 33 * (C17 / C72 + C17 / C87) + 32 * (C18 / C73 + C18 / C88) + 31 * (C19 / C74 + C19 / C89) + 30 * (C20 / C75 + C20 / C90) + 29 * (C21 / C76 + C21 / C91) + 28 * (C22 / C77 + C22 / C92) + 27 * (C23 / C78 + C23 / C93) + 26 * (C24 / C79 + C24 / C94) + 25 * (C25 / C80 + C25 / C95) + 24 * (C26 / C81 + C26 / C96) + 23 * (C27 / C82 + C27 / C97) + 22 * (C28 / C83 + C28 / C98) + 21 * (C29 / C84 + C29 / C99) + 20 * (C30 / C85 + C30 / C100) + 19 * (C31 / C86 + C31 / C101) + 18 * (C32 / C87 + C32 / C102) + 17 * (C33 / C88 + C33 / C103) + 16 * (C34 / C89 + C34 / C104) + 15 * (C35 / C90 + C35 / C105) + 14 * (C36 / C91 + C36 / C106) + 13 * (C37 / C92 + C37 / C107) + 12 * (C38 / C93 + C38 / C108) + 11 * (C39 / C94 + C39 / C109) + 10 * (C40 / C95 + C40 / C110) + 9 * (C41 / C96 + C41 / C111) + 8 * (C42 / C97 + C42 / C112) + 7 * (C43 / C98 + C43 / C113) + 6 * (C44 / C99 + C44 / C114) + 5 * (C45 / C100 + C45 / C115) + 4 * (C46 / C101 + C46 / C116) + 3 * (C47 / C102 + C47 / C117) + 2 * (C48 / C103 + C48 / C118) + C49 / C104 + C49 / C119 - 2550) <> SGN(50 * (C1 / C56 + C1 / C71) + 49 * (C2 / C57 + C2 / C72) + 48 * (C3 / C58 + C3 / C73) + 47 * (C4 / C59 + C4 / C74) + 46 * (C5 / C60 + C5 / C75) + 45 * (C6 / C61 + C6 / C76) + 44 * (C7 / C62 + C7 / C77) + 43 * (C8 / C63 + C8 / C78) + 42 * (C9 / C64 + C9 / C79) + 41 * (C10 / C65 + C10 / C80) + 40 * (C11 / C66 + C11 / C81) + 39 * (C12 / C67 + C12 / C82) + 38 * (C13 / C68 + C13 / C83) + 37 * (C14 / C69 + C14 / C84) + 36 * (C15 / C70 + C15 / C85) + 35 * (C16 / C71 + C16 / C86) + 34 * (C17 / C72 + C17 / C87) + 33 * (C18 / C73 + C18 / C88) + 32 * (C19 / C74 + C19 / C89) + 31 * (C20 / C75 + C20 / C90) + 30 * (C21 / C76 + C21 / C91) + 29 * (C22 / C77 + C22 / C92) + 28 * (C23 / C78 + C23 / C93) + 27 * (C24 / C79 + C24 / C94) + 26 * (C25 / C80 + C25 / C95) + 25 * (C26 / C81 + C26 / C96) + 24 * (C27 / C82 + C27 / C97) + 23 * (C28 / C83 + C28 / C98) + 22 * (C29 / C84 + C29 / C99) + 21 * (C30 / C85 + C30 / C100) + 20 * (C31 / C86 + C31 / C101) + 19 * (C32 / C87 + C32 / C102) + 18 * (C33 / C88 + C33 / C103) + 17 * (C34 / C89 + C34 / C104) + 16 * (C35 / C90 + C35 / C105) + 15 * (C36 / C91 + C36 / C106) + 14 * (C37 / C92 + C37 / C107) + 13 * (C38 / C93 + C38 / C108) + 12 * (C39 / C94 + C39 / C109) + 11 * (C40 / C95 + C40 / C110) + 10 * (C41 / C96 + C41 / C111) + 9 * (C42 / C97 + C42 / C112) + 8 * (C43 / C98 + C43 / C113) + 7 * (C44 / C99 + C44 / C114) + 6 * (C45 / C100 + C45 / C115) + 5 * (C46 / C101 + C46 / C116) + 4 * (C47 / C102 + C47 / C117) + 3 * (C48 / C103 + C48 / C118) + 2 * (C49 / C104 + C49 / C119) + C50 / C105 + C50 / C120 - 2550)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/10/2013 Posts: 41
|
Thanks for your help.
|
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
|
Guest-1 |