Support Board
Date/Time: Tue, 09 Sep 2025 12:12:35 +0000
Help with Trade Entry Logic - On Spreadsheet Trading System
View Count: 109
| [2025-08-11 22:15:59] |
| User616054 - Posts: 30 |
|
Hello, I'm testing the spreadsheet trading system study and I would like some help to understand how the trade entry logic works specifically for placing orders on 'Inside Bars' For example, if I would like to place an order on the break of the high/low of an inside bar how do we use the logic to look back at previous excel rows which would essentially be a prior bar... the high/low break could possibly be 1,2,3 + bars after it was formed. Also, in terms of order placement..... If I use the OCO settings from the DOM e.g. SL and TP, how do I place a stop market above/below the inside bar high/low. Any help with the logic would be much appreciated.... note this is just a test for checking historical data via chart replay. Many thanks |
| [2025-08-12 02:59:58] |
| Sierra_Chart Engineering - Posts: 20841 |
|
Refer to: Working with Spreadsheets: Cell and Range References Example2: ID0.SG2@4 This refers to the main price graph which has an ID of 0, the second Subgraph which are the High values, at row 4 which is the second to last value.
So to refer to the prior High value use this reference in the formula. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [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. |
To post a message in this thread, you need to log in with your Sierra Chart account: