Support Board

Date/Time: Tue, 14 May 2024 13:05:34 +0000

Post From: How to hold a specific bar price high until trade is finished.

[2019-10-04 02:25:12] Link To Thread - Link To Post [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.