Registered User
Joined: 4/29/2011
Posts: 10
|
Looking for formula to find 14.5 Exp stochastic below signal
Yesterday's 17.8.9 MACD above signal and today's 17.8.9 MACD below signal
Thanks,
Luke
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Luke Madsen) Looking for formula to find 14.5 Exp stochastic below signal
Two periods is only enough to define the %K in a full stochastic like what is used in TeleChart 2007 and TC2000 version 12. What is the period of the %D?
Understanding Stochastics
QUOTE (Luke Madsen) Yesterday's 17.8.9 MACD above signal and today's 17.8.9 MACD below signal
While it is more than a tad bit unusual to be subtracting the short moving average from the long moving average, a Condition Formula for an Exponential MACD 17,8 crossing down through its EMA 9 could be written as:
XAVGC17.1 - XAVGC8.1 > XAVG(XAVGC17.1,9) - XAVG(XAVGC8.1,9) AND XAVGC17 - XAVGC8 < XAVG(XAVGC17,9) - XAVG(XAVGC8,9)
Understanding MACD
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
On another note, I would generally suggest just clicking on the indicators and selecting Create Condition than creating a Condition Formula when using TC2000 version 12.
Indicators, Sorting & Scanning
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2011
Posts: 10
|
Sorry, it's a slow stochastic not a full. So it should just be 2 right? Or would it be 14, 5, 0 ?
|
|
Registered User
Joined: 4/29/2011
Posts: 10
|
Also, ran the MACD scan and many of the stocks sho what the MACD crossed signal several days before I want. I'm hoping to catch the MACD crossing today noting that it was above signal yesterday and below signal today. Thoughts?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Luke Madsen) Sorry, it's a slow stochastic not a full. So it should just be 2 right? Or would it be 14, 5, 0 ?
TC2000 version 12 uses a Full Stochastic. The settings for Stochastics available in TC2000 include the Period, %K , %D and Average Types for both the %K and %D. Full Stochastics can be used to reproduce both Fast and Slow Stochastics.
Slow Stochastics
Full Stochastic (x,1,y) = Fast Stochastic (x,y)
Full Stochastic (x,3,y) = Slow Stochastic (x,y)
The 3-Period Moving Average in a Slow Stochastic is specifically a Simple Moving Average. So a 14-Period Slow Stochastic %K being below its Exponential 5-Period %D would be:
STOC14.3 < XAVG(STOC14.3,5)
QUOTE (Luke Madsen) Also, ran the MACD scan and many of the stocks sho what the MACD crossed signal several days before I want. I'm hoping to catch the MACD crossing today noting that it was above signal yesterday and below signal today. Thoughts?
Well in general, I would say that there is an issue with Exponential Moving Averages where WatchList Columns use less data than the charts and don't always match. It is why I suggested clicking on the MACD and selecting Create Condition instead of making a Condition Formula.
That said, I'm not finding an discrepencies after checking maybe a hundred or so charts. The Exponential MACD 17,8 seems to be crossing below its 9-Period Exponential Moving Average today in every case I've checked. Can you provide some specific examples where this is not the case?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2011
Posts: 10
|
If you'rs works and mine doesn't then I may have misstyped part of the formula. Let me check that first. I'm happy to click on the MACD and create a condition as well. I just couldn't find a way to get it to work so assumed I needed to make a Condition Formula.
Luke
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You may also want to make sure the settings on the MACD match. Are the settings for the MACD Short = 17, Long = 8 and Average Type = Exponential? Are the settings for the Exponential Moving Average Period = 9, Offset = 0 and Average Type = Exponential?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/6/2011
Posts: 1
|
I have seen numerous charting packages with indicators allowing “offsets.” I’ve seen it on moving averages, MACD and Stochastics – none has explained it in a coherent “this is why this is used” manner. Can you give me a real world condition where this is useful? Thank you, Larry
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The trainers can't give setting, interpretation or investment advice. I can't tell you why you would want to do something.
Let's say you have a Simple Moving Average. If you were to offset the Moving Average by -(Period - 1) / 2, half of the data used to calculate the Moving Average would be before where the Moving Average is plotted and half the data used to calculated the Moving Average would be after where the Moving Average is plotted. Some think this is how Moving Averages should be plotted. But if you do use a negative offset, realize that you are using future data in calculating the Moving Average. Such averages should never be used to for backtesting based on where they are plotted.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/29/2011
Posts: 10
|
Bruce, I did find my error. The original scan I did was a favorites list. When it didn't produce any results I changed to scan the S&P. However, I assumed by switching to the S&P that those results were scan results. I didn't notice that I had to rerun the scan on the S&P before I got any results. So I was looking at unscanned stocks.
Sorry. Thanks so much for your help!
Luke
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. I am happy to read you were able to figure it out.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/9/2005
Posts: 18
|
Stochastic for a 3 day setting in Version 7. I need help to create a crossing scan for the stochastic 14,5,3 for a 3 day chart. Every method I try does not me the same answer that I get for the stochastic in the pop up box in the top chart where I have put the stochastic.
Rod
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
In version 17 you can find those crossovers just by clicking on the indicator on the chart.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you are plotting the formula on the chart as a Custom PCF Indicator in TC2000 v7, you would use the same formulas as for daily.
A simple stochastic 14,5 SK:
STOC14.5
A simple stochastic 14,5,3 SD:
AVG(STOC14.5, 3)
An exponential stochastic 14,5 SK:
XAVG(STOC14, 5)
An exponential stochastic 14,5,3 SD:
2 * XAVG(STOC14, 5) - XAVG(STOC14, 3)
However if you are trying to create Personal Criteria Formulas to replicate these values, you would need to manually expand the moving averages to account for the time frame being 3 days per bar and the PCF being 1 day per bar.
A 3 day simple stochastic 14,5 SK:
(STOC42 + STOC42.1.3 + STOC42.1.6 + STOC42.1.9 + STOC14.1.12) / 5
A 3 day simple stochastic 14,5,3 SD:
(STOC42 + 2 * STOC42.1.3 + 3 * STOC42.1.6 + 3 * STOC42.1.9 + 3 * STOC42.1.12 + 2 * STOC42.1.15 + STOC42.1.18) / 15
A 3 day exponential stochastic 14,5 SK:
.33355903 * (STOC42 + 2 / 3 * (STOC42.1.3 + 2 / 3 * (STOC42.1.6 + 2 / 3 * (STOC42.1.9 + 2 / 3 * (STOC42.1.12 + 2 / 3 * (STOC42.1.15 + 2 / 3 * (STOC42.1.18 + 2 / 3 * (STOC42.1.21 + 2 / 3 * (STOC42.1.24 + 2 / 3 * (STOC42.1.27 + 2 / 3 * (STOC42.1.30 + 2 / 3 * (STOC42.1.33 + 2 / 3 * (STOC42.1.36 + 2 / 3 * (STOC42.1.39 + 2 / 3 * (STOC42.1.42 + 2 / 3 * (STOC42.1.45 + 2 / 3 * (STOC42.1.48 + 2 / 3 * (STOC42.1.51))))))))))))))))))
A 3 day exponential stochastic 14,5,3 SD:
.66711807 * (STOC42 + 2 / 3 * (STOC42.1.3 + 2 / 3 * (STOC42.1.6 + 2 / 3 * (STOC42.1.9 + 2 / 3 * (STOC42.1.12 + 2 / 3 * (STOC42.1.15 + 2 / 3 * (STOC42.1.18 + 2 / 3 * (STOC42.1.21 + 2 / 3 * (STOC42.1.24 + 2 / 3 * (STOC42.1.27 + 2 / 3 * (STOC42.1.30 + 2 / 3 * (STOC42.1.33 + 2 / 3 * (STOC42.1.36 + 2 / 3 * (STOC42.1.39 + 2 / 3 * (STOC42.1.42 + 2 / 3 * (STOC42.1.45 + 2 / 3 * (STOC42.1.48 + 2 / 3 * (STOC42.1.51)))))))))))))))))) - .50000191 * (STOC42 + .5 * (STOC42.1.3 + .5 * (STOC42.1.6 + .5 * (STOC42.1.9 + .5 * (STOC42.1.12 + .5 * (STOC42.1.15 + .5 * (STOC42.1.18 + .5 * (STOC42.1.21 + .5 * (STOC42.1.24 + .5 * (STOC42.1.27 + .5 * (STOC42.1.30 + .5 * (STOC42.1.33 + .5 * (STOC42.1.36 + .5 * (STOC42.1.39 + .5 * (STOC42.1.42 + .5 * (STOC42.1.45 + .5 * (STOC42.1.48 + .5 * (STOC42.1.51))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/9/2005
Posts: 18
|
Thanks Bruce,
I actually had tried tho simple formulas you wrote. But I did not get an exact match with the pop up box for the 14,5,3. On WLL for 1/24/17 I has a 0.20 discrepancy. But for the 14,5 I have a 1.46 discrepancy.
Rod
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The first two only match if you use them as Custom Indicators on the chart. You need to use the 3 day versions if you want the numbers returned by a PCF (for example in a WatchList Column) to match the 3 day chart because PCFs are always daily in TC2000 v7.
Make sure you have the SD period set to 1 if you are trying to match the numbers of the SK formulas because TC2000 v7 always display the value of the SD when displaying the value of the stochastic.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/9/2005
Posts: 18
|
Bruce,
I did exactly that today and have discrepancies. I copied your formulas into two PCFs yesterday and still have yesterday's charts as I update after the market close. I also yesterday put the Sochastics 14,5,1 and 14,5,3 into the top view. Today I added the columns you suggested. For symbol WLL it shows in the pop up box 82.38 for 14,5,3 and 81.72 for 14,5,1 and in the columns 81.60 for 14,5,3 and 72.33 for 14,5,1. I have no idea what I have done wrong as I copied your formulas with my mouse and double checked everthing. Also I tested the PCFs. At least the SK and SD are still in relative positions.
Rod
|
|
Registered User
Joined: 1/9/2005
Posts: 18
|
Bruce,
I went back and checked again and found you and both made mistakes. I must have copied one formula wrong. Here is yours: In the 3 Day above you had Stoc 42.16 which omited a decimal and should be 42.1.6. Now all is matching.
Thanks for the help.
Rod
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I am happy to read you were able to figure out the issue.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |