Best of s.c.a.n.

« Previous Article | Top | Next Article »

Best of s.c.a.n. is an ongoing collection of the the best responses to the questions submitted to our StockCharts Answer Network. Selected by our customer support team and s.c.a.n. editors, these responses are the answers to your questions that we wish we'd written ourselves.

If you have a question you'd like to ask the StockCharts community, please visit the s.c.a.n. homepage. You can create your s.c.a.n. account and submit the question from there.

Create "AND/OR" Criteria with the Advanced Scan Workbench

 

The Standard Scan Workbench can apply a criteria to just ONE single day, such as just today or just yesterday. It cannot search both today and yesterday. However, the SC support staff says that the Advanced Scan Workbench has the capacity for a 2-day search by using the “and/or” criteria to run the criteria against today's data OR yesterday's. But I cannot find the OR button anywhere. Can anyone tell me how to write criteria for an advanced scan in which the Plus DI line crosses above the Minus DI line for either today OR yesterday?

Bill Scott

 

You are correct there is no button for the OR function. By default, the And function is used whenever you insert something into your scan. Just manually change it to OR. However, be careful how you use it.

Here's an example. Note how I nested the OR inside an extra set of brackets so it applies only to the two DI clauses.

Also, I used a price bracket—Close between 10 and 20—just for scan checking: it reduces the output. Running it now, I get 216 stocks that crossed today, and then running it with today's or yesterday's crosses, I get 422 stocks.


[close > 10]
and [close <20]
and [ [Plus DI(14) x Minus DI(14)] or [1 day ago Plus DI(14) x 1 day ago Minus DI(14)] ]

 

I hope this gives you some other ideas.

Gord

To see all the responses to this question, go to the original post on s.c.a.n.

To read other questions and answers or to submit your own questions, please visit the s.c.a.n. homepage.

« Previous Article | Top | Next Article »

Other StockCharts Blogs

Subscribe to this blog