Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/28/2005 Posts: 15
|
I am trying to write a PCF that finds stocks that have a TSV20 that is within 5% of the 150 day max and a MS that is also within 5% of the 150 day max. I wrote the following PCF:
TSV20 > .95 * MAX(TSV20,150) AND MS1 > .95 * MAX(MS,150)
However, when I go to test these, I am not sure the values are right, because the numbers on the test symbol chart, particularly for the MS does not approximate the graphical values shown on the indicator scale.
Does this formula appear to be correct? If so, why do the values on the chart (I put MS in the bottom window and TSV in the middle window) not match what they look like they should be?
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
These are both unbounded indicators.... you need to look at them versus their ranges not just the max values.
Create these two PCFs for me:
TSV in Range 100*(TSV20-MIN(TSV20,150))/(MAX(TSV20,150)-MIN(TSV20,150))
MS in Range 100*(MS1-MIN(MS1,150))/(MAX(MS1,150)-MIN(MS1,150))
Add them both to an EasyScan for me.
Set both to VALUES of 95 to MAX.
See if the results are closer to what you wanted.
- Craig Here to Help!
|
|
Registered User Joined: 11/28/2005 Posts: 15
|
Better...there are still a few that visually don't make sense...but it is much better.
THX
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Give me some tickers that don't make sense to you with the above formulas. Let me see if I can explain....
- Craig Here to Help!
|
|
Guest-1 |