Home >> Support Board

Support Board

Date/Time: Sun, 28 Apr 2024 22:52:42 +0000

How to Post a Message for Support

[User Discussion] - How to hold a specific bar price high until trade is finished.

View Count: 572

[2019-10-04 02:25:12] #1 [Go To First Post]
monk - Posts: 13
This Post is for USER DISCUSSION... I am using Spreadsheet System for Trading Study for a semi-automated method of trading. The method uses a three bar pattern to enter a Long trade using 1 minute candlestick bars. Bar 2 prints the lowest low of the three bars. Bar 2 is lower than bar 1. Bar 3 forms a higher high and a higher low compared to bar 2. The Long entry occurs when price breaks above the high of bar 3 using a Buy Stop order. This long entry must occur on bar 4, 5, or 6. If the long entry is not triggered by bar 6, the trade is voided. If price breaks below bar 2 low, the trade is voided. Question >>> How do I continuously hold the original bar 3 price high in a spreadsheet column until the trade hits the price target or the trade is stopped for a loss? My thought is to use several "nested IF statements", but that code would become very long and not very efficient. Any help is appreciated.

[2019-10-04 05:20:59] #2 [Go To First Post]
Sawtooth - Posts: 3980
How do I continuously hold the original bar 3 price high in a spreadsheet column You'll need to create a persistent variable in a Formula Column, which will bring the price to row 3. A portion of the formula will initiate it, and another portion will release it, using two IF statements. Here are some examples: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables

To post a message in this thread, you need to log in with your Sierra Chart account: