Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 2/23/2006 Posts: 20
|
Below is a PCF for the CCI below -100. What would I need to add to make a PFC that says that "the CCI was below -100 yesterday and above the -100 today"?
CCI below -100 (H + L + C - AVGH20 - AVGL20 - AVGC20) * 4000 / 3 / (ABS(H + L + C - AVGH20 - AVGL20 - AVGC20) + ABS(H1 + L1 + C1 - AVGH20 - AVGL20 - AVGC20) + ABS(H2 + L2 + C2 - AVGH20 - AVGL20 - AVGC20) + ABS(H3 + L3 + C3 - AVGH20 - AVGL20 - AVGC20) + ABS(H4 + L4 + C4 - AVGH20 - AVGL20 - AVGC20) + ABS(H5 + L5 + C5 - AVGH20 - AVGL20 - AVGC20) + ABS(H6 + L6 + C6 - AVGH20 - AVGL20 - AVGC20) + ABS(H7 + L7 + C7 - AVGH20 - AVGL20 - AVGC20) + ABS(H8 + L8 + C8 - AVGH20 - AVGL20 - AVGC20) + ABS(H9 + L9 + C9 - AVGH20 - AVGL20 - AVGC20) + ABS(H10 + L10 + C10 - AVGH20 - AVGL20 - AVGC20) + ABS(H11 + L11 + C11 - AVGH20 - AVGL20 - AVGC20) + ABS(H12 + L12 + C12 - AVGH20 - AVGL20 - AVGC20) + ABS(H13 + L13 + C13 - AVGH20 - AVGL20 - AVGC20) + ABS(H14 + L14 + C14 - AVGH20 - AVGL20 - AVGC20) + ABS(H15 + L15 + C15 - AVGH20 - AVGL20 - AVGC20) + ABS(H16 + L16 + C16 - AVGH20 - AVGL20 - AVGC20) + ABS(H17 + L17 + C17 - AVGH20 - AVGL20 - AVGC20) + ABS(H18 + L18 + C18 - AVGH20 - AVGL20 - AVGC20) + ABS(H19 + L19 + C19 - AVGH20 - AVGL20 - AVGC20) + .00001) < ( - 100)
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Change this PCF into on for the CCI yesterday below (-100) by changing all of the
H to H1 L to L1 C to C1 add .1 to all of the AVGx20 (example AVGL20.1)
Add one value to each Hx Lx and Cx so
H2 becomes H3 L4 becomes L5 etc.
Then create another PCF for the CCI today being above (-100). Use the one above by change the < to a >
- Craig Here to Help!
|
|
Registered User Joined: 2/23/2006 Posts: 20
|
Does this look correct for CCI yesterday below -100?
(H1 + L1 + C1 - AVGH20.1 - AVGL20.1 - AVGC20.1) * 4000 / 3 / (ABS(H1 + L1 + C1 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H2 + L2 + C2 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H3 + L3 + C3 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H4 + L4 + C4 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H5 + L5 + C5 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H6 + L6 + C6 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H7 + L7 + C7 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H8 + L8 + C8 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H9 + L9 + C9 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H10 + L10 + C10 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H11 + L11 + C11 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H12 + L12 + C12 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H13 + L13 + C13 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H14 + L14+ C14 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H15 + L15 + C15 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H16 + L16 + C16 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H17 + L17 + C17 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H18 + L18 + C18 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H19 + L19 + C19 - AVGH20.1 - AVGL20.1 - AVGC20.1) + ABS(H20 + L20 + C20 - AVGH20.1 - AVGL20.1 - AVGC20.1) + .00001) < ( - 100)
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
It does. Now create one for today being above then add them both to the same EasyScan.
- Craig Here to Help!
|
|
Registered User Joined: 2/23/2006 Posts: 20
|
Worked great thanks
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Glad to hear it. Let me know if you need anything else. You know where to find me!
- Craig Here to Help!
|
|
Registered User Joined: 2/23/2006 Posts: 20
|
Now if I wanted to do the +100 side. What would I need to change to have a PCF that says "the CCI was above +100 yesterday and below the +100 today"?
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Here is what I would do.
On both PCFs drop the <(-100) and >X (-100) parts
Now the will return the values of the CCI those days instead of TRUE or FALSE.
When you put the PCFs in EasyScan you can use the condition type VALUE to limit the range of one to -100 to MAX and the other to MIN to -100...
You can then reuse the same PCFs in a second scan and flip the ranges selected.
Make sense?
- Craig Here to Help!
|
|
Registered User Joined: 2/23/2006 Posts: 20
|
Yes, Will try. Thanks
|
|
Guest-1 |