Techniques & Tips: Scanner

Here's a way to get scanner output reports in spreadsheet format. It takes some one-time setup work. Once that's done it only takes a few clicks to have the scanner report in a spreadsheet where it can be analyzed, sorted, prioritized ....

Lotus and Open Office Calc are the spreadsheets I use, but the process should be similar for other programs.

• Step One: Save the Scanner Results. They are .esr files (text) located in a
  Refined Elliott Trader sub-directory named ScanSessions.
• Step Two: Open the .esr file with a text editor such as NotePad.
• Step Three: Copy the data from the text editor and paste it into your workbook
  spreadsheet. You'll probably have to use one of the "Paste Special" sub-
  commands so that your spreadsheet program accepts it in the proper format.
  Consider this the "Raw Data" spreadsheet.
• Step Four: Once the "Raw Data" is in one of your workbook spreadsheets, copy
  only the cells you want in your "Final Data" spreadsheet. You'll have to use
  another "Paste Special" sub-command so that the new cells in the "Final Data"
  spreadsheet are "linked" to the corresponding "Raw Data" cells.
• Step Five: Maneuver the "Final Data" cells so the spreadsheet meets your
  requirements.
• Four and Five are the only step that take much time -- but they're only done once.

Then, when you have new scanner results, follow Steps One, Two and Three to put
them in the "Raw Data" spreadsheet. Immediately take your results from the "Final
Data" Spreadsheet.