HamFon HamTCScan
User's Guide

HamTCScan is a program that works with the TC2000 / TCNet data servers, and with all of the TCNet sorting and scanning features. It gives you the ability to access all of the TCNet data, to access TCNet WatchLists and Sorts, and to access PCF calculations for any TCNet list. You can see the data on the screen, or you can export it to text, HTML, or Excel spreadsheet files, as well as to TradeStation Custom Symbol List and Easy Language eXtensions files.

Downloading and installation of HamTCScan

The set of files that make up HamTCScan is packaged is a downloadable, self-installing module. Click here to start installing HamTCScan , select OPEN, then click SETUP and follow the on-screen directions. All users MUST install the "Typical" setup. If, after installing the Typical setup, you get an error trying to run HamTCScan that says that it is unable to find an .OCX file (msflxgrd.ocx or comdlg32.ocx), install again, and select the "DLLs for error conditions" setup, which will install these two files. Do NOT install these DLLs if HamTCScan is able to start with your current setup. Thanks!

Registering your copy of HamTCScan

HamTCScan must be registered before it will load and display data. This registration information is used only for communication and information specifically relating to the HamTCScan program. For example, by registering, you automatically are placed on a mailing list that is used to announce updates and other information about HamTCScan. When you first start HamTCScan, a Registration window will pop up. Enter your TCNet user name (if you have one), or your on-line handle. Also, enter your email address. Please enter a valid email address because that is the only way that I can contact you regarding your copy of HamTCScan, for bug fixes, updates, etc. Your email address is NOT shared. You may also Register from the HamTCScan menu Settings / Register. The registration window looks like this:

Once you have registered, you can check your account registration status (as well as expiration dates and program versions) from the HamTCScan menu, Help / About. This window looks like this:

This window displays the following information:

The HamTCScan User's Guide is available while running HamTCScan

This User's Guide for HamTCScan is available both on the HamTCScan web site as well as locally installed on your machine. To view the local copy, select Help / User Guide from the HamTCScan menu.

Quickstart - displaying data for a TCNet/TC2000 watchlist

Start by running HamTCScan, and then click on the LISTS pulldown. Lists are separated into several categories. Each category has a header line (all capitalized), followed by the lists in that category. As you can see, LISTS is a collection of all of the WatchLists that you have defined in TCNet/TC2000. Select one - a good one for testing is the "Dow Jones 30 Industrial Component Stocks" - scroll all the way to the bottom, then scroll up to the COMPONENT WATCHLISTS (which start with 8:) to select it. Immediately, you will see the data from the TCNet/TC2000 databases. Next, click on the PAGES pulldown and select a different entry to see other data. In addition to the watchlists that you have set up in TCNet, HamTCScan scans the TradeStation directory for CSL (Custom Symbol List) files. Any CSL files that are found are added to the LISTS, so that you can select one to have HamTCScan display the data for a list of tickers that you built in TradeStation.

Starting in Version 3.00.01, you can also select the Watchlist or Stock Group from the menu Data / Choose WatchList. This is a much easier way to access the full collection of WatchLists, which can number several hundreds. By using the menu technique, the watchlists are organized by type in sub-menu hierarchies. In addition, the Media General Industry Groups are sub-categorized for easier use.

Sorting displayed data for the current watchlist

Once you have some data displayed, you can click on the column header buttons at the top of each column of data to have HamTCScan sort the data using that column. Click again to reverse the sort order. HamTCScan indicates which column is used for sorting by color coding the headers as Ascending or Descending.

Using TCNet/TC2000 pre-programmed Sorts

Next, click on the SORTS pulldown to see a list of all of the sort orders that you have defined in TCNet/TC2000. You may select one to change the sort order of the data. Starting in Version 3.00.01, you can also select the TC Sort from the menu Data / Choose TCSort.

Viewing other pages of data for the selected watchlist

Click on the PAGES pulldown again, and select a different page. Each page has it's own set of data columns, using the same WatchList that you have selected. You may add a new Page by selecting Settings / Page Setup / Add Page from the menu. To give the current page a new name, select Data / Configure Pages / Rename Current Page. If you would like to delete the current page, select Data / Configure Pages / Remove Current Page. You can also change the name of the current page with Data / Configure Pages / Rename Current Page. Starting in Version 3.00.01, you can also select the Page from the menu Data / Choose Page.

The "Criteria" page demonstrates many of the features that HamTCScan offers:

The "True Range" page has High, Low, and Previous Close, the True Range, and two different methods for calculation of the Average True Range.

Note that although the ATR14 method of calculating the Average True Range can be calculated in a TCNet/TC2000 PCF, the SmoothedATR can not. It is possible to approximate the SmoothedATR value in a PCF (to with close enough accuracy that it's "correct"), but iterative calculations like this can not be calculated exactly. HamTCScan is able to calculate and display these values exactly, including more complex calculations that would either generate prohibitively long PCFs or would just not be possible.

The "Dir Movement" page demonstrates the various Welles Wilder Directional Movement indicators, including DI+ and DI- (which gives indication of direction), the DMI, and ADX (which gives indication of trend strength - but NOT direction), and the smoothed ADXR average.

The "S+R Pivots" page demonstrates the traditional calculations of Pivot Support and Resistance levels.

NOTE on how TCNet stores Fundamental and System Criteria data, and what information is available:
For System Criteria (including Fundamentals - you'll see them preceded with '*' in the UserPCF/*SystemCriteria dropdown selector in the Formula Builder), the actual numeric values are not stored. Instead, TCNet/TC2000 ranks all tickers with a value of 1 through 99 (0 indicates that the ticker is not ranked), from lowest to highest value, and grouping tickers with similar values together in each of the 99 ranking levels. This ranking level is available in HamTCScan ("Rank"). In addition, TCNet stores the lower and upper limits for each of the 99 rank values. That is, if a particular stock has a rank of 25, then the actual value of the Criteria is between the lower and upper limits that TCNet stores. These limit ranges are available in HamTCScan ("Upper" and "Lower"). Finally, HamTCScan will also calculate a "Value" (which is the same value that TCNet shows on the Data Sheet) for System Criteria. It does this in the same way that TCNet does, so the value is NOT exact, but "approximate" (see the TCNet Data Sheet accessed via Ctrl-V to notice that TCNet also lists the values as approximate). The "Criteria" Page, described above, contains examples of Value, Rank, and Upper data values.

Exporting displayed data to Excel, text, or HTML files

Now that you have some data displayed, you can export it to other program formats. HamTCScan currently supports export to text files (using spaces to align the data - so they should be viewed in a fixed (non-proportional) font), HTML files (exported as an HTML <Table> which you can easily upload to your web server), and Excel files (XLS spreadsheets). To export the data for all of the displayed columns, select Data / Export Data from HamTCScan's menu. When exporting to Excel, HamTCScan will create a new spreadsheet file, modify an existing file, or even paste the data into a spreadsheet that you have open on your screen. HamTCScan remembers the last directory that you used for each type of export, and stores each one separately. You can select one or more pages to export together to a single file. HamTCScan brings up a selection window that allows you to choose which page(s) to export. Select a page to export by clicking on it, and remove it from being selected by clicking on it again. The Page Selection window (with Pages Criteria and S+R Pivots selected to export) looks like this:

Exporting displayed data to TradeStation files

HamTCScan has two features that allow you to export to TradeStation files. You can export the list of tickers currently shown based on a TCNet list or one of your own Easy Scans. In addition, you can export the values of each of the columns for each symbol. These are exported to an ELX file, which TradeStation Indicators and Strategies can read. Here are examples of each type of export:

Exporting the list of ticker symbols

NOTE! There are two issues relating to passing symbol tickers between TCNet and TradeStation. First, both programs have tickers for stocks that the other program is unaware of. If you create a list in TCNet that includes unknown tickers, TradeStation will display that row as Invalid Symbol. Second, some tickers (particularly indices and calculated values like TRIN) differ between TCNet and TradeStation. For example, the Dow Jones Industrial Average is $INDU on TradeStation, but DJ-30 on TCNet.

Importing a list of ticker symbols into HamTCScan from TradeStation

Exporting ticker data from HamTCScan to TradeStation ELX files TradeStation has an add-on DLL called ELX.DLL. This is not part of the regular release. It is not automatically installed when you install TradeStation. You need to install the DLL and a series of support Functions to use the ELX features. ELX is Easy Language eXtensions. Using ELX allows you to pass data and settings between Indicators, Charts, Strategies, etc. By exporting HamTCScan data (including calculated PCF values and System Criteria) via ELX, you can provide this data to TradeStation so that it can display it or use it for calculation of Strategies or Indicators.

To install TradeStation's ELX extensions, go to TradeStation World and log in (join if you haven't - it's free, and there is a *huge* amount of information there). Scroll down to TradeStation 7 Support Discussions, then select EasyLanguage-DLL Questions. Click on the first "sticky" topic, "ELX", and follow the directions. You may be able to get to the ELX download by a direct link.

The example below assumes that you have already installed the ELX.DLL file and that you have imported the ELX Functions.

Backing up your User PCFs

Often in TCNet/TC2000, you will create or acquire PCFs and get a collection of many more than you actually use. These extra PCFs slow down the update process significantly. By "backing up" your PCFs, you can remove them, and speed up the update process. You can also preserve them in case of loss of TC data. HamTCScan will dump all of your User PCFs to a text file (editable with WordPad). This format is NOT compatible with TC, and can not be imported. It's only purpose is to save the PCFs, one per line, including the PCF name. The format of each line is PCFName=Formula. After you have backed up and removed the unused PCFs from your system, you can bring individual ones back by copy-and-paste from the HamTCScan dump file.

Adjusting the number of bars of data to use for calculations

Just like TCNet/TC2000, HamTCScan looks at historical data to calculate function values. The more data needed, the longer the calculation takes. The Settings / Max Bars Back menu item lets you adjust the number of bars of data that HamTCScan will use. You can select Fast, Medium, or Slow settings. Slow settings are necessary for calculations that use long moving averages, or use BOP. HamTCScan will automatically test your settings, and inform you if there are not enough bars of data - and then it will adjust the setting for you. These menu items are only provided so that you can test your own optimizations, to try and speed up the calculations

Surviving the TCNet/TC2000 Update cycle

If a TC Update cycle is started while HamTCScan is running, TC will change the data that HamTCScan needs to do it's calculations. To handle this issue, HamTCScan detects a TC Update cycle, and pops up a message window. This window tells you that TC is updating, and gives you instructions for reloading the data. In addition, HamTCScan changes the color of the Update field (in the upper right of the main window) to Red to indicate that data has changed, and needs to be reloaded. Note that you may continue to use HamTCScan while TC is doing the update, but that the data will not be updated until you specifically tell HamTCScan to reload it. To reload the data, wait until the TC update is completely finished. Then, from the menu of HamTCScan, click Data / Reload TC Data. This will cause a restart of the TC data interface, and will reread the data for the current screen, and all other screens. The formulae will be recalculated. After you have done this Reload, the Update field on the main screen will be changed from Red back to the default color.

Ticker commands: Creating sub-lists of tickers, controlling TCNet and Yahoo

With the Tickers that are displayed in HamTCScan, you can right click on any of the displayed tickers (not hidden), and perform several operations. These operations include hiding and showing groups of tickers (to narrow your list down), as well and the ability to control TCNet, TC2000, and Yahoo with the ticker you select.

After selecting a LIST from the Lists drop-down, you may wish to eliminate some of the tickers based on the data displayed. This will trim your list to make it easier to evaluate the remaining tickers, and will also make the list smaller if you export it. For example, you might sort on column "BullishTrend" (with your own formula in it), and identify 25 out of 100 stocks that have this condition as "TRUE". To further examine only the matching tickers, you can right-click on a ticker symbol to bring up a pop-up menu. You can select a ticker by left-clicking on it. You can select a group of tickers by left-clicking and dragging - or by using the SHIFT key with a mouse click.

The popup menu includes the following options:

Using the advanced Formula Builder features

Select the Personal choice from the PAGE pulldown on the main HamTCScan screen. This displays an (initially) empty page, containing only the Ticker column. Right click on the Ticker header and select Add to create a new column with a calculated formula that you specify.
To change a formula, right click on the column header.
To add a new column, right click in the blank space to the right of the last column, or right click on any column header and select Add.

After choosing Formula Builder, a new window (see above) will pop up to allow you to edit the formula for that column of data.

Creating your own Formula
A HamTCScan Formula consists of:

Variables may be optionally followed by an "offset" which specifies how many bars back (C1 is Close of Previous Bar) PCF Specifiers provide access to all PCF and System Criteria values as calculated by TCNet. In the following PCF Specifiers, the 'xxxx' is a code used internally by TCNet to identify which PCF or Criterion. HamTCScan will determine the value of xxxx for you. Select the PCF or System Criterion (preceded by '*') from the UserPCF/*SystemCriteria drop-down. Then click the Value (or other) button to paste the corresponding PCF Specifier into the formula editor. HamTCScan will also include a comment that provides the name of the PCF or Criterion, so that you can remember which PCF/Criterion you selected. Arithmetic operators: HamTCScan follows standard algebraic order of precedence rules, that is, Multiplication and Division are calculated before Addition and Subtraction. For example, 2*3+4*5 is calculated as (2*3)+(4*5). Comparison operators: Boolean operators: Function calls: perform complex calculations on values. Parameters for Functions are contained in parentheses. Parameters may be constants, variables, or other complete formulae. In the following functions: Note that you do not need to supply all parameters to functions - only from left to right the ones that are needed.

Viewing HamTCScan program information and Registration status

You can get the current version information for HamTCScan by clicking on the Help / About menu. This will also provide you with web and email contact information. Also, it will display your registration status, and the current and latest version numbers of HamTCScan.

Custom programming for HamTCScan

If you have special needs for calculations of strategies or indicators, and want to display them in HamTCScan, please contact me for a price quote. I will need your specifications and any calculation methods that I don't already have. Customized versions of HamTCScan are written for YOU only - the techniques and calculations do not become part of the public version. Other people may ask for a similar calculation, of course. Also, HamTCScan can do additional specialized calculations like comparing two or more tickers or indices, or even accessing external databases such as calculation of Volatility Bands based on Put and Call data from www.ivolatility.com.

All discussions of your methods remain private between you and me, even if you decide to not pursue a customized version.

Thanks for your continued support!
HamFon