Compare two lists for non duplicates

ipsofacto
ipsofacto ✭
in Scanning
I would like to figure out how to compare two stock lists, so that the results only show the positions in the lists that are not common. Example: List 1 holds, XOM, IBM, CSCO; List 2 holds XOM, IBM, AAPL. The results are only CSCO and AAPL.

Best Answer

  • markd
    markd mod
    edited October 2017 Answer ✓
    I haven't tested this. You would need ALL the brackets, I think:

    [
    [ [favorites list is 1] and [favorites list is not 2] ]

    or

    [ [favorites list is 2] and [favorites list is not 1] ]
    ]

Answers

  • markd
    markd mod
    You could try it in Excel. Down load each list as a CSV, save as an Excel file, copy one list to the other sheet. Then for comparison methods, google "excel compare two lists".

    To download the lists, run a scan against each list that has just the line {favorites list is ...] Create each scan by selecting the list from the Chart Lists drop down. On the results page, select "Download as CSV" from the option window.
  • ipsofacto
    ipsofacto ✭
    so just to be clear, that's the only option? there is no can operator that would exclude common names between two lists in the advanced scan workbench? thanks!
  • markd
    markd mod
    edited October 2017
    There is no operator in SC that does that, that I know of.

    All operators are listed here:

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


Categories