Registered User
Joined: 8/1/2006
Posts: 97
|
Hi. I used to focus solely on daily price bars and therefore built my pcf's accordingly. However, I'm starting to get more interested in looking at, and possibly making more decisions based on, weekly charts. However, it seems like your pfc builder only works for daily bars (when you click on "open" and the dialogue box popes up asking whether you mean the open today or a certain number of DAYS ago in the past but doesn't give you the option of specifying this week or last, etc.). For example, I have a pcf for a basic daily bullish engulfing pattern (open yesterday higher than close yesterday, close today higher than open today, open today lower than close yesterday, close today higher than open yesterday). Here it is: O1 > C1 AND C > O AND O < C1 AND C > O1. How would I "translate" this into a weekly scenario (open last week higher than the close week, etc.)? Also, what if I wanted to say something like the LOW of last week? How would I represent that? Thank you.
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
C = close today
C1 = close yesterday
C2 = close the day before yesterday
and so on.
Low for the week (last 5 days)
MINL5
High for the week (last 5 days)
MAXH5
Thanks
diceman
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (JordanS) Here it is: O1 > C1 AND C > O AND O < C1 AND C > O1. How would I "translate" this into a weekly scenario (open last week higher than the close week, etc.)?
Please try the following:
O9 > C5 AND C > O4 AND O4 < C5 AND C > O9
QUOTE (JordanS) Also, what if I wanted to say something like the LOW of last week?
Please try the following:
MINL5.5
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/1/2006
Posts: 97
|
Thanks diceman and Bruce. That weekly bullish engulfing pcf that you gave me, Bruce, seems to work and I look forward to using it. However, I also have some pcf's that I would like to convert from daily to weekly that are more complicated than that one (I just used that one to ask the question because it's a pretty simple example), so I was hoping that there was some kind of general rule type-of-thing that I could always use to accomplish this goal. Is there?
Also, just to clarify, when I said the low of last week, what I meant was the low of the week before this week (kind of like how yesterday's low could be called the low of the day before this day). In other words, say it's the afternoon of Friday Dec. 15, after the markets close. I would want the low of the week before this past week -- the 4-8th. Is that what MINL5.5 does? If so, how would I say this week's low higher than last week's low -- MINL5 > MINL5.5? Thanks again.
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
MINL5 > MINL5.5?
that is correct.
The ".5" means the low of 5 days
5 days back.
So at fridays close
MINL5.5 is the low of the previous week.
This assumes there are no holidays.
(a trading week of less than 5 days)
Thanks
diceman
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (JordanS) I also have some pcf's that I would like to convert from daily to weekly that are more complicated than that one (I just used that one to ask the question because it's a pretty simple example), so I was hoping that there was some kind of general rule type-of-thing that I could always use to accomplish this goal. Is there?
If you are converting formulas based entirely on the Open, High, Low, Close and Volumes of weekly bars, yes. I'll put the daily version followed by the weekly equivalent:
For the Open, multiply the days ago parameter by 5 and add 4 to get the weekly version.
O = O4
O1 = O9
O2 = O14
For the High, H is replaced by MAXH5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MAXH5 with a '.'.
H = MAXH5
H1 = MAXH5.5
H2 = MAXH5.10
The Low is treated very much like the High. L is replaced by MINL5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MINL5 with a '.'.
L = MINL5
L1 = MINL5.5
L2 = MINL5.10
The Close is probably the simplest. Just multiply the days ago parameter in the daily version by 5 to get the weekly version.
C = C
C1 = C5
C2 = C10
Volume is an interesting case. To get the actual Volume for a weekly bar (in Blocks of 100), you would need to multiply the Average Volume by 5. So V would be replaced by AVGV5 and if there is a days ago parameter in the daily version, multiply it by 5 and separate it from MINL5 with a '.' just like with the High and Low. But add *5 to the end of each weekly version whether or not there is a days ago parameter.
V = AVGV5*5
V1 = AVGV5.5*5
V2 = AVGV5.10*5
That said, if you are just comparing one Volume to another, there really isn't a reason to multiply it by 5 at all:
AVGV5*5 > AVGV5.5*5
Will return the same result as:
AVGV5 > AVGV5.5
Things can get a lot more complicated for weekly versions of some indicators. In same cases, it is not possible to write a weekly version (a weekly TSV for example).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 8/1/2006
Posts: 97
|
Great, Bruce, thanks so much. I'll have to sift through all of that soon and see what happens. Fortunately, I never use volume in my scans (most of the scans I'm interested in converting into weeklys are candlestick patterns), so at least I don't have that to worry about. Thanks again.
PS. By the way, in my opinion, anyway, a nice enhancement for your software in a future version would be weeks (or possibly even months or quarters) being options in the dialogue box that comes up when building pcf's, just to make it a bit more automated. Just a suggestion.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Thank you for the suggestion. I would move it to the Comments/Suggestions forum on your behalf but several variations on this theme are already there. Thanks again.
As a note, these types of Weekly comparisons can be easier to make using BackScanner in SnapSheets.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/25/2006
Posts: 2
|
Bruce,
I would like to build some pcf's to scan for patterns on weekly charts also but I want to scan for RSI and Stochastics that are above 80 and below 20. If RSI2.2 does that job for the daily chart what do I use for the same on the weekly chart? Thank you.
Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Persistent1,
The Weekly equivalent of RSI2.2 would be:
100 * (((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5)) / (ABS(C - C5) + ABS(C5 - C10) + .00001) + ((C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10)) / (ABS(C5 - C10) + ABS(C10 - C15) + .00001)) / 2
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/25/2006
Posts: 2
|
Bruce,
Thank you for the previous. I don't understand how to derive that formula but it works and that's what matters.
I am also in need of the Stochastics 12.5.5 but on a weekly time frame. Could you please provide that pcf formula?
Is there an online resource that you could refer me too that would teach me how to derive these on my own?
Thank you for your time.
Mike
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Persistent1) Is there an online resource that you could refer me too that would teach me how to derive these on my own?
I do not know of a single specific topic that would address this. Searching for Weekly and the specific indicator you wish to convert will frequently at least provide numerous example formulas. Techniques for cascading Moving Averages and manually expanding Exponential Moving Averages are in Cascades of Moving Averages.
Creating weekly versions of formulas is a matter of knowing how each indicator is calculated and realizing that most indicators are created from sampling one out of every five trading days in a way that would include the most recent value.
All of TeleChart's indicators are constructed using one or more of the Open, High, Low, Close and Volume for one or more periods. Instructions on how to create weekly versions of the Open, High, Low, Close and Volume are included in this very topic. In some cases, short-cuts can be created using the Daily version of an indicator formula or weekly samples of the daily values.
QUOTE (Persistent1) I am also in need of the Stochastics 12.5.5 but on a weekly time frame. Could you please provide that pcf formula?
Stochastics is one example where the Daily result can dramatically shorten the resulting formulas over using just Open, High, Low, Close and Volume information. This is because the Raw Stochastic just uses the Daily indicator with the period multiplied by five. This means only the Moving Averages need to be expanded.
Raw Stochastic:
Daily:
STOC12
Weekly:
STOC60
Simple Stochastic 12,5 SK:
Daily:
STOC12.5
Weekly:
(STOC60 + STOC60.1.5 + STOC60.1.10 + STOC60.1.15 + STOC60.1.20) / 5
Simple Stochastic 12,5,5 SD:
Daily:
AVG(STOC12.5,5)
Weekly:
(STOC60 + 2 * STOC60.1.5 + 3 * STOC60.1.10 + 4 * STOC60.1.15 + 5 * STOC60.1.20 + 4 * STOC60.1.25 + 3 * STOC60.1.30 + 2 * STOC60.1.35 + STOC60.1.40) / 25
Exponential Stochastic 12,5 SK:
Daily:
XAVG(STOC12,5)
Weekly:
.333559032545198 * (STOC60 + 2 / 3 * (STOC60.1.5 + 2 / 3 * (STOC60.1.10 + 2 / 3 * (STOC60.1.15 + 2 / 3 * (STOC60.1.20 + 2 / 3 * (STOC60.1.25 + 2 / 3 * (STOC60.1.30 + 2 / 3 * (STOC60.1.35 + 2 / 3 * (STOC60.1.40 + 2 / 3 * (STOC60.1.45 + 2 / 3 * (STOC60.1.50 + 2 / 3 * (STOC60.1.55 + 2 / 3 * (STOC60.1.60 + 2 / 3 * (STOC60.1.65 + 2 / 3 * (STOC60.1.70 + 2 / 3 * (STOC60.1.75 + 2 / 3 * (STOC60.1.80 + 2 / 3 * (STOC60.1.85))))))))))))))))))
Exponential Stochastic 12,5,5 SD:
Daily:
.333559032545198 * (XAVG(STOC12,5) + 2 / 3 * (XAVG(STOC12.1.1,5) + 2 / 3 * (XAVG(STOC12.1.2,5) + 2 / 3 * (XAVG(STOC12.1.3,5) + 2 / 3 * (XAVG(STOC12.1.4,5) + 2 / 3 * (XAVG(STOC12.1.5,5) + 2 / 3 * (XAVG(STOC12.1.6,5) + 2 / 3 * (XAVG(STOC12.1.7,5) + 2 / 3 * (XAVG(STOC12.1.8,5) + 2 / 3 * (XAVG(STOC12.1.9,5) + 2 / 3 * (XAVG(STOC12.1.10,5) + 2 / 3 * (XAVG(STOC12.1.11,5) + 2 / 3 * (XAVG(STOC12.1.12,5) + 2 / 3 * (XAVG(STOC12.1.13,5) + 2 / 3 * (XAVG(STOC12.1.14,5) + 2 / 3 * (XAVG(STOC12.1.15,5) + 2 / 3 * (XAVG(STOC12.1.16,5) + 2 / 3 * (XAVG(STOC12.1.17,5)))))))))))))))))))
Weekly:
.11119698203496 * (STOC60 + 2 / 3 * (2 * STOC60.1.5 + 2 / 3 * (3 * STOC60.1.10 + 2 / 3 * (4 * STOC60.1.15 + 2 / 3 * (5 * STOC60.1.20 + 2 / 3 * (6 * STOC60.1.25 + 2 / 3 * (7 * STOC60.1.30 + 2 / 3 * (8 * STOC60.1.35 + 2 / 3 * (9 * STOC60.1.40 + 2 / 3 * (10 * STOC60.1.45 + 2 / 3 * (11 * STOC60.1.50 + 2 / 3 * (12 * STOC60.1.55 + 2 / 3 * (13 * STOC60.1.60 + 2 / 3 * (14 * STOC60.1.65 + 2 / 3 * (15 * STOC60.1.70 + 2 / 3 * (16 * STOC60.1.75 + 2 / 3 * (17 * STOC60.1.80 + 2 / 3 * (18 * STOC60.1.85 + 2 / 3 * (19 * STOC60.1.90 + 2 / 3 * (20 * STOC60.1.95 + 2 / 3 * (21 * STOC60.1.100 + 2 / 3 * (22 * STOC60.1.105 + 2 / 3 * (23 * STOC60.1.110)))))))))))))))))))))))
You may wish to review the following:
Understanding Stochastics
Handy PCF example formulas to help you learn the syntax of PCFs!
How to create a Personal Criteria Forumula (PCF)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/20/2007
Posts: 2
|
I'm having a little trouble converting one of my daily pcf's to a weekly version. I just want to make sure I understand the threads above. Lets say I have something like 'MAXH20-H', which is the daily version. Would I write the weekly version as 'MAXH5.20-MAXH?' Also do I need to tinker with the AVGC60? If so, do I follow the same conversion rule as above (Multiply times 5)?
Thanks for your help.
Yogi
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
yogi007,
The following Daily formula:
MAXH20-H
Could be converted to Weekly as follows:
MAXH100 - MAXH5
Your version:
MAXH5.20-MAXH
Would be the 1-Week High 4-Weeks Ago minus the current Daily High.
The following Daily Formula:
AVGC60
Could be converted into a Weekly approximation by multiplying the period by 5:
AVGC300
But it would be better to sample every fifth bar as would be done by the charted indicator:
(C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100 + C105 + C110 + C115 + C120 + C125 + C130 + C135 + C140 + C145 + C150 + C155 + C160 + C165 + C170 + C175 + C180 + C185 + C190 + C195 + C200 + C205 + C210 + C215 + C220 + C225 + C230 + C235 + C240 + C245 + C250 + C255 + C260 + C265 + C270 + C275 + C280 + C285 + C290 + C295) / 60
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 4/20/2007
Posts: 2
|
Thanks for your help on this Bruce.
-Yogi007
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
yogi007,
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 15
|
Hi, could you please share the pcf for 10 week moving average crossing 30 week moving average? (simple moving averages)
Thanks
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
See this post:
Create easy scan 10 ma wkly crossing above 30 ma wky
Thanks
diceman
|
|
Registered User
Joined: 4/29/2006
Posts: 75
|
Hi Guys,
Also interested in developing PCFs to scan for weekly signals. I would like a weekly PCF for each of the following indicators:
Stochastic - simple
5,4,1
21,4,1
55,4,1
RSI - simple, no Wilder's smoothing
5,4
13,4
21,4
Thanks, Richard
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (Sumboddie) Stochastic 5,4,1 - simple
Please try the following (the SD will be the same as the SK because the SD Period is one):
Raw Stochastic:
STOC25
Stochastic SK:
(STOC25 + STOC25.1.5 + STOC25.1.10 + STOC25.1.15) / 4
QUOTE (Sumboddie) Stochastic 21,4,1 - simple
Please try the following (the SD will be the same as the SK because the Period is one):
Raw Stochastic:
STOC105
Stochastic SK:
(STOC105 + STOC105.1.5 + STOC105.1.10 + STOC105.1.15) / 4
QUOTE (Sumboddie) Stochastic 55,4,1 - simple Please try the following (the SD will be the same as the SK because the Period is one):
Raw Stochastic:
STOC275
Stochastic SK:
(STOC275 + STOC275.1.5 + STOC275.1.10 + STOC275.1.15) / 4
QUOTE (Sumboddie) RSI 5,4 - simple, no Wilder's smoothing
Please try the following:
100 * (((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20)) / (ABS(C - C5) + ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + .00001) + ((C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25)) / (ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + .00001) + ((C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30)) / (ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + .00001) + ((C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35)) / (ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + .00001)) / 4
QUOTE (Sumboddie) RSI 13,4 - simple, no Wilder's smoothing
Please try the following:
100 * (((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60)) / (ABS(C - C5) + ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + .00001) + ((C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65)) / (ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + .00001) + ((C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70)) / (ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + .00001) + ((C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70) + (C75 > C80) * (C80 - C75)) / (ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + ABS(C75 - C80) + .00001)) / 4
QUOTE (Sumboddie) RSI 21,4 - simple, no Wilder's smoothing
Please try the following:
100 * (((C > C5) * (C5 - C) + (C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70) + (C75 > C80) * (C80 - C75) + (C80 > C85) * (C85 - C80) + (C85 > C90) * (C90 - C85) + (C90 > C95) * (C95 - C90) + (C95 > C100) * (C100 - C95) + (C100 > C105) * (C105 - C100)) / (ABS(C - C5) + ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + ABS(C75 - C80) + ABS(C80 - C85) + ABS(C85 - C90) + ABS(C90 - C95) + ABS(C95 - C100) + ABS(C100 - C105) + .00001) + ((C5 > C10) * (C10 - C5) + (C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70) + (C75 > C80) * (C80 - C75) + (C80 > C85) * (C85 - C80) + (C85 > C90) * (C90 - C85) + (C90 > C95) * (C95 - C90) + (C95 > C100) * (C100 - C95) + (C100 > C105) * (C105 - C100) + (C105 > C110) * (C110 - C105)) / (ABS(C5 - C10) + ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + ABS(C75 - C80) + ABS(C80 - C85) + ABS(C85 - C90) + ABS(C90 - C95) + ABS(C95 - C100) + ABS(C100 - C105) + ABS(C105 - C110) + .00001) + ((C10 > C15) * (C15 - C10) + (C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70) + (C75 > C80) * (C80 - C75) + (C80 > C85) * (C85 - C80) + (C85 > C90) * (C90 - C85) + (C90 > C95) * (C95 - C90) + (C95 > C100) * (C100 - C95) + (C100 > C105) * (C105 - C100) + (C105 > C110) * (C110 - C105) + (C110 > C115) * (C115 - C110)) / (ABS(C10 - C15) + ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + ABS(C75 - C80) + ABS(C80 - C85) + ABS(C85 - C90) + ABS(C90 - C95) + ABS(C95 - C100) + ABS(C100 - C105) + ABS(C105 - C110) + ABS(C110 - C115) + .00001) + ((C15 > C20) * (C20 - C15) + (C20 > C25) * (C25 - C20) + (C25 > C30) * (C30 - C25) + (C30 > C35) * (C35 - C30) + (C35 > C40) * (C40 - C35) + (C40 > C45) * (C45 - C40) + (C45 > C50) * (C50 - C45) + (C50 > C55) * (C55 - C50) + (C55 > C60) * (C60 - C55) + (C60 > C65) * (C65 - C60) + (C65 > C70) * (C70 - C65) + (C70 > C75) * (C75 - C70) + (C75 > C80) * (C80 - C75) + (C80 > C85) * (C85 - C80) + (C85 > C90) * (C90 - C85) + (C90 > C95) * (C95 - C90) + (C95 > C100) * (C100 - C95) + (C100 > C105) * (C105 - C100) + (C105 > C110) * (C110 - C105) + (C110 > C115) * (C115 - C110) + (C115 > C120) * (C120 - C115)) / (ABS(C15 - C20) + ABS(C20 - C25) + ABS(C25 - C30) + ABS(C30 - C35) + ABS(C35 - C40) + ABS(C40 - C45) + ABS(C45 - C50) + ABS(C50 - C55) + ABS(C55 - C60) + ABS(C60 - C65) + ABS(C65 - C70) + ABS(C70 - C75) + ABS(C75 - C80) + ABS(C80 - C85) + ABS(C85 - C90) + ABS(C90 - C95) + ABS(C95 - C100) + ABS(C100 - C105) + ABS(C105 - C110) + ABS(C110 - C115) + ABS(C115 - C120) + .00001)) / 4
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |