How do I get just stocks and not etf's

Try this:

and [group is not etf]

If you haven't already, check out the new, expanded and re-organized documentation under the support tab. Here's a link to the advanced scan syntax section:

stockcharts.com/docs/doku.php?id=scans:advanced_scan_syntax