Support Board
Date/Time: Tue, 09 Sep 2025 12:16:51 +0000
Post From: Help with Trade Entry Logic - On Spreadsheet Trading System
| [2025-08-12 14:14:27] |
| Sawtooth - Posts: 4261 |
|
I would like to place an order on the break of the high/low of an inside bar
Two ways to do this:1. Use two Formula Columns to create a persistent price of the H/L, like this for the High, in P3: =IF(AND(C3<C4,D3>D4),C4,P4) ...then compare that price with the current price, like this in K3 for a buy entry: =AND($J$8=0,E3>=P4) Set Signal Only On Bar Close (K,M) to No. This method may not give you the entry you want since an inside bar of an inside bar would negate the first inside bar. 2. Use a bracketed BuyStop/SellStop entry: Use this example: https://www.sawtoothtrade.com/free-stuff-20.html ...except use this for the trigger, in K3: =AND(C3<C4,D3>D4) You can also set the Attached Orders' TP/SL offsets in cells J80/J81. These offset values are in points, not ticks. |