| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/30/2005
Posts: 10
|
I am using a Simple Stoc. 15.5.5 on a weekly chart. I can visually see that the indicator has dropped below 20 (on some stocks) and when I right click on the Stochastics 15,5,5 label in the bottom window, the Indicator Sort Properties dialog box opens up. I select the Actual Value in the Sort Settings box and then select Sort. A Sort Value column is populated with all of the Actual Values of the stocks in the Watchlist. So far, so good.
Now I'm trying to write a PCF that will reflect anything that is below 20 and I am using the following PCF (after perusing your website for converting stochastics to weekly) and it is indicating that nothing qualifies, yet I can see that when I scroll down to the bottom of the watchlist there are candidates that are definitely below 20. So my question is, shouldn't the PCF's produce the same actual values as the simple point and click sort on the screen?
Here is what I'm using for a PCF: ((STOC75 + 2 * STOC75.1.5 + 3 * STOC75.1.10 + 4 * STOC75.1.15 + 5 * STOC75.1.20 + 4 * STOC75.1.25 + 3 * STOC75.1.30 + 2 * STOC75.1.35 + STOC75.1.40) / 25) <= 20
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm updated through 06:29 PM ET (Data delayed at least 20 min).
Your formula currently returns True for 1013 symbols in the All Items in System Watchlist on my computer.
The results also seem to match the SD on a Stochastic on a Weekly chart with the following settings (I have the formula both with and with the <= 20 portion set up):
Period: 15
SK Period: 5
SD Period: 5
Average Type: Simple
While the match is not as close, you can get a fairly decent approximation of the a Stochastic SD with the following settings on a Weekly chart:
Period: 15
SK Period: 5
SD Period: 5
Average Type: Exponential
Using the following formula instead:
.11119698203496 * (STOC75 + 2 / 3 * (2 * STOC75.1.5 + 2 / 3 * (3 * STOC75.1.10 + 2 / 3 * (4 * STOC75.1.15 + 2 / 3 * (5 * STOC75.1.20 + 2 / 3 * (6 * STOC75.1.25 + 2 / 3 * (7 * STOC75.1.30 + 2 / 3 * (8 * STOC75.1.35 + 2 / 3 * (9 * STOC75.1.40 + 2 / 3 * (10 * STOC75.1.45 + 2 / 3 * (11 * STOC75.1.50 + 2 / 3 * (12 * STOC75.1.55 + 2 / 3 * (13 * STOC75.1.60 + 2 / 3 * (14 * STOC75.1.65 + 2 / 3 * (15 * STOC75.1.70 + 2 / 3 * (16 * STOC75.1.75 + 2 / 3 * (17 * STOC75.1.80 + 2 / 3 * (18 * STOC75.1.85 + 2 / 3 * (19 * STOC75.1.90 + 2 / 3 * (20 * STOC75.1.95 + 2 / 3 * (21 * STOC75.1.100 + 2 / 3 * (22 * STOC75.1.105 + 2 / 3 * (23 * STOC75.1.110)))))))))))))))))))))))
Could you provide some example symbols where the Personal Criteria Formula results do not match the chart (and Indicator Sort)?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/30/2005
Posts: 10
|
Sure. An example of two today (6/25/07 as of the close) would be LEA (Lear Corp.) and FIG (Fortress Investment Co.) where the Watchlist Sort Value was 14.24 and 0.00 respectively (on the weekly chart) and when I ran the PCF (the one in my initial post) it indicated that these stocks did not make the cut.
|
|
Registered User
Joined: 1/30/2005
Posts: 10
|
I also implemented your new formula and it still did not pick up the two mentioned stocks.
Since FIG doesn't have much of a data history, it may not be a good example, but LEA certainly has enough data history and its on screen indicator is visually below 20.
Are you "seeing" the same thing?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the formula for the Simple Weekly SK instead of the SD formula used above (FIG will not return True because there isn't enough data to do the calculations):
(STOC75 + STOC75.1.5 + STOC75.1.10 + STOC75.1.15 + STOC75.1.20) / 5 <= 20
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/30/2005
Posts: 10
|
Aha!! That one finally worked.
I knew there had to be a solution. Thank you for your efforts in resolving this.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |