Registered User
Joined: 12/16/2007
Posts: 6
|
I need to build a .PCF where the 20-day MA of the Close*Volume of a stock is greater than the (65-day MA of theClose*Volume of SP500) times .000003.
Can you help me with this?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I really can't provide much assistance in TeleChart as the Personal Criteria Formula Language does not have syntax for referencing other symbols (StockFinder has mechanisms for making these types of comparisons). You may wish to review the following for a semi-automated technique for referencing another symbol in a Personal Criteria Formula:
Indexes in PCF's
RSMA PCFs
A formula for the 20-Period Moving Average of the Close times Volume would be:
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11 + C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19) / 20
A formula for the 65-Period Moving Average of the Close times Volume would be:
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11 + 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 + C26 * V26 + C27 * V27 + C28 * V28 + C29 * V29 + C30 * V30 + C31 * V31 + C32 * V32 + C33 * V33 + C34 * V34 + C35 * V35 + C36 * V36 + C37 * V37 + C38 * V38 + C39 * V39 + C40 * V40 + C41 * V41 + C42 * V42 + C43 * V43 + C44 * V44 + C45 * V45 + C46 * V46 + C47 * V47 + C48 * V48 + C49 * V49 + C50 * V50 + C51 * V51 + C52 * V52 + C53 * V53 + C54 * V54 + C55 * V55 + C56 * V56 + C57 * V57 + C58 * V58 + C59 * V59 + C60 * V60 + C61 * V61 + C62 * V62 + C63 * V63 + C64 * V64) / 65
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
|