Wilder recommended a 14-day average of the True Range. If the user has entered sufficient data, the calculator will compute the 5-day, 10-day, 14-day or 20-day ATR.
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. Once it calculates the volatility figure and applies the user's choice of weighting to be applied, it subtracts the calculated amount from the high, low, or close for a long position or it adds it to the high, low, or close for a short position. Whether it adds or subtracts the calculated amount depends on whether a "1" or "2" is entered in cell D-5. Finally, the user can apply an infinite range of multipliers to the True Range used in ATR computations (decimals are accepted).
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 1608 of the spreadsheet, just below the 15th position. 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 your 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. The charts in the lab were pre-selected by StockDisciplines.com and cannot be changed.
You must have Excel 2007 (or later) installed on your computer, and be able to open an Excel spreadsheet with macros in order to use ATR Stops. If you have Excel 2007 or later installed on your computer, click on the following link. It will take you to a page where you can download a small exe (executable) file with a macro (ATR Stops has a few macros). If you can enter a number and cause the macro to work and the spreadsheet to recalculate, then you should have no trouble using ATR Stops on your system (unless you have a Linux or Apple system, and those may or may not work depending on configuration). Do not try to open the file with Excel. That will not work. Simply click on the downloaded icon and it will open. Notice: There are compatibility issues with versions of Excel that are older than Excel 2007. Do not attempt to open ATR Stops or even to test your system if you have Excel 2003 or other older versions of Excel. This is very important. If you have an older version of Excel and you want more information on this, contact us. Test for Excel 2007 & later
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). You also must enable ATR Stops to connect to this Website. When you open ATR Stops, make sure your spreadsheet program is closed. To open the calculator, click on the StockDisciplines "SD" icon, ATR Stops opens and makes use of the functionalities of your installed spreadsheet. 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 a maximum of 15 stocks simultaneously. Once ATR Stops is opened, data can be entered just as it is 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. Because there are many thousands of equations (large numbers of which depend on the calculations of several other equations), it may take the program a few moments to finish its calculations. We recommend this procedure because it would be tiresome if the program 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.
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.
There may be times when these programs are not available. Programs may be unavailable if modifications, updates, or improvements are being implemented. If the programs are available, your order will go through. If not, you will get a message stating that the product you ordered is not available, and your credit card will not be charged.
The license period automatically renews every month. If you ancel, there are no refunds for unused portions of a pre-paid period. Users are given access to a page where we post the "Operational Codes" that enable the calculator to function. The codes expire after approximately three months and updated codes are posted to replace them. The amount of time remaining on the codes at any given time depends on the timing of an order or cancellation. Until the licensee cancels, he is given access to the codes. When he cancels, the access is terminated. However, the user will still be able to use the calculator until the codes already installed expire. See the "Refunds & Policies" page for details.
The description on this page has been very brief. More detail on Wilder's procedure and on this calculator is at ATR Stops However, this page is where orders are placed.