Registered User Joined: 9/30/2011 Posts: 788
|
I would like to have a PCF Formula with the signal on the Securities with the following parameter: crossower two Centered Moving Averagewer (Cicle Indicator - CMA), period 3 - 8 (variable of your choice) .
Reference: https://www.google.it/search?q= (CMA +% 3D + Centered + + Moving Average) & rlz 1C1AOHY_itIT787IT789 = & oq = (CMA +% 3D + Centered + + Moving Average) & aqs = chrome..69i57j0.10731j0j8 & sourceid = chrome & ie = UTF-8
Thank you and goodbye.
Raider45
|
Registered User Joined: 9/30/2011 Posts: 788
|
To better specify the use, I would like the Buy - Sell signals as shown in figures B3 - T3 on the Website: http://hurstcycles.com/using-hurst-dominancy-envelopes/#sthash.5AQNXiVe.dpbs
|
Registered User Joined: 9/30/2011 Posts: 788
|
To avoid confusion, the goal is to have a trading method with Buy - Sell signals on a time cycle that can be modified as required !
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Let's start by writing formulas for periods 3 through 8.
The 3-period centered moving average needs to be offset by -1 when plotted on the chart.
AVGC3
The 4-period centered moving average needs to be offset by -2 when plotted on the chart.
AVG(AVGC3, 2)
The 5-period centered moving average needs to be offset by -2 when plotted on the chart.
AVGC5
The 6-period centered moving average needs to be offset by -3 when plotted on the chart.
AVG(AVGC5, 2)
The 7-period centered moving average needs to be offset by -3 when plotted on the chart.
AVGC7
The 8-period centered moving average needs to be offset by -4 when plotted on the chart.
AVG(AVGC7, 2 )
You need to keep in mind the different offsets when creating crossover formulas. If you wanted to check for the CMA4 crossing up through CMA5, you wouldn't need to do anything because they have the same offset.
XUP(AVG(AVGC3, 2), AVGC5)
But if you wanted to write a formula for the CMA3 crossing down through CMA8, you would need to offset the CMA3 in the formula.
XDOWN(AVGC3.3, AVG(AVGC7, 2))
Note that centered moving averages aren't magic or psychic. You can't actually trade them at the points where they are plotted since they would be using future data in their calculations. It really is just a visualization technique to get the moving average plotted in the center of the data being averaged instead of the end of the data being averaged.
A 32 period centered moving average needs to be offset by -16 when plotted on the chart.
AVG(AVGC31, 2)
A 64 period centered moving average needs to be offset by -32 when plotted on the chart.
AVG(AVGC63, 2)
A 128 period centered moving average needs to be offset by -64 when plotted on the chart.
AVG(AVGC127, 2)
A 256 period centered moving average needs to be offset by -128 when plotted on the chart.
AVG(AVGC255, 2)
There really isn't a way to calculate the Gann's Octave within a formula in such a way that it could be used to create envelopes in TC2000.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 9/30/2011 Posts: 788
|
The formulas do not return signals, only numbers !
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You apparently didn't actually try them all as the 7th and 8th formulas in the above are condition formulas which return signals instead of numeric values as examples.
I am not going to write condition formulas for all 180 possible crossover formulas based on the 10 centered moving averages given the post. Use those two examples to write crossover formulas based on whatever periods you actually want to use instead.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 9/30/2011 Posts: 788
|
The following XDOWN formula (AVGC3.3, AVG (AVGC7, 2) generates an error message: Unmatched Parentheses At position 28
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You need to get rid of the spaces before any of the opening parentheses (not sure if those are getting added when you copy and paste a formula into the forums or what) and add another closing parenthesis to the end.
XDOWN(AVGC3.3, AVG(AVGC7, 2))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 9/30/2011 Posts: 788
|
Mission accomplished successfully, congratulations and thank you !
Sincerely !
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|