We appreciate your interest and the time you are going to spend with us today. In return for that our goal it to have you well on your way to finding better trades after the completion this session.
We'd like to take a few minutes to give you a quick overview of the SortWizard.
The SortWizard works with in tandem with the premier real time trading application called RealTick.
One of the sources of data that the SortWizard uses is the RealTick data feed. The RealTick data feed supplies the real-time data. As a result of using RealTick for real-time data, there are no additional data feed expenses or exchange fees. The other source of data is the SortWizard's database.
The SortWizard was designed specifically to operate with minimal processor overhead and without creating a data feed performance lag with your RealTick application.
You can search the entire equities market in real-time in seconds while concurrently running your RealTick based quotes and charts software. You will not notice any degradation of you system's performance.
The SortWizard provides hot links, drag and drop capability and other speed, efficiency and convenience features built in to make use with RealTick as efficient and seamless as possible.
Unlike other applications, the SortWizard has no symbol list size restrictions.
A scan with the SortWizard will return all the symbols in all exchanges that meet your criteria;
not just the symbols from a list you have already created (although you can do that too).
The SortWizard is available in two versions: the Standard and the Plus.
The Standard Version requires no programming to set up a search. Just select the desired criteria and enter values; then run the scan.
The Plus Version adds the capability to create your own customized formulas and data fields.
When you run searches during the trading day with the Plus you will see potential intraday long or short trade opportunities displayed when they hit your entry point targets.
If you know how to work with a spreadsheet, you can create formulas for the SortWizard Plus.
With the Plus Version, choose from a comprehensive list of fields on the RealTick servers and use the SortWizard's historic database that contains, moving averages, average volumes, directional trends,
ADX, RSI, stochastics and much more.
There are even samples and templates included with the installation and a tutorial on the web site to help you start using the software quickly and to show you different ways to create searches.
Once you are a little bit familiar the operation of the SortWizard, you can also start setting up searches using the criteria from many popular trading magazines, manuals and books available on the market.
The first thing we would like you to do now is click
here to go to links web page corresponding to the seminar.
You can just follow along and you won't have to leave that page anytime during the session.
Just click on the hyperlink (link #) corresponding to the number posted in the room as we move through the session
I'd like to start with a few example searches to give you the look and feel of the SortWizard.
On the web links page: Please click on link #1
This shot is shows you some for the features of the SortWizard.
To the far left, in black, you see a file browser that will display the search files you created in the User's Area.
If you were to click on the Templates button you could then choose from a list of available templates.
To make getting started easy, there sets of templates and sample user files for you to use when you install the SortWizard.
In the center you will find the search results symbol display for the a "Gainers" search.
The symbols in the display can directly to RealTick by clicking on a symbol and then the Rainbow icon (looks like a small Level 2 window). See the yellow call out at the top.
You can also hot link to charts in the same manor but we would recommend you link the RealTick Level 2 window to all the charts you use to analyze a stock. That way everything you need will be updated with one click in the SortWizard.
Or, you could right click on the symbol then select from a number of different news sources for any news related to that stock with another click of the mouse. Yahoo is the news source in this example and is displayed in the lower section titled "Recent News".
You can open any number of searches and run them all at the same time. In this example, the searches overlap each other and can be easily selected by clicking on the row of tabs just underneath the symbol display.
If you don't want to use the integrated browser to save desktop space, you can also setup the SortWizard to open a separate session of Internet Explorer instead. Everything else will work the same way.
On the web links page: Please click on link #2
This an example of a pre-market Gap Up search. Aside from what was discussed above, this search shows additional fields (columns) most notably the pre-market Total Volume and News Date and Time.
This search informs you as to what is going on in a number of ways. Double click on the column heading, "Tot.
Vol" and you will bring all the stocks with pre-market volume to the top of the list.
Repeat the same on the NetChgBid and % NetChgBid to get the highest gap on either a point or percentage basis.
Repeat that process again on the News Date column to see if the gap is as a result of news.
On the web links page: Please click on link #3
Taking the News functions one step further, you can set up a search, such as this one, to automatically search for the latest news and place the new news symbol at the top of the display list.
That automatic search function is set up under the Primary Criteria tab in the Parameters Setup window (we will more discuss later).
If you look for the mouse arrow you will see Auto Clear and Search selected in the Searching Mode section with the search interval set to every 5 minutes.
You can set you search interval to as frequent as every 10 seconds with the SortWizard Plus.
The key to this search is to the sort order of the News Time field by double clicking on the column heading until you have it in descending order.
That will place all of the most current news item symbols at the top of the list. See the yellow call out at the top of the display.
On the web links page: Please click on link #4
This example shows how you use the SortWizard to find stocks with a wide intraday trading range.
Again by double clicking on the Rng(day) column, identified by the yellow call out at the top, you can toggle back an forth between the highest and lowest range stocks.
A few more quick examples and we'll get into the inner workings of the SortWizard
On the web links page: Please click on link #5
This is a Gainers search. You can easily set up a search to return both gainers and losers if you want. In fact, there is a sample file that does exactly that in with the samples files when you install the SortWizard.
But, here you can see all the gainers in your trading price range on a percentage or point basis with a double click on the appropriate column.
On the web links page: Please click on link #6
This is a Most Active search being used to find stocks trading at their high of the day and near their 52 week high.
100% displayed in the %Rng(day), set yellow call out to the left, tells you that the stock is currently trading at it's high of the day. 0% would be the low of the day.
In the case of "MIKE" that stock is trading at its high of the day and at 93.7% of its 52 week range. 100% here means its 52 week high and 0% would be the 52 week low.
So now - you are probably asking is: "How do you create searches with the SortWizard?" We are going set up a search from Tony Oz's book: The Stock Trader.
If you like, you can order the book at a discount from the SortWizard web site by clicking the icon on the bottom of the black frame on the left of the master page we have been using for this seminar.
On the web links page: Please click on link #7
The Search Parameters Setup window is the heart of the SortWizard. You will spend 98% of your time creating searches using this window when building your searches.
The other 2% will be in View on the Menu Bar where you can modify the actual look of the display.
So far you have seen example displays using a white background and you will see examples with a black background with contrasting letters later in the seminar.
The shot we are looking at is of the Standard version's Parameters Setup window. Note the 4 tabs at the top of the window. The Plus adds additional tabs (you will see that next)
With the Primary Criteria tab selected, you can see where you select the field you want to setup from the Available Fields column on the right side of the window.
After you have the selected field you want to edit, you would go to the Search Criteria Setup list box and select the criteria you want to use and then set the values for that selection.
You would then repeat this setup process for every field to be used in the search.
A summary of your search is displayed at the bottom of the Parameters Setup window (see yellow call out)
On the web links page: Please click on link #8
This shot shows what the Plus version Parameters Setup window looks like.
The important differences are the addition of the Add Fields, Limits and Formulas tabs.
We will address those tabs later in the seminar.
On the web links page: Please click on link #9
This is where you set up each column to the display character characteristics you desire.
You can eliminate a column from the results displayed by unchecking the box in front of the field in the Available Fields column.
If you would like, the Column heading can be renamed in the Column Setup field named Label.
In the next field, Display Type, set the selected field to decimals, fractions, percentage, or Up/Down arrows.
Next, set the precision of the field for the numbers to be displayed. Do you want to display 21.52 (0.00) or do you want to display 21.518 (0.000) or even higher precision?. The SortWizard will take care of the rounding for you automatically.
Then you can elect to Freeze a column. This will group all frozen columns to the left side of the search results display in the order they are frozen.
Then when you scroll from left to right the frozen columns will remain in position with all the other fields scrolling underneath the frozen columns.
AutoColor will color code the plus values to green and the negatives to red.
With Commas selected, 10000000 will be displayed as 10,000,000.
On the web links page: Please click on link #10
In the Settings tab you can manage your symbol Ignore files and set up sounds for notification of new symbols being added to your search display list.
From the search results display, you can eliminate symbols from showing up on futures scans during the day. Just right click on symbol(s) and select Ignore from the menu list that pops up.
This a very helpful feature as it reduces results list sizes by eliminating symbols that you have already decided against as possible trade candidates.
You can add any *.wav file you want to use for notifications by clicking on the icon with the three periods in Event Sounds.
On the web links page: Please click on link #11
With Plus version of the SortWizard you have access to all the data fields in RealTick's server pool and over 150 additional fields in the SortWizard's custom database.
On the web links page: Please click on #12.
This page will give you an overview of two sets fields we are talking about:
Check it out.
In the Add Field tab and in the Available Fields column list box is where you make the selections of the fields you wish to add for your search creation.
These fields can be used as is and then set to a certain criteria in Primary Criteria or used as elements in Formulas and Limits or both.
All the fields needed for a search must appear in the Selected Fields list box for them to be accessible for use in a search.
Note the Column Information section at the top left of the window. It is important to note the source of you data to make sure it is synchronized with the time frame of your scan.
The reason for this is that the SortWizard database is updated with end of day data about an hour after the close of the market. And, the RealTick data is not updated until the following day after the close.
If you use the wrong reference frame or mix reference frames your search results with not be accurate.
On the web links page: Please click on link #13
In this shot we are adding the fields needed for Tony Oz's scan from the SortWizard's database. Specifically: Ave Vol 20 (20 day average volume).
Select the TODAY Table and then just click on the Avg Vol 20 field in the Available Fields list box to select it. Click the arrows pointing left and that will move the field to the Selected Fields list.
Repeat that process until all the fields you need for the search are in the Selected Fields list box.
For this search we only need the one field.
On the web links page: Please click on link #14
There are 2 Tables in the SortWizard's Database. The TODAY Table and the HISTORIC Table.
We are not going use any fields from the HISTORIC table in this example. This discussion is for your information so when you get started on your own you know how to differentiate the two tables
The HISTORIC table contains the daily history going back everyday for 5 additional days and then in intervals of 10, 20, 40, 60, and 90 trading days.
In addition, there are fields for calculations found in the TODAY table that are offset to skip the previous day's data. For example, the volume from the previous day is not picked up in the calculation of the Avg Vol 20 -1 field highlighted.
That field will return the average 20 day volume going back 20 days but excluding the previous days volume. Hence the "-1" notation. The purpose of those fields is to eliminate a distortion in the data caused by potential exhaustion volume in a day when there is an over-bought or sold condition.
So, moving along to our search. Now that we have the fields we need are added. We will need to set up the formulas and limits.
On the web links page: Please click on link #15
Under the Formulas tab of the Search Parameters Setup window is where you set up formulas. To start creating a formula, click on the +fx button at the bottom left of the window to open a new formula and then name it.
This will add the new name to the When you create a formula, you, by default, create a new field that you can set the criteria for that field in the Primary Criteria tab window.
In this example we are going to create a formula that measures, in real-time, the pace of the current day's accumulated volume compared to the Ave 20 day volume.
We will name it: PaceAvVol20. And now, click the Accept button.
On the web links page: Please click on link #16
The formula bar is located to the bottom left of the Formulas window. You enter the formula after the fx=. The completed formula is show.
If you are familiar with algebra, Microsoft Excel or any spreadsheet, you can create a formula in the SortWizard.
In this example we are going to take the accumulated volume for the current trading day and divide it by a time variable volume reference.
To create the formula, we will double click on the Accumulated Volume field from the Selected Fields list box. That will insert ACVOL_1 into the formula bar.
Then to set up the divide, type " /( ". Double click on the Avg Vol 20 field to insert it into the formula.
Now we need to multiply the average volume with a special function in the SortWizard that calculates the percentage of the day that the market has been open.
That function is: MKTOPENRATIO() So, we type " *MKTOPENRATIO()". Then, type ")" to close the divisor. That completes the formula.
You can check your formula to see if there are any errors by clicking on the white checkmark and fx icon on the right of all the other fx buttons.
On the web links page: Please click on link #17
Now we need to set the parameters for the Pace formula we just created. Click on the Primary Criteria window tab and then select PaceAVVol20 in the Available Fields list box.
Select the criteria you want from the Search Criteria Setup field (in this case; Greater than or equal to (Value1)). Enter the value you desire in the Value 1 field.
In Tony Oz's scan, he wants to see all the stocks that are trading some
multiple in excess of the average volume. For this example; we'll
use 1.25 times the on pace volume. So type 1.25 in the Value 1 field.
While we are in the Primary Criteria you can also see all the other settings for the other criteria required in Tony Oz's scan.
A summary of the criteria is displayed at the bottom of the Primary Criteria window titled Search Criteria Summary.
If you want to change the criteria from the Summary box, just click on the field you want to change and go to the Search Criteria Setup field and make the appropriate changes there.
In there you can see that the Change Open set to > .05.
The minimum traded volume for today of > 50000.
The percent of the range day the stock is trading set to > 85% (100% = high of the day, 0 = low of the day)
The trading range of the day (high - low) greater than .82.
NASDAQ only stocks. The average 20 day volume > 255000 and
the trading volume pace (we set already above at 1.25)
These can be set in the same way we set the criteria for the formula earlier. Just select the field in the Available Fields list box, then the set the criteria in the Search Criteria Setup.
Ok - that is all there is to that part of the search set up.
On the web links page: Please click on link #18
In the Limits section you can set up underlying filters using Boolean logic.
That is, if the conditions of the criteria (a formula of sorts) are met, then the qualifying symbols are allowed to pass through the filter.
If the conditions are not met, then those symbols are not allowed to pass through.
You create limits exactly in the same manor (spreadsheet format) as we showed you in creating a Formula.
As you can see the criteria you set up in the Primary Criteria section show up in Limits because they are in fact filters.
There are many situations where it is much more efficient and easier to create Limits than to create Formulas.
This is especially true when you are creating more advanced statements involving IFs, ORs and ANDs.
The Limit capability makes the SortWizard extremely flexible and powerful for an experienced user.
We do not have any need for Limits in Tony Oz's scan. So lets see what the scan returned on Friday 7/27/01
On the web links page: Please click on link #19
Here you see the search results for 14 symbols from 11:35 AM (on 7/27). This is shown in the Status Bar at the bottom of the results display.
Note the "New" column. If there is a "1" in the column that means it is a new entrant to the scan. A "0" denotes a qualifier but not a new entrant.
That is how you keep track of the new symbols that are just popping into your search as a new qualifier. As we discuss previously, you can also setup to an audible alert for a new entrant.
The next column shows you how near those stocks are to the day's high. ARNA is basically trading at its high with a value of 96.4%. PMCS and CHRT are too at 95.3% and 94.8%
You can also see here that the New and RNG columns have their sorts nested.
The New is the primary sort and the RNG is the secondary sort. That is why the RNG starts over when the New column changes from 1s to 0s.
The Entry Point column is a Formula that takes the desired entry point for a trade and subtracts the current price to show where you are relative to that point.
In the example, green means the stock is trading in the money from the entry point.
This scan was done late in the morning of a rally so all of the symbols are well into the money.
But, when you run the scan earlier in the day the list expands and contracts as the market changes. And certainly you will catch them before the entry trigger is met.
On the web links page: Please click on link #20
Here you see the search results for 14 symbols from 11:51 AM (16 minutes later) on 7/27. Note how the "1s" have now changed and ARNA has moved down to the "0s"
BSYS looks like it is near a break out with 95.9% RNG. And, AMGN is coming back from a pullback from a previous intraday high with a RNG of 85.9% and just qualifying in the scan.
On the web links page: Please click on link #21.
The last shot is of the Diagnostics tool that is built into the SortWizard.
The purpose the tool is to help you find what elements of the are causing problems in the scan. Like….zero results from your scan.
Every time you run a scan you can see exactly where the symbols were eliminated.
Every element in the scan is listed in a column. In this shot we are looking at the Limits (Limit Dump).
Just look for where "Hits" equals your "Rejected symbols" and there is the culprit in your scan. However, the Power Trade scan has no problems as we are returning symbols with our scan
For example we ran the scan on Monday 8/6 and it didn't return results. Running the diagnostics told us that the Pace formula was eliminating all of the symbols.
Well sure enough that was a very low volume day and the Pace needed to be dialed down to .85 to start seeing results. The result was two great trades too! THQI and CCMP
On Tuesday there were again two more great examples: BMET and IART.
We have only scratched the surface of the capabilities for the SortWizard today. Hopefully, what we did show you gave you a good idea of what you can do with the SortWizard.
The Tony Oz search file used in this seminar is there too for you to download from the same page. So, sign up for the trials today and give that scan a try on your own system.
With a little time "behind the wheel" both the SortWizard and RealTick will become indispensable tools in your trading tool chest.
Also note that if you are fan of Jeff Cooper's Hit and Run strategies, we have all the scans setup as add-on modules for the SortWizard too. You can even order the Hit and Run I book at a 30% discount too!
Thank you for spending today with us and now I'll turn the floor over to you for questions.
Good luck and profitable trading.
Disclaimer
The above 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 are acting on
their own. Each trader is entirely responsible for his or her own actions, if
any. The use of any of the supplied information, files, strategies 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 and Neo Inc. from any liability or litigation under any
circumstances. If you do not agree with this disclaimer, it is your responsibility
to refrain from taking action on anything detailed within this or any other document
referred to.