| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 6/25/2005
Posts: 441
|
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is a video on plotting the TRIX:
How to plot TRIX - triple exponential average
You can visually sort by it once you plot it:
Create PCFs and EasyScans to find moving average crossovers
Sort by indicator or price movement using Visual Change sorts
Sort by Visual Value to find new highs and lows in price and indicators
- Craig
Here to Help!
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 4,308
|
Check out this training video on plotting the TRIX:
How to plot TRIX - triple exponential average
- Doug
Teaching Online!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
elson2,
You did not specify a Period, so here is a Personal Criteria Formula for a 3-Period TRIX approximation:
100*(125084*C +187625*C1 +187625*C2 +156354*C3 +117266*C4 +82086*C5 +54724*C6 +35180*C7 +21987*C8 +13437*C9 +8062*C10 +4764*C11 +2779*C12 +1603*C13 +916*C14 +508*C15) /(125084*C1 +187625*C2 +187625*C3 +156354*C4 +117266*C5 +82086*C6 +54724*C7 +35180*C8 +21987*C9 +13437*C10 +8062*C11 +4764*C12 +2779*C13 +1603*C14 +916*C15 +508*C16)-100
It is a 1-Period % Rate of Change of a 3-Period EMA of a 3-Period EMA of a 3-Period EMA of Price. If you have a different Period in mind, I'll take a look and write something up if it is short enough to be practical.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/25/2005
Posts: 441
|
THANK YOU VERY MUCH ALL OF YOU
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
The PCF you supplied:
100*(125084*C +187625*C1 +187625*C2 +156354*C3 +117266*C4 +82086*C5 +54724*C6 +35180*C7 +21987*C8 +13437*C9 +8062*C10 +4764*C11 +2779*C12 +1603*C13 +916*C14 +508*C15) /(125084*C1 +187625*C2 +187625*C3 +156354*C4 +117266*C5 +82086*C6 +54724*C7 +35180*C8 +21987*C9 +13437*C10 +8062*C11 +4764*C12 +2779*C13 +1603*C14 +916*C15 +508*C16)-100
is just fine.
Please consider the PCF:
100*((1*2*C0+(2/4)*(2*3*C1+(2/4)*(3*4*C2+(2/4)
*(4*5*C3+(2/4)*(5*6*C4+(2/4)*(6*7*C5+(2/4)
*(7*8*C6+(2/4)*(8*9*C7+(2/4)*(9*10*C8+(2/4)
*(10*11*C9+(2/4)*(11*12*C10+(2/4)*(12*13*C11+(2/4)
*(13*14*C12+(2/4)*(14*15*C13+(2/4)*(15*16*C14+(2/4)
*(16*17*C15))))))))))))))))
/(1*2*C1+(2/4)*(2*3*C2+(2/4)*(3*4*C3+(2/4)
*(4*5*C4+(2/4)*(5*6*C5+(2/4)*(6*7*C6+(2/4)
*(7*8*C7+(2/4)*(8*9*C8+(2/4)*(9*10*C9+(2/4)
*(10*11*C10+(2/4)*(11*12*C11+(2/4)*(12*13*C12+(2/4)
*(13*14*C13+(2/4)*(14*15*C14+(2/4)*(15*16*C15+(2/4)
*(16*17*C16))))))))))))))))-1)
The two return the same values. The factor (2/4) is present because (P-1)/(P+1) = 2/4 when the period P = 3.
The first has fewer characters than the second. The user can use the pattern shown in the second to increase the number of terms and change the period. The reason I am not saying how many terms should be used is because I have not done the necessary derivation.
Your comments would be appreciated.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
I like your Personal Criteria Formula better. I've altered some of my spreadsheets to use nested terms instead of pre-calculating the coefficients, but haven't had time to alter them all (but plan to do so). Sometimes it is just easier and quicker to use what is already available than rewrite the spreadsheet to generate a more optimized version of the formula before posting.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
Bruce,
Thanks for your comments. As always, they are helpful.
I have posted the nested-parentheses form for cascaded EMA's of the same period at:
Cascades of Moving Averages
Hopefully, there are no errors and the results will help you in your endeavor. As you see from my comments there, more analysis remains.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
bustermu,
I've read through the new information. It is always nice to have quality reference material available when writing formulas. I didn't see any errors when I read through it, but if there are, we can always make the appropriate edits.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |