| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/20/2005
Posts: 79
|
Greetings,
Yet another hair-brained approach...
Is there a way to write a PCF or create a Scan that will pull (or rank) the stocks that have the highest percentage of up days vs down days; say over the last 100 days. I'm not even sure how to approach this, so any ideas you may have would be greatly appreciated.
Thank you,
CB
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Just a count?
For example:
Stock A had 80 up days and 20 down days so the PCF would return 4?
- Craig
Here to Help!
|
|
Registered User
Joined: 10/20/2005
Posts: 79
|
A count would be fine... or any other way that allows we to isolate stocks with a higher ratio of up days to down days. I'm just starting with this so any place to begin is great.
Thanks,
CB
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following should return the number of up days:
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) + (C42 > C43) + (C43 > C44) + (C44 > C45) + (C45 > C46) + (C46 > C47) + (C47 > C48) + (C48 > C49) + (C49 > C50) + (C50 > C51) + (C51 > C52) + (C52 > C53) + (C53 > C54) + (C54 > C55) + (C55 > C56) + (C56 > C57) + (C57 > C58) + (C58 > C59) + (C59 > C60) + (C60 > C61) + (C61 > C62) + (C62 > C63) + (C63 > C64) + (C64 > C65) + (C65 > C66) + (C66 > C67) + (C67 > C68) + (C68 > C69) + (C69 > C70) + (C70 > C71) + (C71 > C72) + (C72 > C73) + (C73 > C74) + (C74 > C75) + (C75 > C76) + (C76 > C77) + (C77 > C78) + (C78 > C79) + (C79 > C80) + (C80 > C81) + (C81 > C82) + (C82 > C83) + (C83 > C84) + (C84 > C85) + (C85 > C86) + (C86 > C87) + (C87 > C88) + (C88 > C89) + (C89 > C90) + (C90 > C91) + (C91 > C92) + (C92 > C93) + (C93 > C94) + (C94 > C95) + (C95 > C96) + (C96 > C97) + (C97 > C98) + (C98 > C99) + (C99 > C100))
The following should return the number of down days:
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) + (C42 < C43) + (C43 < C44) + (C44 < C45) + (C45 < C46) + (C46 < C47) + (C47 < C48) + (C48 < C49) + (C49 < C50) + (C50 < C51) + (C51 < C52) + (C52 < C53) + (C53 < C54) + (C54 < C55) + (C55 < C56) + (C56 < C57) + (C57 < C58) + (C58 < C59) + (C59 < C60) + (C60 < C61) + (C61 < C62) + (C62 < C63) + (C63 < C64) + (C64 < C65) + (C65 < C66) + (C66 < C67) + (C67 < C68) + (C68 < C69) + (C69 < C70) + (C70 < C71) + (C71 < C72) + (C72 < C73) + (C73 < C74) + (C74 < C75) + (C75 < C76) + (C76 < C77) + (C77 < C78) + (C78 < C79) + (C79 < C80) + (C80 < C81) + (C81 < C82) + (C82 < C83) + (C83 < C84) + (C84 < C85) + (C85 < C86) + (C86 < C87) + (C87 < C88) + (C88 < C89) + (C89 < C90) + (C90 < C91) + (C91 < C92) + (C92 < C93) + (C93 < C94) + (C94 < C95) + (C95 < C96) + (C96 < C97) + (C97 < C98) + (C98 < C99) + (C99 < C100))
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/20/2005
Posts: 79
|
Bruce,
Thank you very much for this... and thanks for the great help you have always provided on so many other "challenges".
These look great; again, many thanks!
CB
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. We were happy to help.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |