get specific column outputs in scan results

splash88

If you use "Bullish MACD Crossovers" under predefined scans the output will contain a column "Daily MACD line". That column does not exist if you run the same scan manually. The ability to sort output by specific indicator values could be very useful. We are just using MACD cross as an example. I could be many other indicators. How do you modify the out put results to contain the data column you want. It must be possible because the Pre-defined seems to do it for MACD, ADX, CCI when those are the scan criteria. How can I do that manually? Thank you.

markd

You can use the "rank by" statement, which must appear as the last statement of your scan.

Here is a blog from Chip that explains it.

stockcharts.com/articles/mailbag/2014/06/ranking-a-group-of-stocks-by-percent-change.html?st=rank+by+statement

Also this link to a Support page, about half way down:

stockcharts.com/docs/doku.php?st=%27rank+by%27&id=scans:advanced_scan_syntax

splash88

Thanks. That's great