Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Request PCF Formula crossower two Centered Moving Averagewer (CMA) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Wednesday, November 28, 2018 9:51:17 AM
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
raider45
Posted : Wednesday, November 28, 2018 10:14:18 AM
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

raider45
Posted : Wednesday, November 28, 2018 10:40:01 AM
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 !

Bruce_L
Posted : Wednesday, November 28, 2018 10:56:58 AM


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
raider45
Posted : Wednesday, November 28, 2018 11:14:20 AM
Registered User
Joined: 9/30/2011
Posts: 788

The formulas do not return signals, only numbers !

Bruce_L
Posted : Wednesday, November 28, 2018 11:30:52 AM


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
raider45
Posted : Wednesday, November 28, 2018 11:51:49 AM
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

Bruce_L
Posted : Wednesday, November 28, 2018 12:01:15 PM


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
raider45
Posted : Wednesday, November 28, 2018 12:13:39 PM
Registered User
Joined: 9/30/2011
Posts: 788
Mission accomplished successfully, congratulations and thank you !
 
Sincerely !
Bruce_L
Posted : Wednesday, November 28, 2018 1:19:51 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.