The SortWizard^® Operating Instructions

Other References:

• Column / Field Definitions 
• SortWizard Plus Reference Center  
• Screen Shots

• Seminar on the basic features and use of the SortWizard

• Tutorials using sample scans - Learning Center
• Other Sample Searches and Strategies - Resource Center
• Using the SortWizard with the Symbol Chains and the Tony Oz scanner

Installation:

Variable Value Entries can be whole numbers, decimals or fractions except as noted below in the column description.   You can select from 6 different variables.  These are:

• No Criteria Selected; No screening on this field
• Less than or equal to; < Value 1
• Greater than or equal to; > Value 1
• Equal to; = Value 1
• Between (Value 1) and (Value 2); The values > and < the two values entered.
• Outside (Value 1) and (Value 2); The values < and > the two values entered.

All search criteria variable entries are (< , >, between, =, outside) except as noted below.  The bold characters represent the default column heading labels.  The labels can be edited in the Search Parameters Window.

• Symbol - Stock Symbol;  Symbol mask ( A*, ????, A?), Symbol chain(s) ($GAPDN,$GAPUP, etc), Existing symbol from previous search, Symbol File (*.SLF,*.TXT)
• Last  Price - Trading Price or Last Traded Price
• Prev Close - Previous day's closing price
• Net Chg - Net change in price from previous day's close
• % Net Chg -  Percent net change from previous day's close
• Open Price - Current day's opening price
• Chg Open - Difference between the last trade price and the opening price; (Last Trade - Opening Price)
• % Chg Open - Percentage change in current price from open
• Tot Vol - Accumulated volume; (current day's total shares traded)
• Ave 3 Mo Vol - Average monthly volume for the last 3 months x 100,000.
• % 3 Mo Ave Vol - Percent of today's accumulated volume compared to the 3 month average.
• Gap - Opening price - Previous day's close
• % Gap - Percentage change of gap from previous day's close.
• Rng Day - Current day's trading range; High (current day) - Low (current day)
• % Rng(day) - Percent of the current day's trading range where the stock is presently trading; 0% = day's low; 100% = day's high
• Bid - Current Best Bid price
• Ask - Current Best Ask price
• Spread - Difference between the Ask and the Bid (Bid - Ask).
• High - Current day's high
• Low - Current day's low
• # High - Number of Intraday Highs
• # Low - Number of Intraday Lows
• 52High - 52 Week High
• 52Low - 52 Week Low
• Rng(52wk) - 52 Week trading range; High (52 week) -  Low (52 week)
• % Rng(52wk) - Percent of the 52 week trading range; (52 week); 0% = 52 week low;100% = 52 week high
• No. Trades - Number of trades; (current day's tick count)
• Avg Trd Size - Average share volume per trade; (current day)
• NetChgBid - Difference between the Current Best Bid and Previous day's close; used for premarket gap up detection.
• % NetChgBid - Percentage change between the Current Best Bid and Previous day's close; used for premarket gap up detection.
• NetChgAsk - Difference between the Current Best Ask and Previous day's close; used for premarket gap down detection.
• % NetChgAsk - Percentage change between the Current Best Ask and Previous day's close; used for premarket gap up detection.
• News Date - Date news was release to the data server; calendar e.g. 6/5/87; (< ,=, between, >, Today)
• News Time - Time news was release to the server; units = time e.g. 10:00 = 10:00AM, 14:00 = 2:00PM  EST
• Company Name - Full name of the company; units = not applicable; supplied by datafeed
• Exch - Stock Exchange (All, selected exchange - including Canadian exchanges; ALB, MON, and VAN); units = not applicable
• Is Active - Marker for active market instrument.  This is a field used to eliminate inactive symbols.  This means that something in the bid, ask or volume has changed during the day.  This generally should be set to "=1" or to "No criteria selected"
  

2.) Go to the menu bar and select (File | Open) and select from the list of Sample files. Double click on one of the Sample files to open it.  Click the button on the toolbar and check out the Search Parameters Setup window.  There are a number of navigation tabs at the top of the window.  Select the the Primary Criteria tab.  To see what criteria have been selected for the Sample file you opened, there is a summary at the bottom of that window titled "Search Criteria Summary".  When you are ready to create your own setup from scratch, click on the (New) icon or chose one of the Templates and then click .  It is recommended you use one of the existing Sample Setups found in until you have gone through these instructions one time and are more comfortable with the operation of the SortWizard.

3.) The Search Parameters Setup window is the heart of the program. In the Parameters Setup window you select and create all the search criterion.  You edit the searches criteria by clicking on a field name from the list in the Available Fields column or in the Search Criteria Summary.  In either case that will highlight the selected field in the Available Fields column.  Be careful not uncheck the field by removing the check in the box by clicking on the check box; that  will remove the column from your search display.  Go to the Search Criteria Setup dialog box on the left.  Click on the arrow at the right edge of the box.  TA selection of criteria to select will be displayed in a list box.  If you selected a field that is part of the Sample search you are using, you will see that is already contains the parameters.  Those parameters are show in the Summary window at the bottom of the Parameters Setup window for easy reference.  

In the the Parameters Setup window, you can set up the SortWizard to search automatically  on a timed interval by going to the Searching Mode area and selecting the Mode and the time period you desire in the Auto Period field (minutes:seconds).  Should you select any of those Modes, you will need to start the Mode by pressing the Go - Start Mode button   on the bottom of the Search Parameters Setup window.  The Smart Refresh 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 (#11 below).

You can set searches to Search on Startup which will initiate a search when the file is opened and/or to Start and Stop searching at a specific time.  This is setup in the Start and Stop Cycles area.  

You can rename column headings by editing the text in the Label field at the top of the Setup window.

The Field Info button displays the data source and field information on the field you have selected in the Available Fields column. 

4.) Click the Search button on the toolbar or at the bottom of the Parameters Setup window and the search will start.  To stop a search at any time, click on the Stop icon on the toolbar.  If you have not logged on to the data feed server you will prompted to do so at this time.  Once logged on the server, you may need to click on the button again to start the search.  When the search is running you can the status of the search in the Status Bar at the very bottom of the active display window.  The Status Bar displays the time of the last search, the searching mode you have selected, the number of search results returned, the number of symbols in the basket, the number of symbols retained/cached and the status of the search.  If you have the Audible Alert (#13 below) turned on, you will get the sound selected as the signal that it is completed the search and/or when new symbols have been returned from the search.

5.) Experiment with different search alternatives in the Search Parameters Setup window by left clicking on different fields in the  Available Fields column and changing the search properties in the Search Criteria Setup area by editing the associated values in the Value1 and/or Value2 field(s).  When you edit the values, the default edit mode is "Insert" except for the News Date and Time fields which are "Overtype".  Now, click on (Clear All Entries) on the toolbar to erase any previous search results.  Click and see the results of your newly edited search will start to appear.  For fast edits to the column, you can Right Click on the column heading in the Results Display to change the search parameters of that specific column.  There are other sample files for you the experiment with which can be found in the file browser on the left boarder of the SortWizard display window.  Click on the Templates and the User Files buttons to review the selections available or you can click on (File | Open) to review the list in the conventional manner.  A Tutorial can be found in the Learning Center and more advanced search examples are in the Resource Center on the web site.  Click to navigate to the SortWizard's website homepage.  You will find those two centers in the menu bar on the left.

6.) The results of a search are displayed in the upper region of the Search Results display window. If you would like to update the information in the display without adding new symbols to your list, click the (Refresh) button on the toolbar.  If you want to update the current list and add possible new entries, click the button.  Or, if you would like to create a new list, click the button and then or .

NOTE #1: Updating an existing list takes longer to perform because the software must look up each existing entry one at a time and update it.  To speed up the process of clicking the and then , the Icon on the toolbar will do these two steps for you with a single mouse click.
NOTE #2: You may get a "Symbol Display Limit" warning if you have set you your search criterion to wide.  From an analysis efficiency perspective, you should be setting up your searches to return less than 100 symbols.  The default limit is set to 1000 symbols.  Since the SortWizard works in layers, the display limit is reached in the first step of the data gathering process.  The purpose of this limit is to minimize unnecessary datafeed server strain especially when using the Auto Searching Modes.  This benefits not only you but fellow traders using the same datafeed service.  TIP: Try the "Outside" search criterion, increase your minimum volume, reduce the price range of the stocks or use Net Chg < or > 0.

7.) Go to the Search Results Display area where all the stock symbols appear from your recent search. Try sorting the columns in ascending or descending order by double clicking on a column heading once and then again to return the opposite sortation order.  You can nest the sorts by clicking on the least most significant column followed by the more significant columns.  Or, right click on the column heading and select the Primary or Secondary Sort and then whether you would like it in Ascending or Descending for each sort.  When you save the page the sort priority that was setup will be maintained. For example, try a sort by % Range Day as Primary and Descending and % Range 52 Week as Secondary and Descending.

8.) To personalize your search results display, you can:

• Set up the search results display for Label Name, column Alignment and Width, display type  in Decimals, Fractions or Percentage, up or down arrows for +/- values, use of commas, AutoColor for +/- (green/red) values and Precision by going to the Parameters Setup .  Click the Column Display Setup tab and then in the Column Setup section of the window make the desired changes in the appropriate fields. 
• Change the fonts and background of the display area by clicking on "View" in the menu bar and selecting Display Properties. Select the area (e.g. "Standard" for search results display area) you would like to modify in the "Styles" window and click "Change".  Click the Font, Color, Border or Alignment tab and make the modifications you desire from the list displayed specifically for that function.   Click OK.  At the "Styles" window you can save the personalized display setup as your default by checking the "Save as default" box.
• Move the column headings to where you would like them by left clicking the mouse, then click on the highlighted column and move the heading left or right to the desired location as shown by the vertical red place marker. Move groups of columns by left clicking, holding and dragging across the desired columns to highlight them and then release the button.  Left click in the highlighted area and drag the group to the desired location and release.  Lock in the column height by unchecking "Allow changing of row heights" in "View" on the menu bar 
• The Column Width can be adjusted by left clicking on the bar in between the column headings after the pointer arrow changes to a vertical bar with right and left arrows.   Then while holding down the mouse button, move the mouse right or left and releasing at the desired width.  The width also can be manually set in the Width field under the Column Display Setup tab.
• Change the Column Heading Height by clicking and holding on the line between the column and the first line of the data display in the Active Column. The pointer arrow will change to a horizontal bar with up and down arrows. You can then drag the line up or down and then releasing the at the desired height. 
• The Column Heading name can be edited by right clicking on the column heading, selecting Parameter Setup from the menu and in the Label area of the Parameters Window, edit the column heading name.
• Columns that you want to remain fixed when remaining columns are scrolled either right or left can be set (frozen) left most column first by right clicking on the column heading and then selecting Freeze from the menu.  Unfreezing the column will place it as the first column in the scrollable group.
• From "View" in the menu bar you can turn on or off the integrated Internet Explorer window by clicking "Show Internet Explorer window" to uncheck the function.  With IE unchecked, a separate IE session will spawn when you right click on a symbol and select "Web Links" and then select a web location.
• From "View" in the menu bar you can turn on or off the file browser window at the left of your symbol display window by clicking "Show file browser" to uncheck (turn off) the function. 
• Shrink the footprint of the SortWizard by unchecking the "Toolbars", "Status Bar".  Most functions you will need you can be found  by right clicking on the symbol display area and making a selection from the pop up window.

9.) If you are ready to save the changes you have made to the search parameters, save the file by going to menu bar and selecting File then Save As and give your revised search criterion a new name in the File Name field.  That new file can then be found for use later on in (File | Open) or in the User Files panel to the left of the search results display.  If you save changes made to the search parameters, but do not want to change the name of the file, you can do so by clicking on the (File | Save) icon.  If you click on File in the menu bar, the most recently used files can be found at the bottom of the list box that opens.

10.) Speed / time saving tips for fast analysis. Go to your Search Results window.

• To copy a symbol from the SortWizard’s search results to a MarketMaker window, left click the symbol then click on the icon on the toolbar.  The first time you do this, it will bring up a dialog box for you to select the MarketMaker you want to target for that icon.  Once that selection is performed, you will not need to reconfigure the icon unless you change the page or close the SortWizard.  To test if the link works just click the desired symbol is the SortWizard and click on the icon to initiate the change in the MakerMarket window.  You can add more MarketMaker targets by going to View then click on Toolbars and then Customize.  Select File, then the Commands tab, then RealTick and then select the MarketMaker 2 icon and drag that icon to the Toolbar.  Continue to drag the number of icons you need to the toolbar.  To keep the added icon(s) in your configuration they must be associated with a Workspace (#14 below).   Click on the "Workspace" menu item and save that search in a Workspace.  Open that Workspace the next you start the SortWizard.
  Note 1:  If your link does not work, make sure your Order Entry Screen associated with the Market Maker screen you selected is not up.  Press the F7 key to close the OES.  Once you have set the link Press F7 to open the OES.  
  Note 2:  Link all the charts you want to update at once in RealTick to one MarketMaker.  Then when you send a symbol from the SortWizard to RealTick everything changes in one operation for added simplicity and fast analysis.  To do that, just right click in the upper section of the MarketMaker window, select "Links" and then when the list box appears, press down and hold the CRTL key and select the charts that you want to link to that MarketMaker.
• To copy a symbol from the SortWizard’s search results to a Chart, left click the symbol then click on the icon on the toolbar.  The first time you do this, it will bring up a dialog box for you to select the Chart you want to target for that icon.  Once that is completed you will not need to reconfigure the icon unless you change your page or close the SortWizard.  From then on click the symbol and then the icon to paste the symbol in the Chart window.  You can add more Chart targets by going to View then click on Toolbars, File and Customize.  Select File, Commands Tab, RealTick and then select the Chart 2 icon and drag that icon to the Toolbar.  To keep the added icon(s) in your configuration they must be associated with a Workspace (#14 below).   Click on the Workspace menu item and save that search in a Workspace.  Open that Workspace the next you start the SortWizard.
• To copy a symbol from the SortWizard’s search results to a MarketMinder, left click the symbol to select it, move the mouse pointer into selected area, when the regular mouse arrow changes to a small arrow, left click again, hold and drag the symbol to the MarketMinder window and release.  This will add that symbol to the existing symbol list of the Market Minder. 
  Note: If your Symbol column is frozen, move to the right in the same row until you reach the first unfrozen column and initiate the drag and drop from there.
  
  To select a group of symbols, use the standard Windows function ("Crtl A" for ALL or you could click the (ALL) button on the toolbar or the Active column heading for ALL symbols.  To select individual symbols (rows), depress the  "Crtl" key and hold and click each symbol you wish to add to you list one at a time.  Or, click on the first row, depress the "Shift" key hold down and then click on last row the you want to select. Now, move your mouse pointer to the bottom of the column of highlighted rows move the pointer up from below until it changes to a small arrow with an attached box.  Click hold and drag the group to your minder and release.  You can also use "Crtl C", to copy the list you selected and then click in the target location and "Crtl V" to paste it into the target area.  You can also right click in the highlighted area, select "Copy to Clipboard" and at the bottom of the list in the MarketMinder window right click and paste. 
• Right click anywhere in the search results display area.  A pop up window will be displayed with the most commonly used functions of the SortWizard for quick execution.  This feature will also enable you to reduce the overall SortWizard display size by being able to turn off the View Toolbar function found under View in the Menu Bar.
• For quick links to news on the selected symbol, right click on the symbol, select Web links and select the news service form the list.  The link will be displayed in the SortWizard's integrated browser at the bottom of the display window.  When you click in the browser, the navigation toolbar will be activated in the SortWizard's toolbar.  You can move the toolbar by clicking on the left side of the toolbar and dragging it (or any toolbar) to where you want it located.  If you want to use a separate session of your browser instead, from "View" in the menu bar you can turn on or off the file browser window at the left of your symbol display window by clicking "Show file browser" to uncheck (turn off) the function.
• Use Keyboard Shortcuts to create hot keys to your favorite or most commonly used functions.  Go to "Tools", select "Keyboard Shortcuts" on the menu bar.  That opens up the the Shortcut Keys dialog box.  Click the function you want to set up as a hot key from the list box and then click the "Create Shortcut" button.  Select the key or key strokes you want the shortcut to use and click "OK".  Click form the Short Keys window to exit or create another hot key form that window.
• To move a toolbar, click in the double vertical bar in front of the toolbar where the arrow is located in  the sample toolbar , and while holding down the the left mouse button, drag the toolbar anywhere inside the SortWizard or on your desktop and release the button at the location you desire.
• Another time saving functions are called Ignore Symbol and Global Ignore. These functions will suppress the symbols you have reviewed and selected will and no longer display them in again in subsequent searches.  Local Ignore will only ignore symbols from the search from which you selected the symbol to ignore.  Global Ignore will ignore the symbols you selected the symbol to ignore in from ALL the searches you are running.  When you close the search page, the symbols in your Local Ignore list for that search will be deleted from the list.  The symbols you save in the Global Ignore list will be retained for all the searches you have open until you close the SortWizard application.  To save the Global Ignore list go to the Global Settings tab in the Search Parameters Setup, check the box at the top of the window "Use the file below......" and then type the name of the file you want to use like; Global Ignore List.slf" in the filed below.  Make sure you end the file name with ".slf".  Edit the Local Ignore list by first Clicking on the "Settings" Tab in Search Parameters Setup.  To remove a symbol from the list, check the box to the left of the symbol(s) to be removed from the list box on the right.  Then click on the "Remove Checked Items" under the list box.  Edit the Global Ignore list by first Clicking on the "Global Settings" Tab in Search Parameters Setup.  To remove a symbol from the list, check the box to the left of the symbol(s) to be removed from the list box on the right.  Then click on the "Remove Checked Items" under the list box.  The same procedure as with the Global Ignore list can be used with the Watch List.  The Watch List symbols will be saved together with in the Global Ignore symbols in the same file.  There is no need to create a separate file.

The SortWizard^® Operating Instructions
Continued

12.) The Automatic Update feature will require that you to setup the Searching Mode in the Search Parameters Setup window.

• Click on .   Find Searching Mode.  Select the Mode desired from the menu by clicking on the arrow.  Select the desire time interval in minutes and seconds (min:sec).  
• Press the Go - Start Mode button in bottom of the Parameters window to start the automatic function.
• If you click on , or in the toolbar, that will not start the Automatic Update function, it will only perform that specific function selected and stop.  If an Auto mode has been initiated already, the click on one of those icons will run the function selected and then return to the Auto mode timer interval.
• If you select the Auto Refresh Mode, the SortWizard will run a search in the upper display section and refresh the data for the symbols held in the lower section (basket).  Should you want to refresh only one section at any time, click in the the section you want to refresh and then click the on the toolbar.
• Selecting the Smart Refresh function will enable you to search in the upper display section and have your basket (lower section) updated with every search interval.
• To stop the Automatic Update function click and select the Manual Search option in the Searching Mode list box. 
• Automatic Timers can be set up to automatically start and stop at certain times, e.g. 15 minutes after the open and 15 minutes before the close, by checking the Start and Stop button to activate them and setting up the desired times (use your local machine time).
• With Automatic Search on Startup selected, when a search is opened it will automatically perform a Clear and Search and also initiate the Searching Mode you have selected.  If you would like to turn that on, go to Search Parameters Setup, then Primary Criteria Tab and click the the "Search on Startup" button.  This function needs to be turned on to automatically start any of the auto modes upon opening a search.  Otherwise, the Searching Mode can be initiated by clicking on the Search, Clear and Search or Refresh button.

13.) You can also set an audible alarm for when a new search results symbol entrant has been added to the display list.  Just click the (Speaker) button on the toolbar to turn on the audible sound. If you do not receive any audible alerts you may not have a *.wav table in the Sounds Properties section for Exclamation set up found in the Windows Control Panel – Sounds. You can also change the the Event Sounds by going to the Setting tab in the Parameters Setup window then go to Event Sounds and load in the desired *.wav file of your choice there.
Note 1:  If you have a Workspace (#14 below) open or have mulitple searches open, each search's sound can be turned on or off by selecting the active search window and clicking the .
Note 2:  Under the Settings tab is where you set up wav file there is also a field called "new after x searches".  This sets up the number of searches that must occur to reset a symbol as a new entry into the search.  For example, using the default setting of 10, 10 searches must occur without the reference symbol showing up in the search to initiate a sound when it reenters the the display.  This function is also used in the ISNEW() function of the Plus version.
Note 3:  Get a couple of *.wavs that sound ok for this application by visiting the Subscriber Center on our web site.

14.) Multiple search display pages can be saved as a group called a Workspace (see Workspace on menu bar). You can open a Workspace to load all the pages in a group at once.  For instance, you could have a Workspace for a group of different setups you use at the market open named "At Open" and another set of searches you have configured for "Mid-Morning" searches.  

• To set up a work space open the the searches you would like in that group. Position and size them how you would like them to appear when the Workspace is opened.  Set up any Auto Timers for the individual searches you desire to have that feature operational. Start their Timers.
• Go to "Workspace" on the menu bar.  Select "Save Workspace As", select the SortWizard folder as the "Save In" folder, name the Workspace in the "File Name" field and click the "Save" button.
• Open the Workspace by going to "Workspace" on the menu bar select "Open Workspace" and select the Workspace desired from the SortWizard folder.
• Automatic Searching Mode Startup:  Upon loading the Workspace or opening the SortWizard,  the Searching Mode functions that were previously checked with the Auto Start Time "On" AND the appropriate starting time entered and saved, will then automatically start up.  If you would like to get results immediately, you will need to click on the individual Search, Clear and Search or Refresh icons for each search page OR have the Automatic SEARCH (this is not a Refresh) on Startup function (see #11) activated.

15.)  The Plus version of the SortWizard adds some very powerful features to your trading tool kit. 

Formulas - A new display column is created with every new formula name you create.  When a search is run, the results of the formula calculation are displayed in that column.  Through the use of Formulas, you can create user-defined formulas that enable you set specific criteria for that formula via the Primary Criteria tab.  Then when you run a search only those stocks that qualify to the criteria set in Primary Criteria appear in the search results display window.  If no criteria are set, then the results of the calculation will be displayed for every symbol in the list.  

Creation of formulas uses the same convention and functions as used in Microsoft’s Excel spreadsheet application.  For a step by step example go to the Learning Center.  You can also go to the  Plus Reference Center for more information on creating formulas.  You should also check out the special functions that are available for use with the SortWizard Plus.  For general Excel usage questions, go to the Microsoft Office web site.

• To create a new formula, click the  button.  A window will appear prompting you for a FID Name, or a label, for your new field that will appear in the search results display window.  DO NOT start a name with a number, those are reserved for RealTick FIDs.  You should then select a Data Type.  If you are planning on creating a formula that will produce numerical results, you should select Decimal/Fractional.  Other selections are Date, Time and String (text).

• In order to add the fields that you want your formula to be based on, you need to select the check box located to the lower left of the Search Parameters Setup window, below the  button.  Once you have done that, you simply double click on the desired field in the Selected Fields list box in order to add it to your formula.  Then select the mathematical operation you wish to perform next and just keep repeating that process until the formula is completed. 

• Once you are finished editing your formula, click the button  to ensure that the syntax of your formula is correct.  If an error occurs a "/\" will appear where the error is located and the message will advise you of the type of error generated.

• If you want the field that contains the results of your formula to be displayed in the search results display window, click the check box next to your newly created field in the Selected Fields list box to the right.

• Click the  button to delete a formula.
• The Helper    

Limits - Limits are used to create user-defined filters.  When you run a search with active limits only those stocks that qualify to criteria you have set in conjunction with your Primary Criteria settings.  Creation of formulas again uses the same convention and functions as used in Microsoft’s Excel spreadsheet application.   Limits are very similar to formulas except there is no column associated with them.  If the value is positive, the criteria will allow the symbol to show up on the results display; otherwise, it will not show up.  Items are displayed based on a accumulation of these limits, all limits must be "True" for a symbol to show up like "=TRDPRC_1>10" is a good example of a Limit.  Limits will show up in the limits box on the left of the Limits dialog box, eventually they all will show up there. You can disable limits by un-checking the check box next to the limit.  For a step by step example go to the Learning Center.

• To create a new limit formula, click the  button.  A limit definition line will appear in the Column Information list box.  Create the limit formula in the same manner as in Formulas above by simply double clicking on the desired field in the Selected Fields list box in order to add it to your formula.  Then set the qualifying value using a =,<, > or etc.    

• In order to add the fields that you want your formula to be based on, you need to select the check box located to the lower left of the Search Parameters Setup window, below the  button.  Once you have done that, you simply double click on the desired field in the Selected Fields list box in order to add it to your formula.  Once you are finished editing your formula, click the  button in order to ensure that the syntax of your formula is correct.

• If you want the field that contains the results of your formula to be displayed in the Search Results Display Window, click the check box next to your newly created field in the Selected Fields list box to the right.

• Click the  button to delete a formula.

Add Field - The Add Field tab enables you to add and delete fields from your Primary Search Criteria Available Fields list box.  The Available Fields list found under the Add Field tab is a list of ALL the fields that are located on the server you select.  This lists will variety depending on what your data feed service provider / broker has chosen to support.  The accuracy of the data is a function of the frequency and level of maintenance the data supplier chooses to perform.  The Price service, LiveQuote, Calculations Server, Pre-defined Table and SortWizard fields are searchable .  If the fields are not searchable they will only display what specific information that is contained in the field e.g. a PE ratio, Shares Outstanding and etc. For a step by step example go to the Learning Center.

Go to the V2 Plus Reference Center for a Zipped file of know FIDs (Field IDs).  Since the file is rather large (200+ pages), we suggest you open the file in WordPad or a word processing application like Word so you can do a text search for the field(s) you are interested in locating.  Some of the fields listed may not be available from you data feed supplier and therefore will not be available for searches.  

Go to the SortWizard data fields in the Reference Center to see the list of currently available historic data fields.  There are two "Tables" of data to chose from; TODAY and HISTORIC.

To add a field to the Selected Fields list:

• Select the "Table" that the desired field list located and in the "Available Fields" list box below "Sub Type" click on the field to be added and then click the button with the arrows pointing left to add the field to the "Selected Fields" list box.

• To remove a field, click on the field to be removed in the "Selected Fields" list box and then click on the button with the arrows pointing right . 

• To have the added field displayed as a column in your search results, check the box to the left of the field in the "Selected Fields" list box.

16.) To print search results or your stock basket, first click either on the upper or lower section of the display page to select the information you wish to print.  Then go to File | Print.  Set up the Header, Page and Footer layout, then go to the right pane and select print....

That should get you started using the SortWizard. So, if you need further Email us or call 314-567-0552.

We welcome your feedback on the SortWizard. Our goal is to have our products continue to serve you better with time. We can not do that effectively without your help.

For new subscribers:

If you have just subscribed to the SortWizard, you should have or will receive shortly by Email with the installation instructions web page and permissioning code.  Make sure you have the latest version by checking out the on the web site and compare it to the version you are  running by looking in Help and then in About in the SortWizard's menu bar.