Trailing stop loss template Excel

  • Overview
    • The Investigator Philosophy
    • The Investigator Success Formula
    • Finding Systems
    • Statistics
  • Notes for Beginning Investors
    • Overview
    • Random Walk Theory
    • Fundamental Analysis
    • Technical Analysis
    • Capital Management - Gann's Never Failing Rules
  • Charts
    • Opening
    • Viewing Bar Information
    • Changing the Number of Bars
    • Scrolling
    • Zooming In
    • Zooming Out
    • Undo View
    • Redo View
    • Changing to Daily Data
    • Changing to Weekly Data
    • Changing to Monthly Data
    • Adding Indicator Windows
    • Moving Indicator Windows
    • Removing Indicator Windows
    • Mouse Actions
    • Recall System
    • Printing
  • Systems
    • Menu Overview
    • Definition
    • Historical Testing
    • Adding a System
    • Re-testing the Recent System
    • Re-testing a Currently Defined System
    • Viewing Historical Test Results
  • Systems Library
    • Definition
    • Recall Delete Use
    • Test
    • Testing Dialog Box
    • Review System Library List
    • Review System Library Charts
  • Trades
    • Overview
    • Adding Trades
    • Deleting Trades
    • Editing Trades
    • List
    • Charts - One by One
    • All Charts
  • Investor Defined Bar Patterns
    • Creating
    • Conditions
    • Number of Bars Dialog Box
    • Visual Editor
    • Name Dialog Box
    • Recall or Delete
  • Indicators
    • Overview / List
    • Changing Defaults
    • Showing Favorites
    • Changing Favorites
    • Finding
  • Pre-Defined Bar Patterns
  • Point-and-Figure Bar Patterns
  • Designer
    • Overview
    • Functions Overview
    • Main Designer Dialog Box
    • Functions Dialog Box
    • Designer Dialog Boxes
    • Number of Bars and Indicator Color Dialog Box
    • Bar Chart or Separate Window Dialog Box
    • Number of Lines for Graph Window
    • File Open Dialog Box
    • Designer Name Dialog Box
    • Recall Delete Expand
  • Backup
    • Creating
    • Restoring
    • Support Files
  • Bad Data
    • Finding Bad Data
    • Bad Data Conditions
    • Viewing Bad Data
  • Toolbar
    • Configuring
    • Moving
  • Data Types
    • Overview
    • Data Types and Groups Overview
    • Changing Preferred Data Type
    • Changing Data Types
    • Changing Data Type and Directory Information
    • Adding a Directory
    • Finding Data Files and Directories
  • Groups
    • Data Types and Groups Overview
    • Changing Group and File Information
    • Create Industry Groups
    • View Unknown Group Symbols
  • Futures
    • Lookup Table
    • Check Symbols
    • View Unknown Symbols
  • Relative Strength and Delta Relative Strength
    • Main Overview
    • Database Overview
    • Directory
    • Adding / Deleting Relative Strength Directories
    • Changing the Current Directory
    • Generating Relative Strength Values
    • Generating Delta Relative Strength Values
    • Generating Group Relative Strength Values
    • Generating Group Delta Relative Strength Values
    • Viewing Relative Strength Values
    • Viewing Delta Relative Strength Values
    • Database Manager Overview
    • Database Manager Overview - Advanced
  • Exchange
    • Giving
    • Taking
  • Support
Trailing Stop Loss Calculation Example

Assume the Once Price Moves value is 5% and the Trail Percent value is 6%.

Example 1:

For a long trade, assume the entry bar for the trade has a high of 20.0.

The financial instrument would have to move to 21.0 before the trailing stop would take effect:


20 + [20 * [5 / 100]] = 21.0

Assume the next bar has a high of 21.5 and a low of 20.5. Since the Once Price Moves value was hit, the trailing stop would be calculated as:

20.5 - [20.5 * [6 / 100]] = 19.27

If at any time the price for the instrument drops below 19.27, the trade would be exited.

Assume the next bar has a high of 22 and a low of 20. The stop would not be moved, since

20.0 - [20.0 * [6 / 100]] = 18.8, and 18.8 is not higher than 19.27.

Assume the next bar has a high of 23 and a low of 22. The stop would be moved to

22.0 - [22.0 * [6 / 100]] = 20.68, since 20.68 is higher than 19.27.

Assume the next bar has a high of 22 and a low of 20.5. The stop would be exited.

Example 2:

For a short trade, assume the entry bar for the trade has a low of 20.0.

The financial instrument would have to move to 19.0 before the trailing stop would take effect:

20 - [20 * [5 / 100]] = 19.0

Assume the next bar has a low of 18.5 and a high of 19.5. Since the Once Price Moves value was hit, the trailing stop would be calculated as:

19.5 + [19.5 * [6 / 100]] = 20.67

If at any time the price for the instrument rises above 20.67, the trade would be exited.

Assume the next bar has a low of 18 and a high of 20. The stop would not be moved, since

20.0 + [20.0 * [6 / 100]] = 21.2, and 21.2 is not less than 20.67.

Assume the next bar has a low of 17 and a high of 18. The stop would be moved to

18.0 + [18.0 * [6 / 100]] = 19.08, since 19.08 is less than 19.27.

Assume the next bar has a low of 18 and a high of 19.5. The stop would be exited.

Video liên quan

Chủ Đề