Registered User
Joined: 10/10/2004
Posts: 62
|
IS THERE A WAY (PCF) TO PLOT WEEKLY IFT ON A DAILY CHART SO THAT DAILY AND WEEKLY INVERSE FISHER TRANSFORM CAN BE SEEN ON THE SAME DAILY CHART, THANK YOU , SICERELY, MFG
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
In theory, yes.
I don't know what the INVERSE FISHER TRANSFORM is, though.
- Craig
Here to Help!
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Craig,
I would also be interested in IFT if it is possible (daily)
EXPVAL =Exponential value of a number.
Example 6=403.42
4.5=90.01
( This function works in TC when I plug the number in but, I get a
syntax error when I use a variable name like "C")
I will give the "standard" values for IFT:
VALUE1 = (( RSI 5period) -50 ) * .1
( an oscillator that goes from 0 to 100 is normalized to go from
+5 to -5 in this case RSI with a length of 5)
VALUE2 = a 9 period weighted moving average of VALUE1
VALUE1*9 +
VALUE1.1*8+
VALUE1.2*7+
VALUE1.3*6+
AND SO ON (DIVIDED BY 45)
IFT= (EXPVAL(2*VALUE2)-1) / (EXPVAL(2*VALUE2)+1)
BUY= up thru -.5
SELL= down thru +.5
Thanks
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
The Inverse Fisher Transform is just another name for the hyperbolic tangent function, TANH( ), which is available in TC2005. For example, the Inverse Fisher Transform of (C-C1)/C1 is:
TANH((C-C1)/C1)
Please see:
RE: Inverse Fisher Transform
Thanks,
Jim Murphy
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Thanks bustermu
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
mfg, what did you want the IFT of?
- Craig
Here to Help!
|
|
Registered User
Joined: 10/10/2004
Posts: 62
|
QUOTE (mfg) IS THERE A WAY (PCF) TO PLOT WEEKLY IFT ON A DAILY CHART SO THAT DAILY AND WEEKLY INVERSE FISHER TRANSFORM CAN BE SEEN ON THE SAME DAILY CHART, THANK YOU , SICERELY, MFG . PLEASE SEE YOU POST ON 4/13/05, 10:12 AM, THE META VERSION IS: v1:=.1*(RSI(5)-50);
v2:=Mov(v1,9,W);
.5;
-.5;
(Exp(2*v2)-1)/(Exp(2*v2)+1)
ALSO IF YOU CAN GIVE DAILY/WEEKLY VERSIONS FOR A DAILY CHART, AND ALSO META FORMULA FOR COMPARATIVE PURPOSE, PLEASE REFER TO YOUR POST OF 4/13/05, 10:12 AM, SINCERELY, MFG
|
|
Registered User
Joined: 10/10/2004
Posts: 62
|
QUOTE (mfg) QUOTE (mfg) IS THERE A WAY (PCF) TO PLOT WEEKLY IFT ON A DAILY CHART SO THAT DAILY AND WEEKLY INVERSE FISHER TRANSFORM CAN BE SEEN ON THE SAME DAILY CHART, THANK YOU , SICERELY, MFG . PLEASE SEE YOU POST ON 4/13/05, 10:12 AM, THE META VERSION IS: v1:=.1*(RSI(5)-50); v2:=Mov(v1,9,W); .5; -.5; (Exp(2*v2)-1)/(Exp(2*v2)+1) ALSO IF YOU CAN GIVE DAILY/WEEKLY VERSIONS FOR A DAILY CHART, AND ALSO META FORMULA FOR COMPARATIVE PURPOSE, PLEASE REFER TO YOUR POST OF 4/13/05, 10:12 AM, SINCERELY, MFG , PS IFT OF RSI
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
A weekly version of the RSI5 is tough.
Plot this formula as a CUSTOM INDICTOR to get the daily:
TANH(RSI5.1-50)
A true "weekly" version of this plotted on a daily chart is more than a tad messy.
When you are looking at the chart it is very easy to see the weekly by hitting the 5 key on your keyboard. You can quickly switch back by hitting the 1 key.
With one key you see the daily or the weekly. Very easy to switch between them both.
- Craig
Here to Help!
|
|
Registered User
Joined: 4/3/2006
Posts: 9
|
What the exact easy language for the Inverse Fischer? So I just copy and paste it and make a new easy scan criteria, thanks
Mike.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
What settings do you want for your IF?
- Craig
Here to Help!
|
|
Registered User
Joined: 4/3/2006
Posts: 9
|
NOt sure, I saw it in the tradestation magazine, I think its the the inverse fischer transform RSI. I use slow stoachastic with 12,3,3 setting if thats helpful.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Go to this thread and try the formula I give in the
Wednesday, April 13, 2005 10:12:12 AM
post
RE: Inverse Fisher Transform
- Craig
Here to Help!
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
dadonnum1
The "standard" settings from the tradestation article are the ones I supplied in my
post: 02/18/06.
I believe the closest approximation of this is the Tanstaafl post:
05/21/05 7:42:08
However I'm not sure if it is finished at the end he says:
"... at this point I become lazy enough to let you take it from there and do the rest of the expansion, per my original post above."
What he has posted above appears to be part of the answer.
Like you I would like to see one post with a 5 period
RSI and a 9 period weighted MAV.
That hits a high of +1 and a low of -1.
I realize what Tanstaafl is trying to do and I applaud his efforts.
However sometimes the knowledge is so far above mine that I cant tell if its
the answer.
Thanks
Good Luck
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following formula is too long to be practical for use as a Custom Indicator (please don't try it). While you might wish to try it as a Personal Criteria Formula (it is a Daily version loosely based on Tanstaafl's Saturday, May 21, 2005 7:42:08 PM ET post in RE: Inverse Fisher Transform, but I don't have anything to use for comparison and can't be sure if it is correct), it will slow down updating your PCFs significantly:
TANH((9 * (100 - (100 / (1 + (((C > C1) * (C1 - C) + .8 * ((C1 > C2) * (C2 - C1) + .8 * ((C2 > C3) * (C3 - C2) + .8 * ((C3 > C4) * (C4 - C3) + .8 * ((C4 > C5) * (C5 - C4) + .8 * ((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20)))))))))))))))))))))) / ((C < C1) * (C - C1) + .8 * ((C1 < C2) * (C1 - C2) + .8 * ((C2 < C3) * (C2 - C3) + .8 * ((C3 < C4) * (C3 - C4) + .8 * ((C4 < C5) * (C4 - C5) + .8 * ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21)))))))))))))))))))))))))) + 8 * (100 - (100 / (1 + (((C1 > C2) * (C2 - C1) + .8 * ((C2 > C3) * (C3 - C2) + .8 * ((C3 > C4) * (C4 - C3) + .8 * ((C4 > C5) * (C5 - C4) + .8 * ((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21)))))))))))))))))))))) / ((C1 < C2) * (C1 - C2) + .8 * ((C2 < C3) * (C2 - C3) + .8 * ((C3 < C4) * (C3 - C4) + .8 * ((C4 < C5) * (C4 - C5) + .8 * ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22)))))))))))))))))))))))))) + 7 * (100 - (100 / (1 + (((C2 > C3) * (C3 - C2) + .8 * ((C3 > C4) * (C4 - C3) + .8 * ((C4 > C5) * (C5 - C4) + .8 * ((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22)))))))))))))))))))))) / ((C2 < C3) * (C2 - C3) + .8 * ((C3 < C4) * (C3 - C4) + .8 * ((C4 < C5) * (C4 - C5) + .8 * ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23)))))))))))))))))))))))))) + 6 * (100 - (100 / (1 + (((C3 > C4) * (C4 - C3) + .8 * ((C4 > C5) * (C5 - C4) + .8 * ((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23)))))))))))))))))))))) / ((C3 < C4) * (C3 - C4) + .8 * ((C4 < C5) * (C4 - C5) + .8 * ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24)))))))))))))))))))))))))) + 5 * (100 - (100 / (1 + (((C4 > C5) * (C5 - C4) + .8 * ((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23) + .8 * ((C24 > C25) * (C25 - C24)))))))))))))))))))))) / ((C4 < C5) * (C4 - C5) + .8 * ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24) + .8 * ((C24 < C25) * (C24 - C25)))))))))))))))))))))))))) + 4 * (100 - (100 / (1 + (((C5 > C6) * (C6 - C5) + .8 * ((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23) + .8 * ((C24 > C25) * (C25 - C24) + .8 * ((C25 > C26) * (C26 - C25)))))))))))))))))))))) / ((C5 < C6) * (C5 - C6) + .8 * ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24) + .8 * ((C24 < C25) * (C24 - C25) + .8 * ((C25 < C26) * (C25 - C26)))))))))))))))))))))))))) + 3 * (100 - (100 / (1 + (((C6 > C7) * (C7 - C6) + .8 * ((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23) + .8 * ((C24 > C25) * (C25 - C24) + .8 * ((C25 > C26) * (C26 - C25) + .8 * ((C26 > C27) * (C27 - C26)))))))))))))))))))))) / ((C6 < C7) * (C6 - C7) + .8 * ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24) + .8 * ((C24 < C25) * (C24 - C25) + .8 * ((C25 < C26) * (C25 - C26) + .8 * ((C26 < C27) * (C26 - C27)))))))))))))))))))))))))) + 2 * (100 - (100 / (1 + (((C7 > C8) * (C8 - C7) + .8 * ((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23) + .8 * ((C24 > C25) * (C25 - C24) + .8 * ((C25 > C26) * (C26 - C25) + .8 * ((C26 > C27) * (C27 - C26) + .8 * ((C27 > C28) * (C28 - C27)))))))))))))))))))))) / ((C7 < C8) * (C7 - C8) + .8 * ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24) + .8 * ((C24 < C25) * (C24 - C25) + .8 * ((C25 < C26) * (C25 - C26) + .8 * ((C26 < C27) * (C26 - C27) + .8 * ((C27 < C28) * (C27 - C28)))))))))))))))))))))))))) + 100 - (100 / (1 + (((C8 > C9) * (C9 - C8) + .8 * ((C9 > C10) * (C10 - C9) + .8 * ((C10 > C11) * (C11 - C10) + .8 * ((C11 > C12) * (C12 - C11) + .8 * ((C12 > C13) * (C13 - C12) + .8 * ((C13 > C14) * (C14 - C13) + .8 * ((C14 > C15) * (C15 - C14) + .8 * ((C15 > C16) * (C16 - C15) + .8 * ((C16 > C17) * (C17 - C16) + .8 * ((C17 > C18) * (C18 - C17) + .8 * ((C18 > C19) * (C19 - C18) + .8 * ((C19 > C20) * (C20 - C19) + .8 * ((C20 > C21) * (C21 - C20) + .8 * ((C21 > C22) * (C22 - C21) + .8 * ((C22 > C23) * (C23 - C22) + .8 * ((C23 > C24) * (C24 - C23) + .8 * ((C24 > C25) * (C25 - C24) + .8 * ((C25 > C26) * (C26 - C25) + .8 * ((C26 > C27) * (C27 - C26) + .8 * ((C27 > C28) * (C28 - C27) + .8 * ((C28 > C29) * (C29 - C28)))))))))))))))))))))) / ((C8 < C9) * (C8 - C9) + .8 * ((C9 < C10) * (C9 - C10) + .8 * ((C10 < C11) * (C10 - C11) + .8 * ((C11 < C12) * (C11 - C12) + .8 * ((C12 < C13) * (C12 - C13) + .8 * ((C13 < C14) * (C13 - C14) + .8 * ((C14 < C15) * (C14 - C15) + .8 * ((C15 < C16) * (C15 - C16) + .8 * ((C16 < C17) * (C16 - C17) + .8 * ((C17 < C18) * (C17 - C18) + .8 * ((C18 < C19) * (C18 - C19) + .8 * ((C19 < C20) * (C19 - C20) + .8 * ((C20 < C21) * (C20 - C21) + .8 * ((C21 < C22) * (C21 - C22) + .8 * ((C22 < C23) * (C22 - C23) + .8 * ((C23 < C24) * (C23 - C24) + .8 * ((C24 < C25) * (C24 - C25) + .8 * ((C25 < C26) * (C25 - C26) + .8 * ((C26 < C27) * (C26 - C27) + .8 * ((C27 < C28) * (C27 - C28) + .8 * ((C28 < C29) * (C28 - C29)))))))))))))))))))))))))) / 450 - 5)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
Excellent Bruce. (and Tanstaafl)
I have this indicator in tradestation and most values only differ by
+ - .01.
Due to its size. I will keep it in a word document and only use in
in TC once every few weeks. (then remove it)
Its not too bad if I put a PCF in a watchlist tab. Then I can sort for stocks
that are at their turning points.
Would this be a weekly version if C4 was changed to C20, C14 to
C70 (and so on)?
Would there need to be any changes other then the close adjust?
Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (diceman) I have this indicator in tradestation and most values only differ by + - .01.
It's nice to hear it seems to be working.
QUOTE (diceman) Would this be a weekly version if C4 was changed to C20, C14 to C70 (and so on)?
Sounds right to me. You may wish to try the following (remembering not to use it as a Custom Indicator):
TANH((9 * (100 - (100 / (1 + (((C > C5) * (C5 - C) + .8 * ((C5 > C10) * (C10 - C5) + .8 * ((C10 > C15) * (C15 - C10) + .8 * ((C15 > C20) * (C20 - C15) + .8 * ((C20 > C25) * (C25 - C20) + .8 * ((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100)))))))))))))))))))))) / ((C < C5) * (C - C5) + .8 * ((C5 < C10) * (C5 - C10) + .8 * ((C10 < C15) * (C10 - C15) + .8 * ((C15 < C20) * (C15 - C20) + .8 * ((C20 < C25) * (C20 - C25) + .8 * ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105)))))))))))))))))))))))))) + 8 * (100 - (100 / (1 + (((C5 > C10) * (C10 - C5) + .8 * ((C10 > C15) * (C15 - C10) + .8 * ((C15 > C20) * (C20 - C15) + .8 * ((C20 > C25) * (C25 - C20) + .8 * ((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105)))))))))))))))))))))) / ((C5 < C10) * (C5 - C10) + .8 * ((C10 < C15) * (C10 - C15) + .8 * ((C15 < C20) * (C15 - C20) + .8 * ((C20 < C25) * (C20 - C25) + .8 * ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110)))))))))))))))))))))))))) + 7 * (100 - (100 / (1 + (((C10 > C15) * (C15 - C10) + .8 * ((C15 > C20) * (C20 - C15) + .8 * ((C20 > C25) * (C25 - C20) + .8 * ((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110)))))))))))))))))))))) / ((C10 < C15) * (C10 - C15) + .8 * ((C15 < C20) * (C15 - C20) + .8 * ((C20 < C25) * (C20 - C25) + .8 * ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115)))))))))))))))))))))))))) + 6 * (100 - (100 / (1 + (((C15 > C20) * (C20 - C15) + .8 * ((C20 > C25) * (C25 - C20) + .8 * ((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115)))))))))))))))))))))) / ((C15 < C20) * (C15 - C20) + .8 * ((C20 < C25) * (C20 - C25) + .8 * ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120)))))))))))))))))))))))))) + 5 * (100 - (100 / (1 + (((C20 > C25) * (C25 - C20) + .8 * ((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115) + .8 * ((C120 > C125) * (C125 - C120)))))))))))))))))))))) / ((C20 < C25) * (C20 - C25) + .8 * ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120) + .8 * ((C120 < C125) * (C120 - C125)))))))))))))))))))))))))) + 4 * (100 - (100 / (1 + (((C25 > C30) * (C30 - C25) + .8 * ((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115) + .8 * ((C120 > C125) * (C125 - C120) + .8 * ((C125 > C130) * (C130 - C125)))))))))))))))))))))) / ((C25 < C30) * (C25 - C30) + .8 * ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120) + .8 * ((C120 < C125) * (C120 - C125) + .8 * ((C125 < C130) * (C125 - C130)))))))))))))))))))))))))) + 3 * (100 - (100 / (1 + (((C30 > C35) * (C35 - C30) + .8 * ((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115) + .8 * ((C120 > C125) * (C125 - C120) + .8 * ((C125 > C130) * (C130 - C125) + .8 * ((C130 > C135) * (C135 - C130)))))))))))))))))))))) / ((C30 < C35) * (C30 - C35) + .8 * ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120) + .8 * ((C120 < C125) * (C120 - C125) + .8 * ((C125 < C130) * (C125 - C130) + .8 * ((C130 < C135) * (C130 - C135)))))))))))))))))))))))))) + 2 * (100 - (100 / (1 + (((C35 > C40) * (C40 - C35) + .8 * ((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115) + .8 * ((C120 > C125) * (C125 - C120) + .8 * ((C125 > C130) * (C130 - C125) + .8 * ((C130 > C135) * (C135 - C130) + .8 * ((C135 > C140) * (C140 - C135)))))))))))))))))))))) / ((C35 < C40) * (C35 - C40) + .8 * ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120) + .8 * ((C120 < C125) * (C120 - C125) + .8 * ((C125 < C130) * (C125 - C130) + .8 * ((C130 < C135) * (C130 - C135) + .8 * ((C135 < C140) * (C135 - C140)))))))))))))))))))))))))) + 100 - (100 / (1 + (((C40 > C45) * (C45 - C40) + .8 * ((C45 > C50) * (C50 - C45) + .8 * ((C50 > C55) * (C55 - C50) + .8 * ((C55 > C60) * (C60 - C55) + .8 * ((C60 > C65) * (C65 - C60) + .8 * ((C65 > C70) * (C70 - C65) + .8 * ((C70 > C75) * (C75 - C70) + .8 * ((C75 > C80) * (C80 - C75) + .8 * ((C80 > C85) * (C85 - C80) + .8 * ((C85 > C90) * (C90 - C85) + .8 * ((C90 > C95) * (C95 - C90) + .8 * ((C95 > C100) * (C100 - C95) + .8 * ((C100 > C105) * (C105 - C100) + .8 * ((C105 > C110) * (C110 - C105) + .8 * ((C110 > C115) * (C115 - C110) + .8 * ((C115 > C120) * (C120 - C115) + .8 * ((C120 > C125) * (C125 - C120) + .8 * ((C125 > C130) * (C130 - C125) + .8 * ((C130 > C135) * (C135 - C130) + .8 * ((C135 > C140) * (C140 - C135) + .8 * ((C140 > C145) * (C145 - C140)))))))))))))))))))))) / ((C40 < C45) * (C40 - C45) + .8 * ((C45 < C50) * (C45 - C50) + .8 * ((C50 < C55) * (C50 - C55) + .8 * ((C55 < C60) * (C55 - C60) + .8 * ((C60 < C65) * (C60 - C65) + .8 * ((C65 < C70) * (C65 - C70) + .8 * ((C70 < C75) * (C70 - C75) + .8 * ((C75 < C80) * (C75 - C80) + .8 * ((C80 < C85) * (C80 - C85) + .8 * ((C85 < C90) * (C85 - C90) + .8 * ((C90 < C95) * (C90 - C95) + .8 * ((C95 < C100) * (C95 - C100) + .8 * ((C100 < C105) * (C100 - C105) + .8 * ((C105 < C110) * (C105 - C110) + .8 * ((C110 < C115) * (C110 - C115) + .8 * ((C115 < C120) * (C115 - C120) + .8 * ((C120 < C125) * (C120 - C125) + .8 * ((C125 < C130) * (C125 - C130) + .8 * ((C130 < C135) * (C130 - C135) + .8 * ((C135 < C140) * (C135 - C140) + .8 * ((C140 < C145) * (C140 - C145)))))))))))))))))))))))))) / 450 - 5)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |