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 for Modification Trend Intensity Index PCF Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Friday, April 27, 2018 1:47:03 PM
Registered User
Joined: 9/30/2011
Posts: 788
I would like the modification of the following Trend Intensity Intex formula with the signal on period 30 days:
 
30-day TII = (SD +) / ((SD +) + (SD -)) * 100
 
Reference: https://c.mql5.com/forextsd/forum/75/trend_intensity_index_-_m.h.pee.pdf
 
Thank you and goodbye.
 
Raider45
Bruce_L
Posted : Friday, April 27, 2018 2:00:53 PM


Worden Trainer

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

Maybe the following?

100 * ((ABS(C > AVGC30) * (C - AVGC30) - (C1 > AVGC30) * (C1 - AVGC30) - (C2 > AVGC30) * (C2 - AVGC30) - (C3 > AVGC30) * (C3 - AVGC30) - (C4 > AVGC30) * (C4 - AVGC30) - (C5 > AVGC30) * (C5 - AVGC30) - (C6 > AVGC30) * (C6 - AVGC30) - (C7 > AVGC30) * (C7 - AVGC30) - (C8 > AVGC30) * (C8 - AVGC30) - (C9 > AVGC30) * (C9 - AVGC30) - (C10 > AVGC30) * (C10 - AVGC30) - (C11 > AVGC30) * (C11 - AVGC30) - (C12 > AVGC30) * (C12 - AVGC30) - (C13 > AVGC30) * (C13 - AVGC30) - (C14 > AVGC30) * (C14 - AVGC30)) / (ABS(C - AVGC30) + ABS(C1 - AVGC30) + ABS(C2 - AVGC30) + ABS(C3 - AVGC30) + ABS(C4 - AVGC30) + ABS(C5 - AVGC30) + ABS(C6 - AVGC30) + ABS(C7 - AVGC30) + ABS(C8 - AVGC30) + ABS(C9 - AVGC30) + ABS(C10 - AVGC30) + ABS(C11 - AVGC30) + ABS(C12 - AVGC30) + ABS(C13 - AVGC30) + ABS(C14 - AVGC30)))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, April 27, 2018 2:22:06 PM
Registered User
Joined: 9/30/2011
Posts: 788

Congratulations, the formula works very well. Would it be possible to transform it into a PCF Formula with a signal on Crossing Up Value on the zero line with a variable period of your choice?

Bruce_L
Posted : Friday, April 27, 2018 2:26:38 PM


Worden Trainer

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

Crossing up zero is pretty straightforward. Just put the whole thing inside XUP( , 0).

XUP(100 * ((ABS(C > AVGC30) * (C - AVGC30) - (C1 > AVGC30) * (C1 - AVGC30) - (C2 > AVGC30) * (C2 - AVGC30) - (C3 > AVGC30) * (C3 - AVGC30) - (C4 > AVGC30) * (C4 - AVGC30) - (C5 > AVGC30) * (C5 - AVGC30) - (C6 > AVGC30) * (C6 - AVGC30) - (C7 > AVGC30) * (C7 - AVGC30) - (C8 > AVGC30) * (C8 - AVGC30) - (C9 > AVGC30) * (C9 - AVGC30) - (C10 > AVGC30) * (C10 - AVGC30) - (C11 > AVGC30) * (C11 - AVGC30) - (C12 > AVGC30) * (C12 - AVGC30) - (C13 > AVGC30) * (C13 - AVGC30) - (C14 > AVGC30) * (C14 - AVGC30)) / (ABS(C - AVGC30) + ABS(C1 - AVGC30) + ABS(C2 - AVGC30) + ABS(C3 - AVGC30) + ABS(C4 - AVGC30) + ABS(C5 - AVGC30) + ABS(C6 - AVGC30) + ABS(C7 - AVGC30) + ABS(C8 - AVGC30) + ABS(C9 - AVGC30) + ABS(C10 - AVGC30) + ABS(C11 - AVGC30) + ABS(C12 - AVGC30) + ABS(C13 - AVGC30) + ABS(C14 - AVGC30))), 0)

But I am afraid I can't think of a way to make the period easily adjustable.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, April 27, 2018 2:38:28 PM
Registered User
Joined: 9/30/2011
Posts: 788

I copied and pasted the formula but it does not generate any signal !

Bruce_L
Posted : Friday, April 27, 2018 2:40:07 PM


Worden Trainer

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

Oh, yeah, it wouldn't. The indicator runs from 0 to 100. So you would probalby want it to cross up 50, not 0 as requested.

XUP(100 * ((ABS(C > AVGC30) * (C - AVGC30) - (C1 > AVGC30) * (C1 - AVGC30) - (C2 > AVGC30) * (C2 - AVGC30) - (C3 > AVGC30) * (C3 - AVGC30) - (C4 > AVGC30) * (C4 - AVGC30) - (C5 > AVGC30) * (C5 - AVGC30) - (C6 > AVGC30) * (C6 - AVGC30) - (C7 > AVGC30) * (C7 - AVGC30) - (C8 > AVGC30) * (C8 - AVGC30) - (C9 > AVGC30) * (C9 - AVGC30) - (C10 > AVGC30) * (C10 - AVGC30) - (C11 > AVGC30) * (C11 - AVGC30) - (C12 > AVGC30) * (C12 - AVGC30) - (C13 > AVGC30) * (C13 - AVGC30) - (C14 > AVGC30) * (C14 - AVGC30)) / (ABS(C - AVGC30) + ABS(C1 - AVGC30) + ABS(C2 - AVGC30) + ABS(C3 - AVGC30) + ABS(C4 - AVGC30) + ABS(C5 - AVGC30) + ABS(C6 - AVGC30) + ABS(C7 - AVGC30) + ABS(C8 - AVGC30) + ABS(C9 - AVGC30) + ABS(C10 - AVGC30) + ABS(C11 - AVGC30) + ABS(C12 - AVGC30) + ABS(C13 - AVGC30) + ABS(C14 - AVGC30))), 50)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, April 27, 2018 2:42:30 PM
Registered User
Joined: 9/30/2011
Posts: 788

Yes, crossing Up on line 50 !

raider45
Posted : Friday, April 27, 2018 3:05:50 PM
Registered User
Joined: 9/30/2011
Posts: 788
I understood the mechanism, thank you !
 
Best regards !
raider45
Posted : Saturday, April 28, 2018 4:06:38 AM
Registered User
Joined: 9/30/2011
Posts: 788
Yes, I would like the change to highlight only the symbols with the value => 50
 
Thank you and goodbye
 
Raider45
Bruce_L
Posted : Monday, April 30, 2018 10:56:06 AM


Worden Trainer

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

Please try the following condition formula.

100 * ((ABS(C > AVGC30) * (C - AVGC30) - (C1 > AVGC30) * (C1 - AVGC30) - (C2 > AVGC30) * (C2 - AVGC30) - (C3 > AVGC30) * (C3 - AVGC30) - (C4 > AVGC30) * (C4 - AVGC30) - (C5 > AVGC30) * (C5 - AVGC30) - (C6 > AVGC30) * (C6 - AVGC30) - (C7 > AVGC30) * (C7 - AVGC30) - (C8 > AVGC30) * (C8 - AVGC30) - (C9 > AVGC30) * (C9 - AVGC30) - (C10 > AVGC30) * (C10 - AVGC30) - (C11 > AVGC30) * (C11 - AVGC30) - (C12 > AVGC30) * (C12 - AVGC30) - (C13 > AVGC30) * (C13 - AVGC30) - (C14 > AVGC30) * (C14 - AVGC30)) / (ABS(C - AVGC30) + ABS(C1 - AVGC30) + ABS(C2 - AVGC30) + ABS(C3 - AVGC30) + ABS(C4 - AVGC30) + ABS(C5 - AVGC30) + ABS(C6 - AVGC30) + ABS(C7 - AVGC30) + ABS(C8 - AVGC30) + ABS(C9 - AVGC30) + ABS(C10 - AVGC30) + ABS(C11 - AVGC30) + ABS(C12 - AVGC30) + ABS(C13 - AVGC30) + ABS(C14 - AVGC30))) >= 50



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Tuesday, May 1, 2018 4:58:21 AM
Registered User
Joined: 9/30/2011
Posts: 788
Congratulations, the formula works as required, thank you !
 
Best regards                                                                                                                                                                
 
Raider45
Bruce_L
Posted : Tuesday, May 1, 2018 9:20:07 AM


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.