Gold Customer
Joined: 3/8/2018 Posts: 30
|
Hello
How can i search for gap ups/down in longer time frame..ofcourse with a fixed percent of $dollar size.
example
1) gap up/down 15% in last 6 months
2) gap up $10 in last in last 3 months.
etc..
thanks
Dipan
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Assuming the gap is between the previous close and current open, a gap up or down of at least 15% in the last 6 monhts could be written as follows.
CountTrue(ABS(O / C1 - 1) >= .15, 126) > 0
And a gap up of at least $10 in the last 3 months could be written as follows.
CountTrue(O >= C1 + 10, 63) > 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|