Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 1/31/2005 Posts: 7
|
I WOULD LIKE TO MAKE A PCF IN VER.#11 FOR THE FOLLOWING CONDITIONS:
(CMF 15 PERIOD YESTERDAY) IS NEGATIVE.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
((2 * C1 - L1 - H1) / (H1 - L1 + .00001) * V1 + (2 * C2 - L2 - H2) / (H2 - L2 + .00001) * V2 + (2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15) / (AVGV15.1 * 15) < 0
You may wish to review the following:
Chaikin Money Flow
Chaikin Money Flow Indicator
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: 1/31/2005 Posts: 7
|
QUOTE (Bruce_L) Please try the following:
((2 * C1 - L1 - H1) / (H1 - L1 + .00001) * V1 + (2 * C2 - L2 - H2) / (H2 - L2 + .00001) * V2 + (2 * C3 - L3 - H3) / (H3 - L3 + .00001) * V3 + (2 * C4 - L4 - H4) / (H4 - L4 + .00001) * V4 + (2 * C5 - L5 - H5) / (H5 - L5 + .00001) * V5 + (2 * C6 - L6 - H6) / (H6 - L6 + .00001) * V6 + (2 * C7 - L7 - H7) / (H7 - L7 + .00001) * V7 + (2 * C8 - L8 - H8) / (H8 - L8 + .00001) * V8 + (2 * C9 - L9 - H9) / (H9 - L9 + .00001) * V9 + (2 * C10 - L10 - H10) / (H10 - L10 + .00001) * V10 + (2 * C11 - L11 - H11) / (H11 - L11 + .00001) * V11 + (2 * C12 - L12 - H12) / (H12 - L12 + .00001) * V12 + (2 * C13 - L13 - H13) / (H13 - L13 + .00001) * V13 + (2 * C14 - L14 - H14) / (H14 - L14 + .00001) * V14 + (2 * C15 - L15 - H15) / (H15 - L15 + .00001) * V15) / (AVGV15.1 * 15) < 0
You may wish to review the following:
Chaikin Money Flow
Chaikin Money Flow Indicator
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
|
|
Registered User Joined: 1/31/2005 Posts: 7
|
THANKS, I TYPED THE FORMULA INTO A NEW PCF BUT ALL I GOT WAS "ERROR, ARGUMENT MISSING NEAR * " I ALSO TRIED TO COPY THE FORMULA FROM THE SCREEN AND PASTE IT INTO THE NEW PCF. I COULD PASTE IT INTO MICROSOFT WORD BUT NOT INTO THE PCF? IS THERE ANYWAY TO COPY AND PASTE THE FORMULAS? THANKS, JERRY WILLIAMSON
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
Use:
Copy: Ctrl C
Paste: Ctrl V
Thanks
diceman
|
|
Registered User Joined: 1/31/2005 Posts: 7
|
THANKS, THAT WORKED OUT FINE.
JERRYKIM
|
|
Registered User Joined: 6/11/2009 Posts: 3
|
Hi Bruce,
I copied and pasted the code in TC2000 (version 12.3.4906.16077) in a new criteria formula and got an error. See underneath.
Have you got any clue how I can fix it?
Thank you in advance for your answer.
Greetings,
Douwe.
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
The formula is working fine here. What regional settings are you using in Windows? You might need to use commas , instead of periods . in some spots if you're not using English settings.
|
|
Registered User Joined: 6/11/2009 Posts: 3
|
Thankz, StockGuy! Problem solved!
|
|
Guest-1 |