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 |

PCF for Trend Intensity Index (TII) ? Topic Rating:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jdong5801
Posted : Monday, October 25, 2010 12:21:02 AM
Gold Customer Gold Customer

Joined: 1/15/2009
Posts: 5
Is there any pcf for the trend intensity index (TII), developed by M. H. Pee ? The original article was published in June 2002 Technical Analysis of Stocks & Commodities magazine. Thanks. He also developed the Trend Detection Index and published in Oct 2001 TASC.
Bruce_L
Posted : Monday, October 25, 2010 1:50:42 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'm not positive as I do not have access to the original article, but I think it should be something like the following:

100 * (ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60.1) * (C1 - AVGC60.1) - (C2 > AVGC60.2) * (C2 - AVGC60.2) - (C3 > AVGC60.3) * (C3 - AVGC60.3) - (C4 > AVGC60.4) * (C4 - AVGC60.4) - (C5 > AVGC60.5) * (C5 - AVGC60.5) - (C6 > AVGC60.6) * (C6 - AVGC60.6) - (C7 > AVGC60.7) * (C7 - AVGC60.7) - (C8 > AVGC60.8) * (C8 - AVGC60.8) - (C9 > AVGC60.9) * (C9 - AVGC60.9) - (C10 > AVGC60.10) * (C10 - AVGC60.10) - (C11 > AVGC60.11) * (C11 - AVGC60.11) - (C12 > AVGC60.12) * (C12 - AVGC60.12) - (C13 > AVGC60.13) * (C13 - AVGC60.13) - (C14 > AVGC60.14) * (C14 - AVGC60.14) - (C15 > AVGC60.15) * (C15 - AVGC60.15) - (C16 > AVGC60.16) * (C16 - AVGC60.16) - (C17 > AVGC60.17) * (C17 - AVGC60.17) - (C18 > AVGC60.18) * (C18 - AVGC60.18) - (C19 > AVGC60.19) * (C19 - AVGC60.19) - (C20 > AVGC60.20) * (C20 - AVGC60.20) - (C21 > AVGC60.21) * (C21 - AVGC60.21) - (C22 > AVGC60.22) * (C22 - AVGC60.22) - (C23 > AVGC60.23) * (C23 - AVGC60.23) - (C24 > AVGC60.24) * (C24 - AVGC60.24) - (C25 > AVGC60.25) * (C25 - AVGC60.25) - (C26 > AVGC60.26) * (C26 - AVGC60.26) - (C27 > AVGC60.27) * (C27 - AVGC60.27) - (C28 > AVGC60.28) * (C28 - AVGC60.28) - (C29 > AVGC60.29) * (C29 - AVGC60.29)) / (ABS(C - AVGC60) + ABS(C1 - AVGC60.1) + ABS(C2 - AVGC60.2) + ABS(C3 - AVGC60.3) + ABS(C4 - AVGC60.4) + ABS(C5 - AVGC60.5) + ABS(C6 - AVGC60.6) + ABS(C7 - AVGC60.7) + ABS(C8 - AVGC60.8) + ABS(C9 - AVGC60.9) + ABS(C10 - AVGC60.10) + ABS(C11 - AVGC60.11) + ABS(C12 - AVGC60.12) + ABS(C13 - AVGC60.13) + ABS(C14 - AVGC60.14) + ABS(C15 - AVGC60.15) + ABS(C16 - AVGC60.16) + ABS(C17 - AVGC60.17) + ABS(C18 - AVGC60.18) + ABS(C19 - AVGC60.19) + ABS(C20 - AVGC60.20) + ABS(C21 - AVGC60.21) + ABS(C22 - AVGC60.22) + ABS(C23 - AVGC60.23) + ABS(C24 - AVGC60.24) + ABS(C25 - AVGC60.25) + ABS(C26 - AVGC60.26) + ABS(C27 - AVGC60.27) + ABS(C28 - AVGC60.28) + ABS(C29 - AVGC60.29))

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donbetman
Posted : Tuesday, October 26, 2010 1:45:25 PM
Registered User
Joined: 12/15/2009
Posts: 91
Hi Bruce,

Using a major period of 60 bars and a minor of 30, closing price and a simple smoothing avg:

TII = 100 * (SDPOS) / (SDPOS + SDNEG)

 SDPOS = Sum of Up Deviations Over Minor Period (CL - MA)
 SDNEG = Sum of Down Deviations Over Minor Period (MA - CL)

Is this formula above what your pcf represents?  I get numbers returned that are seem too high.  Thanks for your assistance in advance.

Don

Bruce_L
Posted : Tuesday, October 26, 2010 2:14:09 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
To a great extent I can't say if that is what the PCF represents or not. If I am understanding the deviations definition correctly, then yes, it is exactly what it represents however.

That said, it is quite possibly that my understanding is not correct. For example, I'm comparing the Price over the last 30-Bars to the 60-Period Simple Moving Average at the time to get (SDPOS):

(ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60.1) * (C1 - AVGC60.1) - (C2 > AVGC60.2) * (C2 - AVGC60.2) - (C3 > AVGC60.3) * (C3 - AVGC60.3) - (C4 > AVGC60.4) * (C4 - AVGC60.4) - (C5 > AVGC60.5) * (C5 - AVGC60.5) - (C6 > AVGC60.6) * (C6 - AVGC60.6) - (C7 > AVGC60.7) * (C7 - AVGC60.7) - (C8 > AVGC60.8) * (C8 - AVGC60.8) - (C9 > AVGC60.9) * (C9 - AVGC60.9) - (C10 > AVGC60.10) * (C10 - AVGC60.10) - (C11 > AVGC60.11) * (C11 - AVGC60.11) - (C12 > AVGC60.12) * (C12 - AVGC60.12) - (C13 > AVGC60.13) * (C13 - AVGC60.13) - (C14 > AVGC60.14) * (C14 - AVGC60.14) - (C15 > AVGC60.15) * (C15 - AVGC60.15) - (C16 > AVGC60.16) * (C16 - AVGC60.16) - (C17 > AVGC60.17) * (C17 - AVGC60.17) - (C18 > AVGC60.18) * (C18 - AVGC60.18) - (C19 > AVGC60.19) * (C19 - AVGC60.19) - (C20 > AVGC60.20) * (C20 - AVGC60.20) - (C21 > AVGC60.21) * (C21 - AVGC60.21) - (C22 > AVGC60.22) * (C22 - AVGC60.22) - (C23 > AVGC60.23) * (C23 - AVGC60.23) - (C24 > AVGC60.24) * (C24 - AVGC60.24) - (C25 > AVGC60.25) * (C25 - AVGC60.25) - (C26 > AVGC60.26) * (C26 - AVGC60.26) - (C27 > AVGC60.27) * (C27 - AVGC60.27) - (C28 > AVGC60.28) * (C28 - AVGC60.28) - (C29 > AVGC60.29) * (C29 - AVGC60.29))

But if the Prices of the last 30-Bars need to be compared to the current 60-Period Simple Moving Average instead, then the (SDPOS) portion of the formula would be a bit shorter:

(ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60) * (C1 - AVGC60) - (C2 > AVGC60) * (C2 - AVGC60) - (C3 > AVGC60) * (C3 - AVGC60) - (C4 > AVGC60) * (C4 - AVGC60) - (C5 > AVGC60) * (C5 - AVGC60) - (C6 > AVGC60) * (C6 - AVGC60) - (C7 > AVGC60) * (C7 - AVGC60) - (C8 > AVGC60) * (C8 - AVGC60) - (C9 > AVGC60) * (C9 - AVGC60) - (C10 > AVGC60) * (C10 - AVGC60) - (C11 > AVGC60) * (C11 - AVGC60) - (C12 > AVGC60) * (C12 - AVGC60) - (C13 > AVGC60) * (C13 - AVGC60) - (C14 > AVGC60) * (C14 - AVGC60) - (C15 > AVGC60) * (C15 - AVGC60) - (C16 > AVGC60) * (C16 - AVGC60) - (C17 > AVGC60) * (C17 - AVGC60) - (C18 > AVGC60) * (C18 - AVGC60) - (C19 > AVGC60) * (C19 - AVGC60) - (C20 > AVGC60) * (C20 - AVGC60) - (C21 > AVGC60) * (C21 - AVGC60) - (C22 > AVGC60) * (C22 - AVGC60) - (C23 > AVGC60) * (C23 - AVGC60) - (C24 > AVGC60) * (C24 - AVGC60) - (C25 > AVGC60) * (C25 - AVGC60) - (C26 > AVGC60) * (C26 - AVGC60) - (C27 > AVGC60) * (C27 - AVGC60) - (C28 > AVGC60) * (C28 - AVGC60) - (C29 > AVGC60) * (C29 - AVGC60))

The (SDPOS + SDNEG) portion:

(ABS(C - AVGC60) + ABS(C1 - AVGC60.1) + ABS(C2 - AVGC60.2) + ABS(C3 - AVGC60.3) + ABS(C4 - AVGC60.4) + ABS(C5 - AVGC60.5) + ABS(C6 - AVGC60.6) + ABS(C7 - AVGC60.7) + ABS(C8 - AVGC60.8) + ABS(C9 - AVGC60.9) + ABS(C10 - AVGC60.10) + ABS(C11 - AVGC60.11) + ABS(C12 - AVGC60.12) + ABS(C13 - AVGC60.13) + ABS(C14 - AVGC60.14) + ABS(C15 - AVGC60.15) + ABS(C16 - AVGC60.16) + ABS(C17 - AVGC60.17) + ABS(C18 - AVGC60.18) + ABS(C19 - AVGC60.19) + ABS(C20 - AVGC60.20) + ABS(C21 - AVGC60.21) + ABS(C22 - AVGC60.22) + ABS(C23 - AVGC60.23) + ABS(C24 - AVGC60.24) + ABS(C25 - AVGC60.25) + ABS(C26 - AVGC60.26) + ABS(C27 - AVGC60.27) + ABS(C28 - AVGC60.28) + ABS(C29 - AVGC60.29))

Would be slightly shorter as well:

(ABS(C - AVGC60) + ABS(C1 - AVGC60) + ABS(C2 - AVGC60) + ABS(C3 - AVGC60) + ABS(C4 - AVGC60) + ABS(C5 - AVGC60) + ABS(C6 - AVGC60) + ABS(C7 - AVGC60) + ABS(C8 - AVGC60) + ABS(C9 - AVGC60) + ABS(C10 - AVGC60) + ABS(C11 - AVGC60) + ABS(C12 - AVGC60) + ABS(C13 - AVGC60) + ABS(C14 - AVGC60) + ABS(C15 - AVGC60) + ABS(C16 - AVGC60) + ABS(C17 - AVGC60) + ABS(C18 - AVGC60) + ABS(C19 - AVGC60) + ABS(C20 - AVGC60) + ABS(C21 - AVGC60) + ABS(C22 - AVGC60) + ABS(C23 - AVGC60) + ABS(C24 - AVGC60) + ABS(C25 - AVGC60) + ABS(C26 - AVGC60) + ABS(C27 - AVGC60) + ABS(C28 - AVGC60) + ABS(C29 - AVGC60))

What makes you think the values are too high? They seem to run from 0 to 100 as would be expected. Do you have a source against which you are making a comparison?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donbetman
Posted : Tuesday, October 26, 2010 2:21:38 PM
Registered User
Joined: 12/15/2009
Posts: 91

Not scientific but I used half a dozen symbols as the test one and all came back 85 to 100.  I used ones I would consider in less strength of an uptrend than what I comprehend the number should be.  Let me do a little more research and get back to this.  Thx.

Bruce_L
Posted : Tuesday, October 26, 2010 2:31:21 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Thanks. I'd appreciate more information so I can get it correct if my current interpretation of what I've found is wrong.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
diceman
Posted : Tuesday, October 26, 2010 2:46:22 PM
Registered User
Joined: 1/28/2005
Posts: 6,049

inputs:
 AvgLength( 60 ),
 DevCalcLength( 30 ) ;
variables:
 Avg( 0 ),
 SDPlus( 0 ),
 SDMinus( 0 ),
 Dev( 0 ),
 Offset( 0 ),
 TII( 0 ) ;


Avg = Average( Close, AvgLength ) ;
SDPlus = 0 ;
SDMinus = 0 ;

for Offset = 0 to DevCalcLength - 1
 begin
 Dev = Close[Offset] - Avg ;
 if Dev > 0 then
  SDPlus = SDPlus + Dev
 else
  SDMinus = SDMinus - Dev ;
 end ;


TII = SDPlus / ( SDPlus + SDMinus ) * 100 ;

Plot1(TII,"TrendInten");

=============================================

Dont know if this helps but its TradeStaton Code for the indicator.


Thanks
diceman

Bruce_L
Posted : Tuesday, October 26, 2010 2:48:30 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Thanks diceman. It doesn't help me, but it might help somebody else that is reading the topic figure it out.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
diceman
Posted : Tuesday, October 26, 2010 4:09:05 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
As far as  can I tell this seems to be correct.

Notice in the TS code:

 Dev = Close[Offset] - Avg

The close has an offset but not the average.(all calc is with todays average)

I joined Bruce's other parts:

"But if the Prices of the last 30-Bars need to be compared to the current 60-Period Simple Moving Average instead, then the (SDPOS) portion of the formula would be a bit shorter:

(ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60) * (C1 - AVGC60) - (C2 > AVGC60) * (C2 - AVGC60) - (C3 > AVGC60) * (C3 - AVGC60) - (C4 > AVGC60) * (C4 - AVGC60) - (C5 > AVGC60) * (C5 - AVGC60) - (C6 > AVGC60) * (C6 - AVGC60) - (C7 > AVGC60) * (C7 - AVGC60) - (C8 > AVGC60) * (C8 - AVGC60) - (C9 > AVGC60) * (C9 - AVGC60) - (C10 > AVGC60) * (C10 - AVGC60) - (C11 > AVGC60) * (C11 - AVGC60) - (C12 > AVGC60) * (C12 - AVGC60) - (C13 > AVGC60) * (C13 - AVGC60) - (C14 > AVGC60) * (C14 - AVGC60) - (C15 > AVGC60) * (C15 - AVGC60) - (C16 > AVGC60) * (C16 - AVGC60) - (C17 > AVGC60) * (C17 - AVGC60) - (C18 > AVGC60) * (C18 - AVGC60) - (C19 > AVGC60) * (C19 - AVGC60) - (C20 > AVGC60) * (C20 - AVGC60) - (C21 > AVGC60) * (C21 - AVGC60) - (C22 > AVGC60) * (C22 - AVGC60) - (C23 > AVGC60) * (C23 - AVGC60) - (C24 > AVGC60) * (C24 - AVGC60) - (C25 > AVGC60) * (C25 - AVGC60) - (C26 > AVGC60) * (C26 - AVGC60) - (C27 > AVGC60) * (C27 - AVGC60) - (C28 > AVGC60) * (C28 - AVGC60) - (C29 > AVGC60) * (C29 - AVGC60))"

and:
"The (SDPOS + SDNEG) portion:
Would be slightly shorter as well:

(ABS(C - AVGC60) + ABS(C1 - AVGC60) + ABS(C2 - AVGC60) + ABS(C3 - AVGC60) + ABS(C4 - AVGC60) + ABS(C5 - AVGC60) + ABS(C6 - AVGC60) + ABS(C7 - AVGC60) + ABS(C8 - AVGC60) + ABS(C9 - AVGC60) + ABS(C10 - AVGC60) + ABS(C11 - AVGC60) + ABS(C12 - AVGC60) + ABS(C13 - AVGC60) + ABS(C14 - AVGC60) + ABS(C15 - AVGC60) + ABS(C16 - AVGC60) + ABS(C17 - AVGC60) + ABS(C18 - AVGC60) + ABS(C19 - AVGC60) + ABS(C20 - AVGC60) + ABS(C21 - AVGC60) + ABS(C22 - AVGC60) + ABS(C23 - AVGC60) + ABS(C24 - AVGC60) + ABS(C25 - AVGC60) + ABS(C26 - AVGC60) + ABS(C27 - AVGC60) + ABS(C28 - AVGC60) + ABS(C29 - AVGC60))"

=========================================================



Final TII:


100*((ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60) * (C1 - AVGC60) - (C2 > AVGC60) * (C2 - AVGC60) - (C3 > AVGC60) * (C3 - AVGC60) - (C4 > AVGC60) * (C4 - AVGC60) - (C5 > AVGC60) * (C5 - AVGC60) - (C6 > AVGC60) * (C6 - AVGC60) - (C7 > AVGC60) * (C7 - AVGC60) - (C8 > AVGC60) * (C8 - AVGC60) - (C9 > AVGC60) * (C9 - AVGC60) - (C10 > AVGC60) * (C10 - AVGC60) - (C11 > AVGC60) * (C11 - AVGC60) - (C12 > AVGC60) * (C12 - AVGC60) - (C13 > AVGC60) * (C13 - AVGC60) - (C14 > AVGC60) * (C14 - AVGC60) - (C15 > AVGC60) * (C15 - AVGC60) - (C16 > AVGC60) * (C16 - AVGC60) - (C17 > AVGC60) * (C17 - AVGC60) - (C18 > AVGC60) * (C18 - AVGC60) - (C19 > AVGC60) * (C19 - AVGC60) - (C20 > AVGC60) * (C20 - AVGC60) - (C21 > AVGC60) * (C21 - AVGC60) - (C22 > AVGC60) * (C22 - AVGC60) - (C23 > AVGC60) * (C23 - AVGC60) - (C24 > AVGC60) * (C24 - AVGC60) - (C25 > AVGC60) * (C25 - AVGC60) - (C26 > AVGC60) * (C26 - AVGC60) - (C27 > AVGC60) * (C27 - AVGC60) - (C28 > AVGC60) * (C28 - AVGC60) - (C29 > AVGC60) * (C29 - AVGC60))/(ABS(C - AVGC60) + ABS(C1 - AVGC60) + ABS(C2 - AVGC60) + ABS(C3 - AVGC60) + ABS(C4 - AVGC60) + ABS(C5 - AVGC60) + ABS(C6 - AVGC60) + ABS(C7 - AVGC60) + ABS(C8 - AVGC60) + ABS(C9 - AVGC60) + ABS(C10 - AVGC60) + ABS(C11 - AVGC60) + ABS(C12 - AVGC60) + ABS(C13 - AVGC60) + ABS(C14 - AVGC60) + ABS(C15 - AVGC60) + ABS(C16 - AVGC60) + ABS(C17 - AVGC60) + ABS(C18 - AVGC60) + ABS(C19 - AVGC60) + ABS(C20 - AVGC60) + ABS(C21 - AVGC60) + ABS(C22 - AVGC60) + ABS(C23 - AVGC60) + ABS(C24 - AVGC60) + ABS(C25 - AVGC60) + ABS(C26 - AVGC60) + ABS(C27 - AVGC60) + ABS(C28 - AVGC60) + ABS(C29 - AVGC60)))


I tested a few dates and it seems to match TS output.



Thanks
diceman

Bruce_L
Posted : Tuesday, October 26, 2010 4:19:34 PM


Worden Trainer

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


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jdong5801
Posted : Tuesday, October 26, 2010 11:20:37 PM
Gold Customer Gold Customer

Joined: 1/15/2009
Posts: 5
Thanks a lot.
donbetman
Posted : Wednesday, October 27, 2010 8:48:26 AM
Registered User
Joined: 12/15/2009
Posts: 91
Thanks Diceman & Bruce.  I looked at last evening and concur.

-Don
Bruce_L
Posted : Wednesday, October 27, 2010 8:50:28 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome. Our pleasure.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
haschade
Posted : Sunday, October 31, 2010 5:57:50 AM
Registered User
Joined: 8/21/2007
Posts: 181
Any chance of getting SF RealCode for this?
Bruce_L
Posted : Monday, November 1, 2010 9:15:45 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
'|******************************************************************
'|*** StockFinder RealCode Indicator - Version 5.0 www.worden.com
'|*** Copy and paste this header and code into StockFinder *********
'|*** Indicator:Trend Intensity Index TTI
'|******************************************************************
'# MajorPeriod = UserInput.Integer = 60
'# MinorPeriod = UserInput.Integer = 30
Static Start As Integer
If isFirstBar Then
    Start = System.Math.Max(MajorPeriod, MinorPeriod) - 1
End If
If CurrentIndex >= Start Then
    Dim Num As Single = 0
    Dim Den As Single = 0
    For i As Integer = 0 To MinorPeriod - 1
        Dim Dif As Single = Price.Last(i) - Price.AVGC(MajorPeriod)
        If Dif > 0 Then
            Num += Dif
        End If
        Den += System.Math.Abs(Dif)
    Next
    If Den > 0 Then
        Plot = 100 * Num / Den
    Else
        Plot = Single.NaN
    End If
Else
    Plot = Single.NaN
End If

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donbetman
Posted : Wednesday, November 17, 2010 2:40:07 PM
Registered User
Joined: 12/15/2009
Posts: 91
Bruce,

I have been using the formula described by diceman (& you) here as a custom indicator in one of the bottom panes of a chart and it was great.  I tried changing the name (from instructions in another post) and the chart changed so I changed it back to the original way (just the formula) and now it won't represent what is in the tab, what the formula is returning.  I have it set to simple and one smoothing but I cannot get the chart to return the correct results. For instance SPRD today is at 81.21 per the formula but the chart (custom indicator) shows over 92.  I deleted and started over to no avail.  I messed up something but can't figure it out.  Can you help?

Don
Bruce_L
Posted : Wednesday, November 17, 2010 2:47:44 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Is your Chart set to a Daily Time Frame? When I use the following as a Custom Indicator it returns 81.21 currently on the Chart for SPRD:

100*((ABS(C > AVGC60) * (C - AVGC60) - (C1 > AVGC60) * (C1 - AVGC60) - (C2 > AVGC60) * (C2 - AVGC60) - (C3 > AVGC60) * (C3 - AVGC60) - (C4 > AVGC60) * (C4 - AVGC60) - (C5 > AVGC60) * (C5 - AVGC60) - (C6 > AVGC60) * (C6 - AVGC60) - (C7 > AVGC60) * (C7 - AVGC60) - (C8 > AVGC60) * (C8 - AVGC60) - (C9 > AVGC60) * (C9 - AVGC60) - (C10 > AVGC60) * (C10 - AVGC60) - (C11 > AVGC60) * (C11 - AVGC60) - (C12 > AVGC60) * (C12 - AVGC60) - (C13 > AVGC60) * (C13 - AVGC60) - (C14 > AVGC60) * (C14 - AVGC60) - (C15 > AVGC60) * (C15 - AVGC60) - (C16 > AVGC60) * (C16 - AVGC60) - (C17 > AVGC60) * (C17 - AVGC60) - (C18 > AVGC60) * (C18 - AVGC60) - (C19 > AVGC60) * (C19 - AVGC60) - (C20 > AVGC60) * (C20 - AVGC60) - (C21 > AVGC60) * (C21 - AVGC60) - (C22 > AVGC60) * (C22 - AVGC60) - (C23 > AVGC60) * (C23 - AVGC60) - (C24 > AVGC60) * (C24 - AVGC60) - (C25 > AVGC60) * (C25 - AVGC60) - (C26 > AVGC60) * (C26 - AVGC60) - (C27 > AVGC60) * (C27 - AVGC60) - (C28 > AVGC60) * (C28 - AVGC60) - (C29 > AVGC60) * (C29 - AVGC60))/(ABS(C - AVGC60) + ABS(C1 - AVGC60) + ABS(C2 - AVGC60) + ABS(C3 - AVGC60) + ABS(C4 - AVGC60) + ABS(C5 - AVGC60) + ABS(C6 - AVGC60) + ABS(C7 - AVGC60) + ABS(C8 - AVGC60) + ABS(C9 - AVGC60) + ABS(C10 - AVGC60) + ABS(C11 - AVGC60) + ABS(C12 - AVGC60) + ABS(C13 - AVGC60) + ABS(C14 - AVGC60) + ABS(C15 - AVGC60) + ABS(C16 - AVGC60) + ABS(C17 - AVGC60) + ABS(C18 - AVGC60) + ABS(C19 - AVGC60) + ABS(C20 - AVGC60) + ABS(C21 - AVGC60) + ABS(C22 - AVGC60) + ABS(C23 - AVGC60) + ABS(C24 - AVGC60) + ABS(C25 - AVGC60) + ABS(C26 - AVGC60) + ABS(C27 - AVGC60) + ABS(C28 - AVGC60) + ABS(C29 - AVGC60)))

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
donbetman
Posted : Wednesday, November 17, 2010 2:55:59 PM
Registered User
Joined: 12/15/2009
Posts: 91
Bruce,

Rookie mistake on my part.  Sorry to bother you.

Don
Bruce_L
Posted : Wednesday, November 17, 2010 3:01:26 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I'm happy to read you were able to figure it out.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Art Lindsley
Posted : Tuesday, December 14, 2010 1:04:05 PM
Registered User
Joined: 7/23/2010
Posts: 84
In telechart this short trend formula  100 * AVGC7 / AVGC65 presents a numerical value. Can you convert this to SF5 code please. I'd like to add it as a colume along with my watchlist.

TIA
art
Bruce_L
Posted : Tuesday, December 14, 2010 1:10:14 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
If CurrentIndex >= 65 Then
    Plot = 100 * Price.AVGC(7) / Price.AVGC(65)
Else
    Plot = Single.NaN
End If

-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.