What is this indicator?  Click for explanation.

Click to view the chart.         

Place Your Order In The Cart
 All prices are in U.S. Dollars
This Site Is SecureImage of Visa, Mastercard, amd Discover Credit CardsImage of The MasterCard Credit Card 

ATR Stops

ATR Stops

ATR Stops
Click to enlarge image(s)

The True Range tends to reflect the commitment or enthusiasm of traders. For example, if traders are willing to keep bidding up or selling down a stock throughout the day, then ranges will tend to be large or increasing. Conversely, if there is a lack of interest, ranges will tend to be small or decreasing.

The Average True Range (ATR) is the average of the True Range over a given period. It is a measure of volatility first introduced by J. Welles Wilder in his book, New Concepts in Technical Trading Systems.  Not all ATR stop loss calculators use the same equations Wilder used.  They often use a simple moving average or some other method of averaging, primarily because they are simpler.  In other words, they do not come up with the same figures that Wilder would have derived for his stop losses.  He created a very specific procedure for computing the True Range and for averaging it.  This tool uses Wildar's procedure. 

Wilder recommended a 14-day average of the True Range. According to Wilder, large ATR values tend to occur at market bottoms after a panic sell-off (volatility is high). Small Average True Range values tend to occur when volatility is low. An example would be during times of prolonged sideways movement (as when a market is topping out or undergoing consolidation).

The user can have ATR Stops calculate and display the True Range or a multiple of the True Range of a stock for each day. The tool uses these calculations to derive and display stop losses based on the Average True Range or on a multiple of the Average True Range as instructed by the user. The user can also Instruct ATR Stops to compute stop losses for either long or short positions. Finally, the user can apply an infinite range of multipliers to the True Range used in ATR computations (decimals are accepted).

The user does not have to know how to calculate the True Range or Average True Range. The user gives Instructions to the tool by entering a "1", "2", or "3" in various cells. For example, entering "1", "2", or "3" in a cell can tell the program to compute an ATR-based stop loss relative to the highest high, close, or low price. Entering a "1" or "2" in another cell can tell the program to compute stop losses for a long or a short position, and so on.

If you are calculating a stop loss for a long position, you can have the stop loss calculated relative to the highest high, low, or close since the beginning of the data entered. If you are calculating a stop loss for a short sale, you can make the calculations relative to the lowest high, low, or close since the beginning of the data entered. For example, if you have entered 50 days worth of data for a long position, and you are computing your stop loss relative to the stock's highs, then the program will compute and display the stop loss relative to the highest high reached during the 50 days for which you have entered data.  If the stop loss has not risen for 5 days, the last stop loss showing will be the one computed 6 days ago. That way, you don't have to search through all the computed stop losses to to make sure you are using the highest one. It will be the last one showing. Every time a higher stop loss is calculated, it will be displayed. The old stop losses will still show, but the last one showing will always be the latest and highest (or the latest and lowest if computed as a short position). 

The Lab

So you can get a “feel” for how various settings affect the stop loss, we have provided a "Lab" where you can experiment to find the settings that best suit you and your investment strategy. We suggest that you spend a little time conducting experiments here before you use ATR Stops to track real positions. Your tolerance for risk and your preferred investment time-horizon will have a big impact on the settings you use. For example, if your goal is to capture most of a 1-month move, your stops will be much closer to the current stock price than if your goal is to capture most of a 6-month move. The potentially much greater returns of shorter-term investing come at the cost of greater trading activity. Longer-term investing will generally require less trading activity and allow more downside volatility (greater risk). The trade-off in using this more “relaxed” approach is the likelihood of a smaller return. We searched for stock charts to use in the "Lab" that have sufficient twists, turns, and trends to enable you to evaluate different combinations of settings. The Lab begins on row 541 of the spreadsheet. We have provided five charts in the lab and arranged them vertically. You can see more than 5 years of charted price action by scrolling down.

The stop loss is traced in red. From any theoretical “buy” point, you trace the progress of the red line relative to the price action of the stock. The stop will be triggered whenever the stock’s low price falls below the highest price reached by the red line since the theoretical buy point. To avoid having a position sold because of an intra-day spike, some investors use “mental stops.” They wait to see if the closing price is below the stop line because they believe that where a stock closes is more important than what it does during the day. In the lab you can study how your settings influence end-of-day stops by simply noting whether the stock’s closing price on the day of a decline is below the highest point reached by the red line.

You must have Excel 2007 (or later) installed on your computer with macros enabled in order to use our stop loss calculators. However, you cannot open Stops in Excel.  Instead, you simply click on the Stops icon to make it open. It is only necessary that Excel 2007 or later is installed.  If you have Excel 2003, contact us before ordering.  Stops could permanently remove all menus from an Excel 2003 program. This is not a problem with Excel 2007 and later. There are many places on the Internet where you can learn how to enable macros in Excel. To test your system, click on the following link to open a small exe file with a spreadsheet and a macro (Stops has a few macros). If you can enter a number and cause the macro to work and the spreadsheet to recalculate, and if your system can pass the macro test provided, you should have no difficulty using ATR Stops on your system.  Try the test

The macros in ATR Stops are essential to the proper functioning of the tool, so they must be enabled (a simple setting choice in Excel).  When you click on the ATR Stops icon, ATR Stops will make use of your spreadsheet program, but you cannot open ATR Stops with Excel.  While ATR Stops is easy to use, there is a lot to it internally.  The procedure Wilder used is a little more complicated than using a simple moving average of a two day range, and that is why this tool is a little larger than it would be if it used something other than Wilder's procedures.  ATR Stops is configured to track ten stocks simultaneously.  Because of its size, it may take a few moments to load. Once it is loaded, data can be entered as quickly as for any simple Excel spreadsheet. It is configured so that it will not compute anything until you tell it to by pressing the f-9 key. Simply make all your entries for all stocks, press the f-9 key, and wait for ATR Stops to complete its computations. It would be tiresome if it recalculated automatically every time a number is entered (and you had to wait for tens of thousands of calculations before proceeding).  That is why we suggest that users make all changes before pressing the f-9 key.

Ordering and The License Agreement

Read the License Agreement for details before ordering. To read the License Agreement, click on Agreement. An order cannot be transmitted to us unless you acknowledge that you have read the License Agreement. 

**The security of information you send us is protected during transmission by using Secure Sockets Layer (SSL) software, which encrypts the information you input. It is the process used by over 93% of the Fortune 500 and by the world’s 40 largest banks. You get 100% secure data transmission.