Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
Registered User Joined: 2/28/2005 Posts: 825
|
This would be used mainly to watch the progress/decline of the NYA chart.
|
|
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 829 time(s).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 2/28/2005 Posts: 825
|
Thank you Bruce. You are the best.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 2/28/2005 Posts: 825
|
Could you now make me a similiar indicator for TC2000
Thanks
art
|
|
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
|
|
Registered User Joined: 2/28/2005 Posts: 825
|
I use RSI 14,3.
ie Posted : Thursday, April 22, 2010 11:54:06 AM
thanks
|
|
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
|
|
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)
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
|
|
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
|
|
Registered User Joined: 2/28/2005 Posts: 825
|
You are amazing Bruce.
TYVM
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |