Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 1,178
|
First, can the capabilities of "CountTrue(b, x) ->" be used to count the number of time L1 equals other Lows during a period of time.
What period of time can be used to ensure that the results will be Fast?
Or, Medium?
Or, Slow?
Or Very Slow?
Second, same questions for H1...
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
What do you mean by "other lows"?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The short answer would be no, it can't be done an a fully autameted way with CountTrue(b, x).
It probably can be done in some other way, but this is going to be slower. Do the previous lows need to be exactly equal to L1, at or below L1, or "near" L1 (and if "near", how is this defined)?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I mean previous lows that equal L1, looking for Support in the case of Lows and for Resistance in the case of Highs.
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
I am not sure about whether they should be equal or near. Let's start with Equal Lows to get an idea of how many hits result. Then if not enough, we'll look at Nearly Equal Lows.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The formula is slow going back 499 bars.
ABS(L1 = L2) - (L1 = L3) - (L1 = L4) - (L1 = L5) - (L1 = L6) - (L1 = L7) - (L1 = L8) - (L1 = L9) - (L1 = L10) - (L1 = L11) - (L1 = L12) - (L1 = L13) - (L1 = L14) - (L1 = L15) - (L1 = L16) - (L1 = L17) - (L1 = L18) - (L1 = L19) - (L1 = L20) - (L1 = L21) - (L1 = L22) - (L1 = L23) - (L1 = L24) - (L1 = L25) - (L1 = L26) - (L1 = L27) - (L1 = L28) - (L1 = L29) - (L1 = L30) - (L1 = L31) - (L1 = L32) - (L1 = L33) - (L1 = L34) - (L1 = L35) - (L1 = L36) - (L1 = L37) - (L1 = L38) - (L1 = L39) - (L1 = L40) - (L1 = L41) - (L1 = L42) - (L1 = L43) - (L1 = L44) - (L1 = L45) - (L1 = L46) - (L1 = L47) - (L1 = L48) - (L1 = L49) - (L1 = L50) - (L1 = L51) - (L1 = L52) - (L1 = L53) - (L1 = L54) - (L1 = L55) - (L1 = L56) - (L1 = L57) - (L1 = L58) - (L1 = L59) - (L1 = L60) - (L1 = L61) - (L1 = L62) - (L1 = L63) - (L1 = L64) - (L1 = L65) - (L1 = L66) - (L1 = L67) - (L1 = L68) - (L1 = L69) - (L1 = L70) - (L1 = L71) - (L1 = L72) - (L1 = L73) - (L1 = L74) - (L1 = L75) - (L1 = L76) - (L1 = L77) - (L1 = L78) - (L1 = L79) - (L1 = L80) - (L1 = L81) - (L1 = L82) - (L1 = L83) - (L1 = L84) - (L1 = L85) - (L1 = L86) - (L1 = L87) - (L1 = L88) - (L1 = L89) - (L1 = L90) - (L1 = L91) - (L1 = L92) - (L1 = L93) - (L1 = L94) - (L1 = L95) - (L1 = L96) - (L1 = L97) - (L1 = L98) - (L1 = L99) - (L1 = L100) - (L1 = L101) - (L1 = L102) - (L1 = L103) - (L1 = L104) - (L1 = L105) - (L1 = L106) - (L1 = L107) - (L1 = L108) - (L1 = L109) - (L1 = L110) - (L1 = L111) - (L1 = L112) - (L1 = L113) - (L1 = L114) - (L1 = L115) - (L1 = L116) - (L1 = L117) - (L1 = L118) - (L1 = L119) - (L1 = L120) - (L1 = L121) - (L1 = L122) - (L1 = L123) - (L1 = L124) - (L1 = L125) - (L1 = L126) - (L1 = L127) - (L1 = L128) - (L1 = L129) - (L1 = L130) - (L1 = L131) - (L1 = L132) - (L1 = L133) - (L1 = L134) - (L1 = L135) - (L1 = L136) - (L1 = L137) - (L1 = L138) - (L1 = L139) - (L1 = L140) - (L1 = L141) - (L1 = L142) - (L1 = L143) - (L1 = L144) - (L1 = L145) - (L1 = L146) - (L1 = L147) - (L1 = L148) - (L1 = L149) - (L1 = L150) - (L1 = L151) - (L1 = L152) - (L1 = L153) - (L1 = L154) - (L1 = L155) - (L1 = L156) - (L1 = L157) - (L1 = L158) - (L1 = L159) - (L1 = L160) - (L1 = L161) - (L1 = L162) - (L1 = L163) - (L1 = L164) - (L1 = L165) - (L1 = L166) - (L1 = L167) - (L1 = L168) - (L1 = L169) - (L1 = L170) - (L1 = L171) - (L1 = L172) - (L1 = L173) - (L1 = L174) - (L1 = L175) - (L1 = L176) - (L1 = L177) - (L1 = L178) - (L1 = L179) - (L1 = L180) - (L1 = L181) - (L1 = L182) - (L1 = L183) - (L1 = L184) - (L1 = L185) - (L1 = L186) - (L1 = L187) - (L1 = L188) - (L1 = L189) - (L1 = L190) - (L1 = L191) - (L1 = L192) - (L1 = L193) - (L1 = L194) - (L1 = L195) - (L1 = L196) - (L1 = L197) - (L1 = L198) - (L1 = L199) - (L1 = L200) - (L1 = L201) - (L1 = L202) - (L1 = L203) - (L1 = L204) - (L1 = L205) - (L1 = L206) - (L1 = L207) - (L1 = L208) - (L1 = L209) - (L1 = L210) - (L1 = L211) - (L1 = L212) - (L1 = L213) - (L1 = L214) - (L1 = L215) - (L1 = L216) - (L1 = L217) - (L1 = L218) - (L1 = L219) - (L1 = L220) - (L1 = L221) - (L1 = L222) - (L1 = L223) - (L1 = L224) - (L1 = L225) - (L1 = L226) - (L1 = L227) - (L1 = L228) - (L1 = L229) - (L1 = L230) - (L1 = L231) - (L1 = L232) - (L1 = L233) - (L1 = L234) - (L1 = L235) - (L1 = L236) - (L1 = L237) - (L1 = L238) - (L1 = L239) - (L1 = L240) - (L1 = L241) - (L1 = L242) - (L1 = L243) - (L1 = L244) - (L1 = L245) - (L1 = L246) - (L1 = L247) - (L1 = L248) - (L1 = L249) - (L1 = L250) - (L1 = L251) - (L1 = L252) - (L1 = L253) - (L1 = L254) - (L1 = L255) - (L1 = L256) - (L1 = L257) - (L1 = L258) - (L1 = L259) - (L1 = L260) - (L1 = L261) - (L1 = L262) - (L1 = L263) - (L1 = L264) - (L1 = L265) - (L1 = L266) - (L1 = L267) - (L1 = L268) - (L1 = L269) - (L1 = L270) - (L1 = L271) - (L1 = L272) - (L1 = L273) - (L1 = L274) - (L1 = L275) - (L1 = L276) - (L1 = L277) - (L1 = L278) - (L1 = L279) - (L1 = L280) - (L1 = L281) - (L1 = L282) - (L1 = L283) - (L1 = L284) - (L1 = L285) - (L1 = L286) - (L1 = L287) - (L1 = L288) - (L1 = L289) - (L1 = L290) - (L1 = L291) - (L1 = L292) - (L1 = L293) - (L1 = L294) - (L1 = L295) - (L1 = L296) - (L1 = L297) - (L1 = L298) - (L1 = L299) - (L1 = L300) - (L1 = L301) - (L1 = L302) - (L1 = L303) - (L1 = L304) - (L1 = L305) - (L1 = L306) - (L1 = L307) - (L1 = L308) - (L1 = L309) - (L1 = L310) - (L1 = L311) - (L1 = L312) - (L1 = L313) - (L1 = L314) - (L1 = L315) - (L1 = L316) - (L1 = L317) - (L1 = L318) - (L1 = L319) - (L1 = L320) - (L1 = L321) - (L1 = L322) - (L1 = L323) - (L1 = L324) - (L1 = L325) - (L1 = L326) - (L1 = L327) - (L1 = L328) - (L1 = L329) - (L1 = L330) - (L1 = L331) - (L1 = L332) - (L1 = L333) - (L1 = L334) - (L1 = L335) - (L1 = L336) - (L1 = L337) - (L1 = L338) - (L1 = L339) - (L1 = L340) - (L1 = L341) - (L1 = L342) - (L1 = L343) - (L1 = L344) - (L1 = L345) - (L1 = L346) - (L1 = L347) - (L1 = L348) - (L1 = L349) - (L1 = L350) - (L1 = L351) - (L1 = L352) - (L1 = L353) - (L1 = L354) - (L1 = L355) - (L1 = L356) - (L1 = L357) - (L1 = L358) - (L1 = L359) - (L1 = L360) - (L1 = L361) - (L1 = L362) - (L1 = L363) - (L1 = L364) - (L1 = L365) - (L1 = L366) - (L1 = L367) - (L1 = L368) - (L1 = L369) - (L1 = L370) - (L1 = L371) - (L1 = L372) - (L1 = L373) - (L1 = L374) - (L1 = L375) - (L1 = L376) - (L1 = L377) - (L1 = L378) - (L1 = L379) - (L1 = L380) - (L1 = L381) - (L1 = L382) - (L1 = L383) - (L1 = L384) - (L1 = L385) - (L1 = L386) - (L1 = L387) - (L1 = L388) - (L1 = L389) - (L1 = L390) - (L1 = L391) - (L1 = L392) - (L1 = L393) - (L1 = L394) - (L1 = L395) - (L1 = L396) - (L1 = L397) - (L1 = L398) - (L1 = L399) - (L1 = L400) - (L1 = L401) - (L1 = L402) - (L1 = L403) - (L1 = L404) - (L1 = L405) - (L1 = L406) - (L1 = L407) - (L1 = L408) - (L1 = L409) - (L1 = L410) - (L1 = L411) - (L1 = L412) - (L1 = L413) - (L1 = L414) - (L1 = L415) - (L1 = L416) - (L1 = L417) - (L1 = L418) - (L1 = L419) - (L1 = L420) - (L1 = L421) - (L1 = L422) - (L1 = L423) - (L1 = L424) - (L1 = L425) - (L1 = L426) - (L1 = L427) - (L1 = L428) - (L1 = L429) - (L1 = L430) - (L1 = L431) - (L1 = L432) - (L1 = L433) - (L1 = L434) - (L1 = L435) - (L1 = L436) - (L1 = L437) - (L1 = L438) - (L1 = L439) - (L1 = L440) - (L1 = L441) - (L1 = L442) - (L1 = L443) - (L1 = L444) - (L1 = L445) - (L1 = L446) - (L1 = L447) - (L1 = L448) - (L1 = L449) - (L1 = L450) - (L1 = L451) - (L1 = L452) - (L1 = L453) - (L1 = L454) - (L1 = L455) - (L1 = L456) - (L1 = L457) - (L1 = L458) - (L1 = L459) - (L1 = L460) - (L1 = L461) - (L1 = L462) - (L1 = L463) - (L1 = L464) - (L1 = L465) - (L1 = L466) - (L1 = L467) - (L1 = L468) - (L1 = L469) - (L1 = L470) - (L1 = L471) - (L1 = L472) - (L1 = L473) - (L1 = L474) - (L1 = L475) - (L1 = L476) - (L1 = L477) - (L1 = L478) - (L1 = L479) - (L1 = L480) - (L1 = L481) - (L1 = L482) - (L1 = L483) - (L1 = L484) - (L1 = L485) - (L1 = L486) - (L1 = L487) - (L1 = L488) - (L1 = L489) - (L1 = L490) - (L1 = L491) - (L1 = L492) - (L1 = L493) - (L1 = L494) - (L1 = L495) - (L1 = L496) - (L1 = L497) - (L1 = L498) - (L1 = L499)
Cutting this to 251 bars ago gets you to Medium and 26 bars gets you to Fast.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Wow!
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Your "L1 equals previous lows" works in an Easy Scan and very well as as Column since the Column Value shows HOW MANY HITS there are.
Question: When the Column Count is 1.00, does this mean there are no L1 equal to a Previous Low in 499 bars?
Or, does L1 equal one other Low in those 499 bars?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If the result is 1, then L1 equals exactly on of the lows in the previous 498 bars (the low of 499 bars ago is only 298 prior to the low of 1 bar ago).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 1,178
|
Thanks.
Now, can you please provide the same 499 period indicator for H1 equalling Previous Highs?
|
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Just change all of the L's to H's.
ABS(H1 = H2) - (H1 = H3) - (H1 = H4) - (H1 = H5) - (H1 = H6) - (H1 = H7) - (H1 = H8) - (H1 = H9) - (H1 = H10) - (H1 = H11) - (H1 = H12) - (H1 = H13) - (H1 = H14) - (H1 = H15) - (H1 = H16) - (H1 = H17) - (H1 = H18) - (H1 = H19) - (H1 = H20) - (H1 = H21) - (H1 = H22) - (H1 = H23) - (H1 = H24) - (H1 = H25) - (H1 = H26) - (H1 = H27) - (H1 = H28) - (H1 = H29) - (H1 = H30) - (H1 = H31) - (H1 = H32) - (H1 = H33) - (H1 = H34) - (H1 = H35) - (H1 = H36) - (H1 = H37) - (H1 = H38) - (H1 = H39) - (H1 = H40) - (H1 = H41) - (H1 = H42) - (H1 = H43) - (H1 = H44) - (H1 = H45) - (H1 = H46) - (H1 = H47) - (H1 = H48) - (H1 = H49) - (H1 = H50) - (H1 = H51) - (H1 = H52) - (H1 = H53) - (H1 = H54) - (H1 = H55) - (H1 = H56) - (H1 = H57) - (H1 = H58) - (H1 = H59) - (H1 = H60) - (H1 = H61) - (H1 = H62) - (H1 = H63) - (H1 = H64) - (H1 = H65) - (H1 = H66) - (H1 = H67) - (H1 = H68) - (H1 = H69) - (H1 = H70) - (H1 = H71) - (H1 = H72) - (H1 = H73) - (H1 = H74) - (H1 = H75) - (H1 = H76) - (H1 = H77) - (H1 = H78) - (H1 = H79) - (H1 = H80) - (H1 = H81) - (H1 = H82) - (H1 = H83) - (H1 = H84) - (H1 = H85) - (H1 = H86) - (H1 = H87) - (H1 = H88) - (H1 = H89) - (H1 = H90) - (H1 = H91) - (H1 = H92) - (H1 = H93) - (H1 = H94) - (H1 = H95) - (H1 = H96) - (H1 = H97) - (H1 = H98) - (H1 = H99) - (H1 = H100) - (H1 = H101) - (H1 = H102) - (H1 = H103) - (H1 = H104) - (H1 = H105) - (H1 = H106) - (H1 = H107) - (H1 = H108) - (H1 = H109) - (H1 = H110) - (H1 = H111) - (H1 = H112) - (H1 = H113) - (H1 = H114) - (H1 = H115) - (H1 = H116) - (H1 = H117) - (H1 = H118) - (H1 = H119) - (H1 = H120) - (H1 = H121) - (H1 = H122) - (H1 = H123) - (H1 = H124) - (H1 = H125) - (H1 = H126) - (H1 = H127) - (H1 = H128) - (H1 = H129) - (H1 = H130) - (H1 = H131) - (H1 = H132) - (H1 = H133) - (H1 = H134) - (H1 = H135) - (H1 = H136) - (H1 = H137) - (H1 = H138) - (H1 = H139) - (H1 = H140) - (H1 = H141) - (H1 = H142) - (H1 = H143) - (H1 = H144) - (H1 = H145) - (H1 = H146) - (H1 = H147) - (H1 = H148) - (H1 = H149) - (H1 = H150) - (H1 = H151) - (H1 = H152) - (H1 = H153) - (H1 = H154) - (H1 = H155) - (H1 = H156) - (H1 = H157) - (H1 = H158) - (H1 = H159) - (H1 = H160) - (H1 = H161) - (H1 = H162) - (H1 = H163) - (H1 = H164) - (H1 = H165) - (H1 = H166) - (H1 = H167) - (H1 = H168) - (H1 = H169) - (H1 = H170) - (H1 = H171) - (H1 = H172) - (H1 = H173) - (H1 = H174) - (H1 = H175) - (H1 = H176) - (H1 = H177) - (H1 = H178) - (H1 = H179) - (H1 = H180) - (H1 = H181) - (H1 = H182) - (H1 = H183) - (H1 = H184) - (H1 = H185) - (H1 = H186) - (H1 = H187) - (H1 = H188) - (H1 = H189) - (H1 = H190) - (H1 = H191) - (H1 = H192) - (H1 = H193) - (H1 = H194) - (H1 = H195) - (H1 = H196) - (H1 = H197) - (H1 = H198) - (H1 = H199) - (H1 = H200) - (H1 = H201) - (H1 = H202) - (H1 = H203) - (H1 = H204) - (H1 = H205) - (H1 = H206) - (H1 = H207) - (H1 = H208) - (H1 = H209) - (H1 = H210) - (H1 = H211) - (H1 = H212) - (H1 = H213) - (H1 = H214) - (H1 = H215) - (H1 = H216) - (H1 = H217) - (H1 = H218) - (H1 = H219) - (H1 = H220) - (H1 = H221) - (H1 = H222) - (H1 = H223) - (H1 = H224) - (H1 = H225) - (H1 = H226) - (H1 = H227) - (H1 = H228) - (H1 = H229) - (H1 = H230) - (H1 = H231) - (H1 = H232) - (H1 = H233) - (H1 = H234) - (H1 = H235) - (H1 = H236) - (H1 = H237) - (H1 = H238) - (H1 = H239) - (H1 = H240) - (H1 = H241) - (H1 = H242) - (H1 = H243) - (H1 = H244) - (H1 = H245) - (H1 = H246) - (H1 = H247) - (H1 = H248) - (H1 = H249) - (H1 = H250) - (H1 = H251) - (H1 = H252) - (H1 = H253) - (H1 = H254) - (H1 = H255) - (H1 = H256) - (H1 = H257) - (H1 = H258) - (H1 = H259) - (H1 = H260) - (H1 = H261) - (H1 = H262) - (H1 = H263) - (H1 = H264) - (H1 = H265) - (H1 = H266) - (H1 = H267) - (H1 = H268) - (H1 = H269) - (H1 = H270) - (H1 = H271) - (H1 = H272) - (H1 = H273) - (H1 = H274) - (H1 = H275) - (H1 = H276) - (H1 = H277) - (H1 = H278) - (H1 = H279) - (H1 = H280) - (H1 = H281) - (H1 = H282) - (H1 = H283) - (H1 = H284) - (H1 = H285) - (H1 = H286) - (H1 = H287) - (H1 = H288) - (H1 = H289) - (H1 = H290) - (H1 = H291) - (H1 = H292) - (H1 = H293) - (H1 = H294) - (H1 = H295) - (H1 = H296) - (H1 = H297) - (H1 = H298) - (H1 = H299) - (H1 = H300) - (H1 = H301) - (H1 = H302) - (H1 = H303) - (H1 = H304) - (H1 = H305) - (H1 = H306) - (H1 = H307) - (H1 = H308) - (H1 = H309) - (H1 = H310) - (H1 = H311) - (H1 = H312) - (H1 = H313) - (H1 = H314) - (H1 = H315) - (H1 = H316) - (H1 = H317) - (H1 = H318) - (H1 = H319) - (H1 = H320) - (H1 = H321) - (H1 = H322) - (H1 = H323) - (H1 = H324) - (H1 = H325) - (H1 = H326) - (H1 = H327) - (H1 = H328) - (H1 = H329) - (H1 = H330) - (H1 = H331) - (H1 = H332) - (H1 = H333) - (H1 = H334) - (H1 = H335) - (H1 = H336) - (H1 = H337) - (H1 = H338) - (H1 = H339) - (H1 = H340) - (H1 = H341) - (H1 = H342) - (H1 = H343) - (H1 = H344) - (H1 = H345) - (H1 = H346) - (H1 = H347) - (H1 = H348) - (H1 = H349) - (H1 = H350) - (H1 = H351) - (H1 = H352) - (H1 = H353) - (H1 = H354) - (H1 = H355) - (H1 = H356) - (H1 = H357) - (H1 = H358) - (H1 = H359) - (H1 = H360) - (H1 = H361) - (H1 = H362) - (H1 = H363) - (H1 = H364) - (H1 = H365) - (H1 = H366) - (H1 = H367) - (H1 = H368) - (H1 = H369) - (H1 = H370) - (H1 = H371) - (H1 = H372) - (H1 = H373) - (H1 = H374) - (H1 = H375) - (H1 = H376) - (H1 = H377) - (H1 = H378) - (H1 = H379) - (H1 = H380) - (H1 = H381) - (H1 = H382) - (H1 = H383) - (H1 = H384) - (H1 = H385) - (H1 = H386) - (H1 = H387) - (H1 = H388) - (H1 = H389) - (H1 = H390) - (H1 = H391) - (H1 = H392) - (H1 = H393) - (H1 = H394) - (H1 = H395) - (H1 = H396) - (H1 = H397) - (H1 = H398) - (H1 = H399) - (H1 = H400) - (H1 = H401) - (H1 = H402) - (H1 = H403) - (H1 = H404) - (H1 = H405) - (H1 = H406) - (H1 = H407) - (H1 = H408) - (H1 = H409) - (H1 = H410) - (H1 = H411) - (H1 = H412) - (H1 = H413) - (H1 = H414) - (H1 = H415) - (H1 = H416) - (H1 = H417) - (H1 = H418) - (H1 = H419) - (H1 = H420) - (H1 = H421) - (H1 = H422) - (H1 = H423) - (H1 = H424) - (H1 = H425) - (H1 = H426) - (H1 = H427) - (H1 = H428) - (H1 = H429) - (H1 = H430) - (H1 = H431) - (H1 = H432) - (H1 = H433) - (H1 = H434) - (H1 = H435) - (H1 = H436) - (H1 = H437) - (H1 = H438) - (H1 = H439) - (H1 = H440) - (H1 = H441) - (H1 = H442) - (H1 = H443) - (H1 = H444) - (H1 = H445) - (H1 = H446) - (H1 = H447) - (H1 = H448) - (H1 = H449) - (H1 = H450) - (H1 = H451) - (H1 = H452) - (H1 = H453) - (H1 = H454) - (H1 = H455) - (H1 = H456) - (H1 = H457) - (H1 = H458) - (H1 = H459) - (H1 = H460) - (H1 = H461) - (H1 = H462) - (H1 = H463) - (H1 = H464) - (H1 = H465) - (H1 = H466) - (H1 = H467) - (H1 = H468) - (H1 = H469) - (H1 = H470) - (H1 = H471) - (H1 = H472) - (H1 = H473) - (H1 = H474) - (H1 = H475) - (H1 = H476) - (H1 = H477) - (H1 = H478) - (H1 = H479) - (H1 = H480) - (H1 = H481) - (H1 = H482) - (H1 = H483) - (H1 = H484) - (H1 = H485) - (H1 = H486) - (H1 = H487) - (H1 = H488) - (H1 = H489) - (H1 = H490) - (H1 = H491) - (H1 = H492) - (H1 = H493) - (H1 = H494) - (H1 = H495) - (H1 = H496) - (H1 = H497) - (H1 = H498) - (H1 = H499)
|
|
Registered User Joined: 5/23/2006 Posts: 75
|
Yes you can!
CountTrue(L'05/31/2017'=L, 499) - 1
You have to modify it every day though.
|
|
Guest-1 |