| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 1/15/2007
Posts: 4
|
I'm trying to write a scan that shows when the current indicator's value is greater than it's maximum value over the last 200 days. I'm trying to do this on an average daily range indicator. What am I doing wrong ?
(
avgh10-avgl10)>MAX(avgh10-avgl10)200
Thanks
GM
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I do not know of a practical way to write this formula.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (Bruce_L) I do not know of a practical way to write this formula.
Bruce,
Suppose x is a sequence of N numbers,
x = (x(1), x(2), ..., x( N ))
There is, in general, no practical way to write a PCF for the maximum of the sequence if N is very large. Sixteen is about my limit.
If we wish to determine whether
y > max{x( n )| n = 1,2,...,N}
is true, we need only write
y>x(1) AND y>x(2) AND ... AND y>x( N )
which grows only linearly with N.
I believe you may have overlooked the above approach. Did you?
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (bustermu) There is, in general, no practical way to write a PCF for the maximum of the sequence if N is very large. Sixteen is about my limit.
My limit is thirty-two.
QUOTE (bustermu) I believe you may have overlooked the above approach. Did you?
I misread the question.
QUOTE (grainmerchant) I'm trying to write a scan that shows when the current indicator's value is greater than it's maximum value over the last 200 days. I'm trying to do this on an average daily range indicator. What am I doing wrong ?
(
avgh10-avgl10)>MAX(avgh10-avgl10)200
Please try the following:
AVGH10 - AVGL10 > AVGH10.1 - AVGL10.1 AND AVGH10 - AVGL10 > AVGH10.2 - AVGL10.2 AND AVGH10 - AVGL10 > AVGH10.3 - AVGL10.3 AND AVGH10 - AVGL10 > AVGH10.4 - AVGL10.4 AND AVGH10 - AVGL10 > AVGH10.5 - AVGL10.5 AND AVGH10 - AVGL10 > AVGH10.6 - AVGL10.6 AND AVGH10 - AVGL10 > AVGH10.7 - AVGL10.7 AND AVGH10 - AVGL10 > AVGH10.8 - AVGL10.8 AND AVGH10 - AVGL10 > AVGH10.9 - AVGL10.9 AND AVGH10 - AVGL10 > AVGH10.10 - AVGL10.10 AND AVGH10 - AVGL10 > AVGH10.11 - AVGL10.11 AND AVGH10 - AVGL10 > AVGH10.12 - AVGL10.12 AND AVGH10 - AVGL10 > AVGH10.13 - AVGL10.13 AND AVGH10 - AVGL10 > AVGH10.14 - AVGL10.14 AND AVGH10 - AVGL10 > AVGH10.15 - AVGL10.15 AND AVGH10 - AVGL10 > AVGH10.16 - AVGL10.16 AND AVGH10 - AVGL10 > AVGH10.17 - AVGL10.17 AND AVGH10 - AVGL10 > AVGH10.18 - AVGL10.18 AND AVGH10 - AVGL10 > AVGH10.19 - AVGL10.19 AND AVGH10 - AVGL10 > AVGH10.20 - AVGL10.20 AND AVGH10 - AVGL10 > AVGH10.21 - AVGL10.21 AND AVGH10 - AVGL10 > AVGH10.22 - AVGL10.22 AND AVGH10 - AVGL10 > AVGH10.23 - AVGL10.23 AND AVGH10 - AVGL10 > AVGH10.24 - AVGL10.24 AND AVGH10 - AVGL10 > AVGH10.25 - AVGL10.25 AND AVGH10 - AVGL10 > AVGH10.26 - AVGL10.26 AND AVGH10 - AVGL10 > AVGH10.27 - AVGL10.27 AND AVGH10 - AVGL10 > AVGH10.28 - AVGL10.28 AND AVGH10 - AVGL10 > AVGH10.29 - AVGL10.29 AND AVGH10 - AVGL10 > AVGH10.30 - AVGL10.30 AND AVGH10 - AVGL10 > AVGH10.31 - AVGL10.31 AND AVGH10 - AVGL10 > AVGH10.32 - AVGL10.32 AND AVGH10 - AVGL10 > AVGH10.33 - AVGL10.33 AND AVGH10 - AVGL10 > AVGH10.34 - AVGL10.34 AND AVGH10 - AVGL10 > AVGH10.35 - AVGL10.35 AND AVGH10 - AVGL10 > AVGH10.36 - AVGL10.36 AND AVGH10 - AVGL10 > AVGH10.37 - AVGL10.37 AND AVGH10 - AVGL10 > AVGH10.38 - AVGL10.38 AND AVGH10 - AVGL10 > AVGH10.39 - AVGL10.39 AND AVGH10 - AVGL10 > AVGH10.40 - AVGL10.40 AND AVGH10 - AVGL10 > AVGH10.41 - AVGL10.41 AND AVGH10 - AVGL10 > AVGH10.42 - AVGL10.42 AND AVGH10 - AVGL10 > AVGH10.43 - AVGL10.43 AND AVGH10 - AVGL10 > AVGH10.44 - AVGL10.44 AND AVGH10 - AVGL10 > AVGH10.45 - AVGL10.45 AND AVGH10 - AVGL10 > AVGH10.46 - AVGL10.46 AND AVGH10 - AVGL10 > AVGH10.47 - AVGL10.47 AND AVGH10 - AVGL10 > AVGH10.48 - AVGL10.48 AND AVGH10 - AVGL10 > AVGH10.49 - AVGL10.49 AND AVGH10 - AVGL10 > AVGH10.50 - AVGL10.50 AND AVGH10 - AVGL10 > AVGH10.51 - AVGL10.51 AND AVGH10 - AVGL10 > AVGH10.52 - AVGL10.52 AND AVGH10 - AVGL10 > AVGH10.53 - AVGL10.53 AND AVGH10 - AVGL10 > AVGH10.54 - AVGL10.54 AND AVGH10 - AVGL10 > AVGH10.55 - AVGL10.55 AND AVGH10 - AVGL10 > AVGH10.56 - AVGL10.56 AND AVGH10 - AVGL10 > AVGH10.57 - AVGL10.57 AND AVGH10 - AVGL10 > AVGH10.58 - AVGL10.58 AND AVGH10 - AVGL10 > AVGH10.59 - AVGL10.59 AND AVGH10 - AVGL10 > AVGH10.60 - AVGL10.60 AND AVGH10 - AVGL10 > AVGH10.61 - AVGL10.61 AND AVGH10 - AVGL10 > AVGH10.62 - AVGL10.62 AND AVGH10 - AVGL10 > AVGH10.63 - AVGL10.63 AND AVGH10 - AVGL10 > AVGH10.64 - AVGL10.64 AND AVGH10 - AVGL10 > AVGH10.65 - AVGL10.65 AND AVGH10 - AVGL10 > AVGH10.66 - AVGL10.66 AND AVGH10 - AVGL10 > AVGH10.67 - AVGL10.67 AND AVGH10 - AVGL10 > AVGH10.68 - AVGL10.68 AND AVGH10 - AVGL10 > AVGH10.69 - AVGL10.69 AND AVGH10 - AVGL10 > AVGH10.70 - AVGL10.70 AND AVGH10 - AVGL10 > AVGH10.71 - AVGL10.71 AND AVGH10 - AVGL10 > AVGH10.72 - AVGL10.72 AND AVGH10 - AVGL10 > AVGH10.73 - AVGL10.73 AND AVGH10 - AVGL10 > AVGH10.74 - AVGL10.74 AND AVGH10 - AVGL10 > AVGH10.75 - AVGL10.75 AND AVGH10 - AVGL10 > AVGH10.76 - AVGL10.76 AND AVGH10 - AVGL10 > AVGH10.77 - AVGL10.77 AND AVGH10 - AVGL10 > AVGH10.78 - AVGL10.78 AND AVGH10 - AVGL10 > AVGH10.79 - AVGL10.79 AND AVGH10 - AVGL10 > AVGH10.80 - AVGL10.80 AND AVGH10 - AVGL10 > AVGH10.81 - AVGL10.81 AND AVGH10 - AVGL10 > AVGH10.82 - AVGL10.82 AND AVGH10 - AVGL10 > AVGH10.83 - AVGL10.83 AND AVGH10 - AVGL10 > AVGH10.84 - AVGL10.84 AND AVGH10 - AVGL10 > AVGH10.85 - AVGL10.85 AND AVGH10 - AVGL10 > AVGH10.86 - AVGL10.86 AND AVGH10 - AVGL10 > AVGH10.87 - AVGL10.87 AND AVGH10 - AVGL10 > AVGH10.88 - AVGL10.88 AND AVGH10 - AVGL10 > AVGH10.89 - AVGL10.89 AND AVGH10 - AVGL10 > AVGH10.90 - AVGL10.90 AND AVGH10 - AVGL10 > AVGH10.91 - AVGL10.91 AND AVGH10 - AVGL10 > AVGH10.92 - AVGL10.92 AND AVGH10 - AVGL10 > AVGH10.93 - AVGL10.93 AND AVGH10 - AVGL10 > AVGH10.94 - AVGL10.94 AND AVGH10 - AVGL10 > AVGH10.95 - AVGL10.95 AND AVGH10 - AVGL10 > AVGH10.96 - AVGL10.96 AND AVGH10 - AVGL10 > AVGH10.97 - AVGL10.97 AND AVGH10 - AVGL10 > AVGH10.98 - AVGL10.98 AND AVGH10 - AVGL10 > AVGH10.99 - AVGL10.99 AND AVGH10 - AVGL10 > AVGH10.100 - AVGL10.100 AND AVGH10 - AVGL10 > AVGH10.101 - AVGL10.101 AND AVGH10 - AVGL10 > AVGH10.102 - AVGL10.102 AND AVGH10 - AVGL10 > AVGH10.103 - AVGL10.103 AND AVGH10 - AVGL10 > AVGH10.104 - AVGL10.104 AND AVGH10 - AVGL10 > AVGH10.105 - AVGL10.105 AND AVGH10 - AVGL10 > AVGH10.106 - AVGL10.106 AND AVGH10 - AVGL10 > AVGH10.107 - AVGL10.107 AND AVGH10 - AVGL10 > AVGH10.108 - AVGL10.108 AND AVGH10 - AVGL10 > AVGH10.109 - AVGL10.109 AND AVGH10 - AVGL10 > AVGH10.110 - AVGL10.110 AND AVGH10 - AVGL10 > AVGH10.111 - AVGL10.111 AND AVGH10 - AVGL10 > AVGH10.112 - AVGL10.112 AND AVGH10 - AVGL10 > AVGH10.113 - AVGL10.113 AND AVGH10 - AVGL10 > AVGH10.114 - AVGL10.114 AND AVGH10 - AVGL10 > AVGH10.115 - AVGL10.115 AND AVGH10 - AVGL10 > AVGH10.116 - AVGL10.116 AND AVGH10 - AVGL10 > AVGH10.117 - AVGL10.117 AND AVGH10 - AVGL10 > AVGH10.118 - AVGL10.118 AND AVGH10 - AVGL10 > AVGH10.119 - AVGL10.119 AND AVGH10 - AVGL10 > AVGH10.120 - AVGL10.120 AND AVGH10 - AVGL10 > AVGH10.121 - AVGL10.121 AND AVGH10 - AVGL10 > AVGH10.122 - AVGL10.122 AND AVGH10 - AVGL10 > AVGH10.123 - AVGL10.123 AND AVGH10 - AVGL10 > AVGH10.124 - AVGL10.124 AND AVGH10 - AVGL10 > AVGH10.125 - AVGL10.125 AND AVGH10 - AVGL10 > AVGH10.126 - AVGL10.126 AND AVGH10 - AVGL10 > AVGH10.127 - AVGL10.127 AND AVGH10 - AVGL10 > AVGH10.128 - AVGL10.128 AND AVGH10 - AVGL10 > AVGH10.129 - AVGL10.129 AND AVGH10 - AVGL10 > AVGH10.130 - AVGL10.130 AND AVGH10 - AVGL10 > AVGH10.131 - AVGL10.131 AND AVGH10 - AVGL10 > AVGH10.132 - AVGL10.132 AND AVGH10 - AVGL10 > AVGH10.133 - AVGL10.133 AND AVGH10 - AVGL10 > AVGH10.134 - AVGL10.134 AND AVGH10 - AVGL10 > AVGH10.135 - AVGL10.135 AND AVGH10 - AVGL10 > AVGH10.136 - AVGL10.136 AND AVGH10 - AVGL10 > AVGH10.137 - AVGL10.137 AND AVGH10 - AVGL10 > AVGH10.138 - AVGL10.138 AND AVGH10 - AVGL10 > AVGH10.139 - AVGL10.139 AND AVGH10 - AVGL10 > AVGH10.140 - AVGL10.140 AND AVGH10 - AVGL10 > AVGH10.141 - AVGL10.141 AND AVGH10 - AVGL10 > AVGH10.142 - AVGL10.142 AND AVGH10 - AVGL10 > AVGH10.143 - AVGL10.143 AND AVGH10 - AVGL10 > AVGH10.144 - AVGL10.144 AND AVGH10 - AVGL10 > AVGH10.145 - AVGL10.145 AND AVGH10 - AVGL10 > AVGH10.146 - AVGL10.146 AND AVGH10 - AVGL10 > AVGH10.147 - AVGL10.147 AND AVGH10 - AVGL10 > AVGH10.148 - AVGL10.148 AND AVGH10 - AVGL10 > AVGH10.149 - AVGL10.149 AND AVGH10 - AVGL10 > AVGH10.150 - AVGL10.150 AND AVGH10 - AVGL10 > AVGH10.151 - AVGL10.151 AND AVGH10 - AVGL10 > AVGH10.152 - AVGL10.152 AND AVGH10 - AVGL10 > AVGH10.153 - AVGL10.153 AND AVGH10 - AVGL10 > AVGH10.154 - AVGL10.154 AND AVGH10 - AVGL10 > AVGH10.155 - AVGL10.155 AND AVGH10 - AVGL10 > AVGH10.156 - AVGL10.156 AND AVGH10 - AVGL10 > AVGH10.157 - AVGL10.157 AND AVGH10 - AVGL10 > AVGH10.158 - AVGL10.158 AND AVGH10 - AVGL10 > AVGH10.159 - AVGL10.159 AND AVGH10 - AVGL10 > AVGH10.160 - AVGL10.160 AND AVGH10 - AVGL10 > AVGH10.161 - AVGL10.161 AND AVGH10 - AVGL10 > AVGH10.162 - AVGL10.162 AND AVGH10 - AVGL10 > AVGH10.163 - AVGL10.163 AND AVGH10 - AVGL10 > AVGH10.164 - AVGL10.164 AND AVGH10 - AVGL10 > AVGH10.165 - AVGL10.165 AND AVGH10 - AVGL10 > AVGH10.166 - AVGL10.166 AND AVGH10 - AVGL10 > AVGH10.167 - AVGL10.167 AND AVGH10 - AVGL10 > AVGH10.168 - AVGL10.168 AND AVGH10 - AVGL10 > AVGH10.169 - AVGL10.169 AND AVGH10 - AVGL10 > AVGH10.170 - AVGL10.170 AND AVGH10 - AVGL10 > AVGH10.171 - AVGL10.171 AND AVGH10 - AVGL10 > AVGH10.172 - AVGL10.172 AND AVGH10 - AVGL10 > AVGH10.173 - AVGL10.173 AND AVGH10 - AVGL10 > AVGH10.174 - AVGL10.174 AND AVGH10 - AVGL10 > AVGH10.175 - AVGL10.175 AND AVGH10 - AVGL10 > AVGH10.176 - AVGL10.176 AND AVGH10 - AVGL10 > AVGH10.177 - AVGL10.177 AND AVGH10 - AVGL10 > AVGH10.178 - AVGL10.178 AND AVGH10 - AVGL10 > AVGH10.179 - AVGL10.179 AND AVGH10 - AVGL10 > AVGH10.180 - AVGL10.180 AND AVGH10 - AVGL10 > AVGH10.181 - AVGL10.181 AND AVGH10 - AVGL10 > AVGH10.182 - AVGL10.182 AND AVGH10 - AVGL10 > AVGH10.183 - AVGL10.183 AND AVGH10 - AVGL10 > AVGH10.184 - AVGL10.184 AND AVGH10 - AVGL10 > AVGH10.185 - AVGL10.185 AND AVGH10 - AVGL10 > AVGH10.186 - AVGL10.186 AND AVGH10 - AVGL10 > AVGH10.187 - AVGL10.187 AND AVGH10 - AVGL10 > AVGH10.188 - AVGL10.188 AND AVGH10 - AVGL10 > AVGH10.189 - AVGL10.189 AND AVGH10 - AVGL10 > AVGH10.190 - AVGL10.190 AND AVGH10 - AVGL10 > AVGH10.191 - AVGL10.191 AND AVGH10 - AVGL10 > AVGH10.192 - AVGL10.192 AND AVGH10 - AVGL10 > AVGH10.193 - AVGL10.193 AND AVGH10 - AVGL10 > AVGH10.194 - AVGL10.194 AND AVGH10 - AVGL10 > AVGH10.195 - AVGL10.195 AND AVGH10 - AVGL10 > AVGH10.196 - AVGL10.196 AND AVGH10 - AVGL10 > AVGH10.197 - AVGL10.197 AND AVGH10 - AVGL10 > AVGH10.198 - AVGL10.198 AND AVGH10 - AVGL10 > AVGH10.199 - AVGL10.199 AND AVGH10 - AVGL10 > AVGH10.200 - AVGL10.200
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/15/2007
Posts: 4
|
Thanks Bruce! That's fairly simple (even though it's long)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome. Our pleasure.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |