| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/13/2009
Posts: 14
|
Could you show me how to design a PCF that could tell me how many days out of the last two trading months the close was higher than the previous close & the % gain in that period.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (homerhayes) Could you show me how to design a PCF that could tell me how many days out of the last two trading months the close was higher than the previous close...
ABS(C > C1) - (C1 > C2) - (C2 > C3) - (C3 > C4) - (C4 > C5) - (C5 > C6) - (C6 > C7) - (C7 > C8) - (C8 > C9) - (C9 > C10) - (C10 > C11) - (C11 > C12) - (C12 > C13) - (C13 > C14) - (C14 > C15) - (C15 > C16) - (C16 > C17) - (C17 > C18) - (C18 > C19) - (C19 > C20) - (C20 > C21) - (C21 > C22) - (C22 > C23) - (C23 > C24) - (C24 > C25) - (C25 > C26) - (C26 > C27) - (C27 > C28) - (C28 > C29) - (C29 > C30) - (C30 > C31) - (C31 > C32) - (C32 > C33) - (C33 > C34) - (C34 > C35) - (C35 > C36) - (C36 > C37) - (C37 > C38) - (C38 > C39) - (C39 > C40) - (C40 > C41) - (C41 > C42)
QUOTE (homerhayes) ...& the % gain in that period.
100 * (C / C42 - 1)
You may wish to review the following:
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
|
|
Registered User
Joined: 11/13/2009
Posts: 14
|
Bruce;
Thank you very much and the response time was outstanding !!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |