The SortWizard ®     
Stock Screening Software  

Using the Tony Oz Scanner with the SortWizard

The SortWizard can add many other features and capabilities to the Tony Oz scanner (symbol chain).  The fact is, we are just going to use the the RealTick symbol chain results as the data input to the SortWizard.  Then all the capabilities of the SortWizard are at your fingertips.

The help in this section assumes you have a basic understanding of the operation of the SortWizard.  If you don't, please go to the Learning Center and run through the tutorial first.  Some of the reference information listed below are edited excerpts from the Learning Center and Operating Instructions in the SortWizard web site.

Make sure you read the disclaimer at the bottom of this page before proceeding.

Tony Oz Scanner reference list
Setting up using the Tony Oz scanner symbol chain
Setting up the time the symbol first entered
Isolating a new scan symbol entry
Getting news on a symbol
Keeping interesting trade candidates
Ignoring symbols
Linking to a MarketMarker and to Charts
Creating Formulas and Limits

Download a generic sample file.  Make sure you save the TOzScanner.STK sample file into the SortWizard folder.  If you let the SortWizard install itself without modifications, the default folder you would use is c:\program files\neo inc\sortwizard.
 

SortWizard reference list
Column/Field Definitions
Learning Center
Operating Instructions
Plus Reference Center

Resource Center
 


Setting up the Tony Oz scanner symbol chain

Go to the Primary Criteria tab in the Search Parameters setup window.  Click on "Symbol" in the Available fields column to select it.  In the Search Criteria section click the down arrow on the right.  Click on the "Symbol Chain" selection.  In the empty dialog box below type in any one of the following symbols chains:

 
  Bottom Fisher

  Gapper

  Knock Down

  New Kid

  Power Trader

  Sky Scraper

  Usual Suspects

  9 1/2 weeks

  10 1/2 weeks
 

 
  $BOTFSHR-N
  $BOTFSHR-Q
  $GAPER-N
  $GAPER-Q
  $KNOCKDN-N
  $KNOCKDN-Q
  $NEWKID-N
  $NEWKID-Q
  $PWRTRDR-N
  $PWRTRDR-Q
  $SKYSCRP-N
  $SKYSCRP-Q
  $SUSPECT-N
  $SUSPECT-Q
  $9WEEKS-N
  $9WEEKS-Q
  $10WEEKS-N
  $10WEEKS-Q
 

 

 

 

 

 

 

 

 

 

To the top of the Page


Isolating a new scan symbol entry

This function identifies a new symbol added to the list from a scan.  When a new entry arrives in the scan results display a result of "1" or "0".  Simply sort the column in descending order to display all the new entrant symbols at the top of the list.  A critical factor to consider is the definition of a new entrant.  To set the definition, go to the Settings tab in Search Parameters Setup.  In the Event Sounds section on the far right there is the "New Item" interval  with a "New after X searches" caption.  What this means is that the symbol will be reset after "X" number of consecutive earches that it no longer qualifies to the criteria of the scan.  The default is 10.  What the means is that once the symbol come up as a new entrant then it must no longer qualify for 10 consecutive scans, then on the 11th scan it would then be consider an new entrant candidate.

To use this function as described above.  Go to the Formula tab in Search Parameters Setup.  Click the Add button to create a new formula.  Name it "NewStock"  Click Accept.  In the formula bar after the "=" type: "ISNEW()" in the blank bar.  In the Selected Fields column you will find NewStock at the bottom of the list.  Click the box in from of NewStock so the results will be displayed from your scan using this function.  Run a scan.  When you look for the results you will find them displayed is the last column to the right.  You can move the column by left clicking on the column heading and clicking and holding the button down and dragging the column to the position of your choice.  Right click on the column heading and set the Primary sort to "Descending".   You can modify how the column is displayed in the Column Display tab in Search Parameters Setup.
    
1 = this symbol is new entrant the most recent search  
0 = this item is not new entrant 

To the top of the Page


Setting up the time the symbol first entered

We are going to create two formulas.  One to show the time the new symbol's entry and another to show the scan count number in which that symbol entered.

Go to the Formulas tab in Search Parameters setup.  Create a new formula by clicking on the Add  button.  Name the field "NSTime".   Select Data Type: "Time".  Accept the formula.  Check the box in front of the new formula in the Selected Fields column.  Now, in the formula bar click to the right of the "=" then type the following: IF(ISNEWS(),NOW,NOCHANGE).  
Create another new formula by clicking on the Add  button.  Name the field "NSCount".  Accept the formula.  Check the box in front of the new formula in the Selected Fields column.  In the formula bar to the right of the "=" click then type the following: SEARCHIDFIRST().

You will now have two new columns added to your search results display.  Move the columns to the location you would like to see them.  You can modify their appearance under the Column Display tab of Search Parameters setup.

 

To the top of the Page


Ignoring symbols

Let’s assume you have analyzed a symbol and would like to eliminate it from subsequent scan results.  Select a scan of your choice.  Initiate the scan by clicking on the “Binoculars” icon on the toolbar.  Right click on your chosen symbol from the list of stocks displayed. That will spawn a list box. Left click on “Ignore Symbols”.  Select “Ignore Symbol Local”. That will place the symbol you selected in an ignore list. That symbol will no longer show up in the scan until you close the scan file.  When the file is closed, all locally ignored symbols will be restored.  If you would like to remove a symbol permanently, select “Ignore Symbol Globally”.  If you have click the "Use the file below" option under the Global Settings tab in the Search Parameters Setup, the symbols you selected we be permanently saved in the default Global Attributes.slf file.  You can edit the global list by checking the box in front of symbol(s) you wish to restore and then click the “Remove checked items” button.

To the top of the Page


Getting news on a symbol

Here's how to use the SortWizard's direct link to news.  Right click on any symbol from the list of stocks displayed from you scan.  That will spawn a list box. Left click on “Web Links”.  Select “Yahoo Investments”.  That will display the latest news about the symbol you selected in the integrated browser in the lower section of the SortWizard.  If you don't want to use the integrated browser you can configure the SortWizard to open a separate session of your browser instead.  In menu bar select "View" and uncheck  “Show Internet Explorer window” .

The purpose of the integrated browser window is to inform you of new features, developments and updates regarding the SortWizard.  So, after we show you how to turn it off, you might want to check back from time to time to see if there is something new being announced.  

To the top of the Page


Keeping selected symbols to a basket

The keep symbols that are interesting candidates together you can move them out of the upper display section of the search results into the lower section called the basket.  What this enable you to do is search in the upper section and store symbols in the basket.  To move symbols to the lower section of the results display click on the symbol then clicking on the arrowdown.gif (876 bytes) on the toolbar. The symbol selected will be moved to the lower section.  You can select a group of symbols to move into the basket by clicking on the row number of the first symbol in the group to highlight it, then hold down <Shift> key and while keeping the <Shift> key depressed, left click on the row number of the symbol at the other end of the group. This should highlight the desired group of stocks. Then click on the arrowdown.gif (876 bytes) on the toolbar. Those highlighted symbols should move down into your basket. You could click the (ALL) all.gif (898 bytes) button on the toolbar if you want all of the entries in the upper window to be placed in the basket

The Smart Refresh function of the SortWizard will enable searches to be run in the upper section and symbols you have placed in the lower section (basket) to be updated all at the same time.

Right clicking in the display area of the upper or lower section will open up a list box with many functions that can be used to administrate the sections.

From more information on exporting the basket and other uses of the basket refer to #3, #4 and #11in the Operating Instructions.

To the top of the Page


Linking to a Market Marker window and to Charts

You can link the SortWizard directly to RealTick's MarketMakers and Charts.  To link the symbol you selected in the SortWizard search results dsiplay to a Market Maker window of your choice select a symbol from the list of scan results by clicking on the stock symbol.  That should highlight the entire row for that symbol.  On the SortWizard’s toolbar locate the icon that looks like a miniature Level 2 window with a “1” in it .  When you move your mouse arrow over the icon, a prompt will pop up that says “RealTick MarketMaker 1”.  Left click on that icon.  A window will open named “MarketMaker 1 Setup”.  Select the Level 2 you wish to direct symbols to from the list displayed by clicking on one of the MarketMarker windows listed.  Click “OK” The symbol you selected from the SortWizard should now be displayed in the Level 2 window you selected.

Once you have your target symbol set up all you need to do now is click on the symbol in the SortWizard and then click on the toolbar icon you set up above. Then symbols should now be displayed in your RealTick Level 2 window.

If you want to link to charts directly, repeat the process in the first paragraph above except select the RealTick Chart link icon that is the icon to the left of the one you used above.  The rest of the procedure is identical to what you performed for setting up a Market Marker link except that you can link multiple charts.  To link to multiple charts when selecting from the list of available charts list, press down and hold on the Ctrl key down and left click on the charts you want to link.  Then reelease the the Crtl key and click on the OK button.

If the above procedure does not work properly, it is because you have the Order Entry Screen (OES) opened for that specific Level 2 window.  Click on the target Market Maker, press the F7 key to close the OES.  Repeat the steps above to set the target Market Maker window. Once you have set the link Press F7 to open the OES.

To make the process even more efficient you can set up a shortcut key on your keyboard.  To do that click on the "Tools" in the menu bar and select "Keyboard Shortcuts".  From the Select a macro list box, select  Link:MarketMaker1 (MMaker1), click the "Create Shortcut" button at the bottom of the list box.  In the Assign Shortcut dialog box click in the field with "None" displayed.  Select a key from your keyboard like F4 or F5, click "OK" to assign the shortcut and the click "OK" to close the Shortcut Keys window.  Now you can use the shortcut key instead for the icon on the toolbar.

To the top of the Page


Saving searches in a Workspace

You can use Workspaces to make starting up the SortWizard easier.  This is much like a Page in RealTick.  To illustrate how this works, open up 2 to 4 searches. Position and size the searches so you can see them all (just like you would a RealTick page).  Now position the SortWizard on your screen where you like it located for everyday use and where you would like it to position itself upon opening the next time you start it up.  Click “Workspace” on the menu bar and select “Save Workspace As”.  Name your Workspace making sure it is saved in the SortWizard folder.  Click “Workspace” on the menu bar again and click on “Load Workspace on Start”.  This will place a check mark in front of the selection and then load the last Workspace you had open when you start the SortWizard up again.

You can set up as many Workspaces as you like. Open them by clicking on “Workspace” on the menu bar and select “Recent Workspaces” then click on the Workspace you would like to use.

To the top of the Page


Creating a search using Formulas and Limits 

We are going to create a search from scratch that will looks for stocks that have turned up from a downward trend.  To get started, click on the "Template Files"  tile in the file browser on the left of the SortWizard's display.  Select "Default".   Open the Parameters Setup window for the Default file.  Under the "Primary Criteria' tab select Chg Open and Net Chg and set both of those to be "Greater than or equal to" ".5".  This will eliminate stocks that are not sufficiently active at this point and also speed up the search.  Leave the Parameters window open.  Click on "File" in the Menu Bar, select "Save as" and name the search "Plus Pullback Reversal".

1. Adding required fields:  

In the Parameters Setup window for the Default file , click the "Add Field" tab.  In "Available Fields" select "SORTWIZARD" in the "Server" list box.  This displays all the fields available in the large list box below "Sub Type". There are presently two "Tables" for data to chose from.  For This example select the "TODAY" table.

From the list box below  "Sub Type".  Select "Avg Vol 20", click the button to move that field to the "Selected Fields" list box on the left.  Repeat this process for Mov Avg 10, Mov Ave 20 and Mov Ave 50.

Select the field "Days in a trend(Close)" and move that to the "Selected Fields" list box.  This field displays the number of sequential days a stock has moved up or down in a row.  In this example we are looking for stocks that have be down 3 or more days in a row.  Go to the Parameters Setup window, select "Days in a trend" and set the criteria to "Less than or equal to" and enter "-3" in Value 1 field.

2. Creating a Limit:

A Limit is a True / False conditional statement.  If the criteria is met (True), then the symbols that qualify are allowed to flow into the search.  If the criteria is not met (False), the the symbols are eliminated.

 First, we are going to set up some moving average limits.  Click on the "Limits" tab in Parameters Setup.  Click the button.  "New Limit" is displayed.  Click to the right of the "=" under "FORMULA=".  Double click on the Mov Ave 10, that places the field into the formula bar.  Type ">".  The double click on Mov Ave 50.  Your Limit should now look exactly like this in the formula bar: "=MA_10>MA_50".   Click the check box in front of the "New Limit"; the sets the Limit and makes it an active Limit.  Repeat this process to add the Limit Mov Ave 10 > Mov Ave 20.

Now we will set up an automatic volume ratchet.  This will set the minimum volume criteria at 20000 at the beginning of the day and ratchet it up to 300000 by the end of the day.  Click on the "Limits" tab in Parameters Setup.  Click the button.  "New Limit" is displayed.  Click to the right of the "=" under "FORMULA=". Double click on "Tot Vol".  Type ">".  Then type 20000, then "+" to add, then "(MKTOPENRATIO()*280000)"  Your Limit should now look exactly like this in the formula bar: "=ACVOL_1>20000+(MKTOPENRATIO()*280000)".  Click the check box in front of the "New Limit" to set the Limit and make it active.  Click here for MKTOPENRATIO() definition.  Check out the ISNEW() function while you are there.

3. Creating a formula:

We are going to create a formula that allows you to adjust the criteria for on pace volume. This formula will provide a reference of the current day's accumulated volume as compared to the historic average volume.  A result of "1" means that it is on pace, at the time of the search, to finish the day at the the average volume that is selected in the formula. 

In the Search Parameters Setup  window, select the " Formulas" tab.  Click the button.  Name your new formula in the blank FID (Field ID) Name field.  For this example "AvVol20pace".  Make sure " Data Type" is set to Decimal/Fraction.  Click the Accept button.   

In the Selected Fields list box, check the box in front of your new FID Name field "AvVol20pace".  This will make the Field viewable in the Primary Criteria Available Fields list box.  You will be setting the qualification criteria for the formula under the  " Primary Criteria" tab.

Just below the there is a check box that says: "When checked, double click... ".  Check that box to activate that function.  Click just to the right of the "fx =" in the formula line below (just like in Limits).  Double click on " Tot Vol" field in the Selected Fields list box.  That inserts "ACVOL_1".  Then type "/" to divide.  Then type "(" to set the order of operation for the division portion of the formula.  Now type  "MKTOPENRATIO()".  Type "*" to multiply.  Double click on "Avg Vol 20" field in the Selected Fields list box.  That will insert "AvgVol_20 into the formula bar.  Then type ")" to close the expression.  The completed formula should look like this: =ACVOL_1/(MKTOPENRATIO()* AvgVol_20).  Check your formula by clicking on the button.  If there is an error, this function will tell you the nature of the error and mark its location with a "^" in your formula.  Uncheck the check the box just below the that says: "When checked, double click... " to turn off the special inserting function.

As in spreadsheets, once you move to another area (a cell in Excel) the formula is saved.  There is no need to save at this point (although you can by clicking on the Save icon at the bottom Parameters Setup window).  Or, just click the " Primary Criteria" tab.  Then, select "AvVol20pace" from the Available Fields list box.  Go to the Search Criteria Setup box.  Select " Greater than......." and enter "1" in Value 1 field.  This will set the criteria to find stocks with trading volume on pace with their historic 20 day average volume.

Test the search to make sure the search runs.  Now save the search to make you retain your work.

This search can be modified in a number of ways to suit your specific requirements.  Try changing some of the variables to either tighten or loosen the parameters to return either less or more symbols or adjust for market conditions.

In case you are having trouble creating this search, download the file by clicking here.

To the top of the Page


* Disclaimer

The trading setups and strategies are intended for educational purposes and only for demonstrating SortWizard usage. Those who act in accordance with the contents and suggestions of this document or any other references linked to or from this page are acting on their own.   Each user of the setups is entirely responsible for his or her own actions, if any.  The user understands there could be errors in the setups and in the SortWizard software that could produce erroneous results.  The use of any of the supplied information, files, strategies, software, and etal supplied to you from anywhere in this web site, materials supplied to you from any other source and/or your reading of this document constitutes that you are in agreement with this disclaimer and exempts the author(s), IPS Technologies, Inc., and Neo Inc. from any liability or from any litigation under any circumstances.  If you do not agree with this disclaimer, it is the user's/reader's responsibility to refrain from taking action on anything detailed within this or any other document(s) referred to.