Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

0 based RSI Indicator(s) Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
alindsley
Posted : Thursday, April 22, 2010 12:12:40 PM

Registered User
Joined: 2/28/2005
Posts: 825
StockTiming has created a zero based RSI indicator which they watch. Is this possible in SF5? They say:

" Short term traders, and day traders need to know the upside or downside bias in any given day, and an idea of how strong that bias is.

One way to do this is by comparing two different Relative Strength periods of time. For this analysis, we use a RSI setting of 9, and a RSI setting of 30.

Furthermore, for simplicity in reading the results, we "zero base" the RSI reading for our paid subscribers. To zero base a RSI reading, one needs to subtract 50 from the RSI level at each data point. Then, instead of 50 being neutral, 0 is neutral. This makes it very easy to see if the RSI is positive and how positive it is.

So, let's apply this to the New York Stock Exchange (NYA Index). Today's posted chart is a daily chart going back to last December.

Look for two things on today's posted chart ...

1. When the RSI readings are positive or negative (above or below zero).

And,

2. When the Green 9 RSI reading is ABOVE (or below) the Blue 30 RSI reading. Those are times where the daily market strength is "extra strong" or "extra weak".

Thank You

 

alindsley
Posted : Thursday, April 22, 2010 12:16:35 PM

Registered User
Joined: 2/28/2005
Posts: 825
This would be used mainly to watch the progress/decline of the NYA chart.
Bruce_L
Posted : Thursday, April 22, 2010 12:54:06 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The Chande Momentum Oscillator and the Efficiency Ratio are both zero centered version of an RSI. The main difference would be that both of these Indicators are generally calculated using Simple Moving Averages while the RSI is normally calculated using Wilder's Smoothing, which is a type of Exponential Moving Average.

You should be able to Open an attached Indicator directly into a running copy of StockFinder (and save it from within StockFinder if desired). You could also copy and paste the Indicator into the \My Documents\StockFinder5\(Your Username)\My Indicators\ folder and then load it like you would any other Indicator.

Attachments:
Zeroed RSI.sfInd - 7 KB, downloaded 771 time(s).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
Posted : Thursday, April 22, 2010 1:23:42 PM

Registered User
Joined: 2/28/2005
Posts: 825
Thank you Bruce. You are the best.
Bruce_L
Posted : Thursday, April 22, 2010 1:24:20 PM


Worden Trainer

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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
Posted : Friday, October 21, 2011 10:52:58 AM

Registered User
Joined: 2/28/2005
Posts: 825
Could you now make me a similiar indicator for TC2000

Thanks
art
Bruce_L
Posted : Friday, October 21, 2011 11:14:53 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I can create versions for specific periods using a Custom PCF Indicator. I cannot create a generalized version which would allow you to enter a period.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
Posted : Friday, October 21, 2011 12:47:45 PM

Registered User
Joined: 2/28/2005
Posts: 825
I use RSI 14,3.

ie Posted : Thursday, April 22, 2010 11:54:06 AM

thanks
Bruce_L
Posted : Friday, October 21, 2011 12:58:33 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You specified settings of 14,3. Are you using TeleChart 2007 or TC2000 version 12?

If you are using TeleChart 2007, what are the exact settings?
- RSI Period: 14
- Use Wilders Smoothing: Checked or unchecked?
- Avg Period: 3
- Average Type: Simple or Exponential?

If you are using TC2000 version 12, are you using RSI - Wilders or the plain RSI indicator?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
Posted : Friday, October 21, 2011 1:23:52 PM

Registered User
Joined: 2/28/2005
Posts: 825
If you dont mind Bruce I'd like to follow the guidelines which actually began this thread and make two different indicators (one shorterm the other longer)

 
Posted : Thursday, April 22, 2010 11:12:40 AM
For this analysis, we use a RSI setting of 9, and a RSI setting of 30.

Furthermore, for simplicity in reading the results, we "zero base" the RSI reading. To zero base a RSI reading, one needs to subtract 50 from the RSI level at each data point. Then, instead of 50 being neutral, 0 is neutral. This makes it very easy to see if the RSI is positive and how positive it is.

I look for two things on today's posted chart ...

1. When the RSI readings are positive or negative (above or below zero).

And,

2. When the Green 9 RSI reading is ABOVE (or below) the Blue 30 RSI reading. Those are times where the daily market strength is "extra strong" or "extra weak".

You made an observation above in this thread on  Thursday, April 22, 2010 11:54:06 AM which may be of use to you.

TC2000 v12 (latest updates)
Wilders RSI  9 and 30
smoothed
Simple
Avg Period: 3

Thank you for once again teaching the important lessons in exactness.
I appreciate you help once again.
art
Bruce_L
Posted : Friday, October 21, 2011 1:42:55 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I will start by noting that there is no Avg Period for RSI - Wilder's in TC2000 version 12. You can add the Simple Avg Period of 3 from TeleChart 2007 by setting the Period in the Custom PCF Indicator to 3 and the Average Type to Simple. You could also add a 3-Period Simple Moving Average to the Custom PCF Indicator.

You have now mentioned three different primary RSI Periods. I will provide formula to use in a Custom PCF Indicator for all three. The shortest was a 9-Period RSI - Wilders. A 0-centered version could be written as:

50 * (C - XAVGC17.1) / 9 / (.111121221031403 * (ABS(C - C1) + 8 / 9 * (ABS(C1 - C2) + 8 / 9 * (ABS(C2 - C3) + 8 / 9 * (ABS(C3 - C4) + 8 / 9 * (ABS(C4 - C5) + 8 / 9 * (ABS(C5 - C6) + 8 / 9 * (ABS(C6 - C7) + 8 / 9 * (ABS(C7 - C8) + 8 / 9 * (ABS(C8 - C9) + 8 / 9 * (ABS(C9 - C10) + 8 / 9 * (ABS(C10 - C11) + 8 / 9 * (ABS(C11 - C12) + 8 / 9 * (ABS(C12 - C13) + 8 / 9 * (ABS(C13 - C14) + 8 / 9 * (ABS(C14 - C15) + 8 / 9 * (ABS(C15 - C16) + 8 / 9 * (ABS(C16 - C17) + 8 / 9 * (ABS(C17 - C18) + 8 / 9 * (ABS(C18 - C19) + 8 / 9 * (ABS(C19 - C20) + 8 / 9 * (ABS(C20 - C21) + 8 / 9 * (ABS(C21 - C22) + 8 / 9 * (ABS(C22 - C23) + 8 / 9 * (ABS(C23 - C24) + 8 / 9 * (ABS(C24 - C25) + 8 / 9 * (ABS(C25 - C26) + 8 / 9 * (ABS(C26 - C27) + 8 / 9 * (ABS(C27 - C28) + 8 / 9 * (ABS(C28 - C29) + 8 / 9 * (ABS(C29 - C30) + 8 / 9 * (ABS(C30 - C31) + 8 / 9 * (ABS(C31 - C32) + 8 / 9 * (ABS(C32 - C33) + 8 / 9 * (ABS(C33 - C34) + 8 / 9 * (ABS(C34 - C35) + 8 / 9 * (ABS(C35 - C36) + 8 / 9 * (ABS(C36 - C37) + 8 / 9 * (ABS(C37 - C38) + 8 / 9 * (ABS(C38 - C39) + 8 / 9 * (ABS(C39 - C40) + 8 / 9 * (ABS(C40 - C41) + 8 / 9 * (ABS(C41 - C42) + 8 / 9 * (ABS(C42 - C43) + 8 / 9 * (ABS(C43 - C44) + 8 / 9 * (ABS(C44 - C45) + 8 / 9 * (ABS(C45 - C46) + 8 / 9 * (ABS(C46 - C47) + 8 / 9 * (ABS(C47 - C48) + 8 / 9 * (ABS(C48 - C49) + 8 / 9 * (ABS(C49 - C50) + 8 / 9 * (ABS(C50 - C51) + 8 / 9 * (ABS(C51 - C52) + 8 / 9 * (ABS(C52 - C53) + 8 / 9 * (ABS(C53 - C54) + 8 / 9 * (ABS(C54 - C55) + 8 / 9 * (ABS(C55 - C56) + 8 / 9 * (ABS(C56 - C57) + 8 / 9 * (ABS(C57 - C58) + 8 / 9 * (ABS(C58 - C59) + 8 / 9 * (ABS(C59 - C60) + 8 / 9 * (ABS(C60 - C61) + 8 / 9 * (ABS(C61 - C62) + 8 / 9 * (ABS(C62 - C63) + 8 / 9 * (ABS(C63 - C64) + 8 / 9 * (ABS(C64 - C65) + 8 / 9 * (ABS(C65 - C66) + 8 / 9 * (ABS(C66 - C67) + 8 / 9 * (ABS(C67 - C68) + 8 / 9 * (ABS(C68 - C69) + 8 / 9 * (ABS(C69 - C70) + 8 / 9 * (ABS(C70 - C71) + 8 / 9 * (ABS(C71 - C72) + 8 / 9 * (ABS(C72 - C73) + 8 / 9 * (ABS(C73 - C74) + 8 / 9 * (ABS(C74 - C75) + 8 / 9 * (ABS(C75 - C76) + 8 / 9 * (ABS(C76 - C77) + 8 / 9 * (ABS(C77 - C78) + 8 / 9 * (ABS(C78 - C79)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

The middle length was a 14-Period RSI - Wilders. A 0-centered version could be written as:

50 * (C - XAVGC27.1) / 14 / (.071435345156143 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

The longest length was a 30-Period RSI - Wilders. A 0-centered version could be written as:

50 * (C - XAVGC59.1) / 30 / (.0333366309172147 * (ABS(C - C1) + 29 / 30 * (ABS(C1 - C2) + 29 / 30 * (ABS(C2 - C3) + 29 / 30 * (ABS(C3 - C4) + 29 / 30 * (ABS(C4 - C5) + 29 / 30 * (ABS(C5 - C6) + 29 / 30 * (ABS(C6 - C7) + 29 / 30 * (ABS(C7 - C8) + 29 / 30 * (ABS(C8 - C9) + 29 / 30 * (ABS(C9 - C10) + 29 / 30 * (ABS(C10 - C11) + 29 / 30 * (ABS(C11 - C12) + 29 / 30 * (ABS(C12 - C13) + 29 / 30 * (ABS(C13 - C14) + 29 / 30 * (ABS(C14 - C15) + 29 / 30 * (ABS(C15 - C16) + 29 / 30 * (ABS(C16 - C17) + 29 / 30 * (ABS(C17 - C18) + 29 / 30 * (ABS(C18 - C19) + 29 / 30 * (ABS(C19 - C20) + 29 / 30 * (ABS(C20 - C21) + 29 / 30 * (ABS(C21 - C22) + 29 / 30 * (ABS(C22 - C23) + 29 / 30 * (ABS(C23 - C24) + 29 / 30 * (ABS(C24 - C25) + 29 / 30 * (ABS(C25 - C26) + 29 / 30 * (ABS(C26 - C27) + 29 / 30 * (ABS(C27 - C28) + 29 / 30 * (ABS(C28 - C29) + 29 / 30 * (ABS(C29 - C30) + 29 / 30 * (ABS(C30 - C31) + 29 / 30 * (ABS(C31 - C32) + 29 / 30 * (ABS(C32 - C33) + 29 / 30 * (ABS(C33 - C34) + 29 / 30 * (ABS(C34 - C35) + 29 / 30 * (ABS(C35 - C36) + 29 / 30 * (ABS(C36 - C37) + 29 / 30 * (ABS(C37 - C38) + 29 / 30 * (ABS(C38 - C39) + 29 / 30 * (ABS(C39 - C40) + 29 / 30 * (ABS(C40 - C41) + 29 / 30 * (ABS(C41 - C42) + 29 / 30 * (ABS(C42 - C43) + 29 / 30 * (ABS(C43 - C44) + 29 / 30 * (ABS(C44 - C45) + 29 / 30 * (ABS(C45 - C46) + 29 / 30 * (ABS(C46 - C47) + 29 / 30 * (ABS(C47 - C48) + 29 / 30 * (ABS(C48 - C49) + 29 / 30 * (ABS(C49 - C50) + 29 / 30 * (ABS(C50 - C51) + 29 / 30 * (ABS(C51 - C52) + 29 / 30 * (ABS(C52 - C53) + 29 / 30 * (ABS(C53 - C54) + 29 / 30 * (ABS(C54 - C55) + 29 / 30 * (ABS(C55 - C56) + 29 / 30 * (ABS(C56 - C57) + 29 / 30 * (ABS(C57 - C58) + 29 / 30 * (ABS(C58 - C59) + 29 / 30 * (ABS(C59 - C60) + 29 / 30 * (ABS(C60 - C61) + 29 / 30 * (ABS(C61 - C62) + 29 / 30 * (ABS(C62 - C63) + 29 / 30 * (ABS(C63 - C64) + 29 / 30 * (ABS(C64 - C65) + 29 / 30 * (ABS(C65 - C66) + 29 / 30 * (ABS(C66 - C67) + 29 / 30 * (ABS(C67 - C68) + 29 / 30 * (ABS(C68 - C69) + 29 / 30 * (ABS(C69 - C70) + 29 / 30 * (ABS(C70 - C71) + 29 / 30 * (ABS(C71 - C72) + 29 / 30 * (ABS(C72 - C73) + 29 / 30 * (ABS(C73 - C74) + 29 / 30 * (ABS(C74 - C75) + 29 / 30 * (ABS(C75 - C76) + 29 / 30 * (ABS(C76 - C77) + 29 / 30 * (ABS(C77 - C78) + 29 / 30 * (ABS(C78 - C79) + 29 / 30 * (ABS(C79 - C80) + 29 / 30 * (ABS(C80 - C81) + 29 / 30 * (ABS(C81 - C82) + 29 / 30 * (ABS(C82 - C83) + 29 / 30 * (ABS(C83 - C84) + 29 / 30 * (ABS(C84 - C85) + 29 / 30 * (ABS(C85 - C86) + 29 / 30 * (ABS(C86 - C87) + 29 / 30 * (ABS(C87 - C88) + 29 / 30 * (ABS(C88 - C89) + 29 / 30 * (ABS(C89 - C90) + 29 / 30 * (ABS(C90 - C91) + 29 / 30 * (ABS(C91 - C92) + 29 / 30 * (ABS(C92 - C93) + 29 / 30 * (ABS(C93 - C94) + 29 / 30 * (ABS(C94 - C95) + 29 / 30 * (ABS(C95 - C96) + 29 / 30 * (ABS(C96 - C97) + 29 / 30 * (ABS(C97 - C98) + 29 / 30 * (ABS(C98 - C99) + 29 / 30 * (ABS(C99 - C100) + 29 / 30 * (ABS(C100 - C101) + 29 / 30 * (ABS(C101 - C102) + 29 / 30 * (ABS(C102 - C103) + 29 / 30 * (ABS(C103 - C104) + 29 / 30 * (ABS(C104 - C105) + 29 / 30 * (ABS(C105 - C106) + 29 / 30 * (ABS(C106 - C107) + 29 / 30 * (ABS(C107 - C108) + 29 / 30 * (ABS(C108 - C109) + 29 / 30 * (ABS(C109 - C110) + 29 / 30 * (ABS(C110 - C111) + 29 / 30 * (ABS(C111 - C112) + 29 / 30 * (ABS(C112 - C113) + 29 / 30 * (ABS(C113 - C114) + 29 / 30 * (ABS(C114 - C115) + 29 / 30 * (ABS(C115 - C116) + 29 / 30 * (ABS(C116 - C117) + 29 / 30 * (ABS(C117 - C118) + 29 / 30 * (ABS(C118 - C119) + 29 / 30 * (ABS(C119 - C120) + 29 / 30 * (ABS(C120 - C121) + 29 / 30 * (ABS(C121 - C122) + 29 / 30 * (ABS(C122 - C123) + 29 / 30 * (ABS(C123 - C124) + 29 / 30 * (ABS(C124 - C125) + 29 / 30 * (ABS(C125 - C126) + 29 / 30 * (ABS(C126 - C127) + 29 / 30 * (ABS(C127 - C128) + 29 / 30 * (ABS(C128 - C129) + 29 / 30 * (ABS(C129 - C130) + 29 / 30 * (ABS(C130 - C131) + 29 / 30 * (ABS(C131 - C132) + 29 / 30 * (ABS(C132 - C133) + 29 / 30 * (ABS(C133 - C134) + 29 / 30 * (ABS(C134 - C135) + 29 / 30 * (ABS(C135 - C136) + 29 / 30 * (ABS(C136 - C137) + 29 / 30 * (ABS(C137 - C138) + 29 / 30 * (ABS(C138 - C139) + 29 / 30 * (ABS(C139 - C140) + 29 / 30 * (ABS(C140 - C141) + 29 / 30 * (ABS(C141 - C142) + 29 / 30 * (ABS(C142 - C143) + 29 / 30 * (ABS(C143 - C144) + 29 / 30 * (ABS(C144 - C145) + 29 / 30 * (ABS(C145 - C146) + 29 / 30 * (ABS(C146 - C147) + 29 / 30 * (ABS(C147 - C148) + 29 / 30 * (ABS(C148 - C149) + 29 / 30 * (ABS(C149 - C150) + 29 / 30 * (ABS(C150 - C151) + 29 / 30 * (ABS(C151 - C152) + 29 / 30 * (ABS(C152 - C153) + 29 / 30 * (ABS(C153 - C154) + 29 / 30 * (ABS(C154 - C155) + 29 / 30 * (ABS(C155 - C156) + 29 / 30 * (ABS(C156 - C157) + 29 / 30 * (ABS(C157 - C158) + 29 / 30 * (ABS(C158 - C159) + 29 / 30 * (ABS(C159 - C160) + 29 / 30 * (ABS(C160 - C161) + 29 / 30 * (ABS(C161 - C162) + 29 / 30 * (ABS(C162 - C163) + 29 / 30 * (ABS(C163 - C164) + 29 / 30 * (ABS(C164 - C165) + 29 / 30 * (ABS(C165 - C166) + 29 / 30 * (ABS(C166 - C167) + 29 / 30 * (ABS(C167 - C168) + 29 / 30 * (ABS(C168 - C169) + 29 / 30 * (ABS(C169 - C170) + 29 / 30 * (ABS(C170 - C171) + 29 / 30 * (ABS(C171 - C172) + 29 / 30 * (ABS(C172 - C173) + 29 / 30 * (ABS(C173 - C174) + 29 / 30 * (ABS(C174 - C175) + 29 / 30 * (ABS(C175 - C176) + 29 / 30 * (ABS(C176 - C177) + 29 / 30 * (ABS(C177 - C178) + 29 / 30 * (ABS(C178 - C179) + 29 / 30 * (ABS(C179 - C180) + 29 / 30 * (ABS(C180 - C181) + 29 / 30 * (ABS(C181 - C182) + 29 / 30 * (ABS(C182 - C183) + 29 / 30 * (ABS(C183 - C184) + 29 / 30 * (ABS(C184 - C185) + 29 / 30 * (ABS(C185 - C186) + 29 / 30 * (ABS(C186 - C187) + 29 / 30 * (ABS(C187 - C188) + 29 / 30 * (ABS(C188 - C189) + 29 / 30 * (ABS(C189 - C190) + 29 / 30 * (ABS(C190 - C191) + 29 / 30 * (ABS(C191 - C192) + 29 / 30 * (ABS(C192 - C193) + 29 / 30 * (ABS(C193 - C194) + 29 / 30 * (ABS(C194 - C195) + 29 / 30 * (ABS(C195 - C196) + 29 / 30 * (ABS(C196 - C197) + 29 / 30 * (ABS(C197 - C198) + 29 / 30 * (ABS(C198 - C199) + 29 / 30 * (ABS(C199 - C200) + 29 / 30 * (ABS(C200 - C201) + 29 / 30 * (ABS(C201 - C202) + 29 / 30 * (ABS(C202 - C203) + 29 / 30 * (ABS(C203 - C204) + 29 / 30 * (ABS(C204 - C205) + 29 / 30 * (ABS(C205 - C206) + 29 / 30 * (ABS(C206 - C207) + 29 / 30 * (ABS(C207 - C208) + 29 / 30 * (ABS(C208 - C209) + 29 / 30 * (ABS(C209 - C210) + 29 / 30 * (ABS(C210 - C211) + 29 / 30 * (ABS(C211 - C212) + 29 / 30 * (ABS(C212 - C213) + 29 / 30 * (ABS(C213 - C214) + 29 / 30 * (ABS(C214 - C215) + 29 / 30 * (ABS(C215 - C216) + 29 / 30 * (ABS(C216 - C217) + 29 / 30 * (ABS(C217 - C218) + 29 / 30 * (ABS(C218 - C219) + 29 / 30 * (ABS(C219 - C220) + 29 / 30 * (ABS(C220 - C221) + 29 / 30 * (ABS(C221 - C222) + 29 / 30 * (ABS(C222 - C223) + 29 / 30 * (ABS(C223 - C224) + 29 / 30 * (ABS(C224 - C225) + 29 / 30 * (ABS(C225 - C226) + 29 / 30 * (ABS(C226 - C227) + 29 / 30 * (ABS(C227 - C228) + 29 / 30 * (ABS(C228 - C229) + 29 / 30 * (ABS(C229 - C230) + 29 / 30 * (ABS(C230 - C231) + 29 / 30 * (ABS(C231 - C232) + 29 / 30 * (ABS(C232 - C233) + 29 / 30 * (ABS(C233 - C234) + 29 / 30 * (ABS(C234 - C235) + 29 / 30 * (ABS(C235 - C236) + 29 / 30 * (ABS(C236 - C237) + 29 / 30 * (ABS(C237 - C238) + 29 / 30 * (ABS(C238 - C239) + 29 / 30 * (ABS(C239 - C240) + 29 / 30 * (ABS(C240 - C241) + 29 / 30 * (ABS(C241 - C242) + 29 / 30 * (ABS(C242 - C243) + 29 / 30 * (ABS(C243 - C244) + 29 / 30 * (ABS(C244 - C245) + 29 / 30 * (ABS(C245 - C246) + 29 / 30 * (ABS(C246 - C247) + 29 / 30 * (ABS(C247 - C248) + 29 / 30 * (ABS(C248 - C249) + 29 / 30 * (ABS(C249 - C250) + 29 / 30 * (ABS(C250 - C251) + 29 / 30 * (ABS(C251 - C252) + 29 / 30 * (ABS(C252 - C253) + 29 / 30 * (ABS(C253 - C254) + 29 / 30 * (ABS(C254 - C255) + 29 / 30 * (ABS(C255 - C256) + 29 / 30 * (ABS(C256 - C257) + 29 / 30 * (ABS(C257 - C258) + 29 / 30 * (ABS(C258 - C259) + 29 / 30 * (ABS(C259 - C260) + 29 / 30 * (ABS(C260 - C261) + 29 / 30 * (ABS(C261 - C262) + 29 / 30 * (ABS(C262 - C263) + 29 / 30 * (ABS(C263 - C264) + 29 / 30 * (ABS(C264 - C265) + 29 / 30 * (ABS(C265 - C266) + 29 / 30 * (ABS(C266 - C267) + 29 / 30 * (ABS(C267 - C268) + 29 / 30 * (ABS(C268 - C269) + 29 / 30 * (ABS(C269 - C270) + 29 / 30 * (ABS(C270 - C271) + 29 / 30 * (ABS(C271 - C272))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Cascades of Moving Averages

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
alindsley
Posted : Friday, October 21, 2011 2:42:59 PM

Registered User
Joined: 2/28/2005
Posts: 825
You are amazing Bruce.
TYVM
Bruce_L
Posted : Friday, October 21, 2011 2:44:03 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.