 Gold Customer
Joined: 9/26/2005
Posts: 22
|
Dear Trainer,
Could you please provide the syntax for the following condition.
Close today < moving linear regression average of 125 days
Thanks.
Joginder
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
C < AVGC125 + 62 * (62 * C + 61 * C1 + 60 * C2 + 59 * C3 + 58 * C4 + 57 * C5 + 56 * C6 + 55 * C7 + 54 * C8 + 53 * C9 + 52 * C10 + 51 * C11 + 50 * C12 + 49 * C13 + 48 * C14 + 47 * C15 + 46 * C16 + 45 * C17 + 44 * C18 + 43 * C19 + 42 * C20 + 41 * C21 + 40 * C22 + 39 * C23 + 38 * C24 + 37 * C25 + 36 * C26 + 35 * C27 + 34 * C28 + 33 * C29 + 32 * C30 + 31 * C31 + 30 * C32 + 29 * C33 + 28 * C34 + 27 * C35 + 26 * C36 + 25 * C37 + 24 * C38 + 23 * C39 + 22 * C40 + 21 * C41 + 20 * C42 + 19 * C43 + 18 * C44 + 17 * C45 + 16 * C46 + 15 * C47 + 14 * C48 + 13 * C49 + 12 * C50 + 11 * C51 + 10 * C52 + 9 * C53 + 8 * C54 + 7 * C55 + 6 * C56 + 5 * C57 + 4 * C58 + 3 * C59 + 2 * C60 + C61 - C63 - 2 * C64 - 3 * C65 - 4 * C66 - 5 * C67 - 6 * C68 - 7 * C69 - 8 * C70 - 9 * C71 - 10 * C72 - 11 * C73 - 12 * C74 - 13 * C75 - 14 * C76 - 15 * C77 - 16 * C78 - 17 * C79 - 18 * C80 - 19 * C81 - 20 * C82 - 21 * C83 - 22 * C84 - 23 * C85 - 24 * C86 - 25 * C87 - 26 * C88 - 27 * C89 - 28 * C90 - 29 * C91 - 30 * C92 - 31 * C93 - 32 * C94 - 33 * C95 - 34 * C96 - 35 * C97 - 36 * C98 - 37 * C99 - 38 * C100 - 39 * C101 - 40 * C102 - 41 * C103 - 42 * C104 - 43 * C105 - 44 * C106 - 45 * C107 - 46 * C108 - 47 * C109 - 48 * C110 - 49 * C111 - 50 * C112 - 51 * C113 - 52 * C114 - 53 * C115 - 54 * C116 - 55 * C117 - 56 * C118 - 57 * C119 - 58 * C120 - 59 * C121 - 60 * C122 - 61 * C123 - 62 * C124) / 162750
You may wish to review the following:
Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|