Support Board
Date/Time: Tue, 26 Nov 2024 08:41:40 +0000
Exit at the low of the candle prior to entry,
View Count: 250
| [2023-12-11 19:42:14] |
| Hopeman - Posts: 166 |
|
Exit at the low of the candle prior to entry, Hello, I am trying to create an exit signal at the minimum of the candle that marks the entry. I am writing several formulas but I can't figure it out. Would you be so kind as to help me with this? I don't control the sending of formulas in the spreadsheet trading system very well. Thank you. The formula I am trying to do is if J48 is the input, do I want the output to be =AND(FRACTIME(J48)>D4)?? I apologize for the formula, I don't even know if it is an approximate |
| [2023-12-11 21:39:46] |
| John - SC Support - Posts: 36286 |
|
You would first need to find the candle that marks the entry using the "Last Entry Trade DateTime". To do this, you would need to use the "HOUR()" and "MINUTE()" and possibly "SECOND()" functions to get the time of the bar to the nearest item that matches your bar period (i.e. if you have 1 minute bars, then you only need to the minute, but if you have 10 second bars, then you need to the second). You will have to then round down to the actual bar period (i.e. if you have 5 minute bars then if the MINUTE() function returns 27, you need to round down to find the 5 minute bar that contains that time). You would then need to put this together and compare it to the bar times in column A. From there, you would get the Low for that bar to get the exit price. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: