Support Board
Date/Time: Sun, 24 Nov 2024 11:34:18 +0000
Inconsistent Limit Order Placement Using Spreadsheet System for Trading Study
View Count: 200
| [2024-05-31 23:20:33] |
| TraderBiku - Posts: 36 |
|
Hello, I am using the Spreadsheet System for Trading study to execute limit orders relative to the close of a trigger bar, and am experiencing a fairly high degree of variability in terms of at what price the actual order gets placed. I have a simple formula for a buy entry in the K3 cell, and the J71 cell is set to "L". In J22 (limit/stop price) I have the =(E3 - 0.5), so the close of the trigger bar minus 0.5 points, and the study is set to evaluate only on bar close. I would expect these settings to always place a limit order 0.5 points below the close of the trigger bar once the bar closes, but my experience is that while this sometimes happens, just as often the limit order is placed at the close of the bar, or sometimes even above the close of the bar by as much as 1.5 points, or sometimes 1.5-2 points below the bar close - all appreciably different from the desired 0.5p below the bar close. I'm having trouble understanding how/why this could happen, since the bar close is a fixed value at the moment the bar closes. I noticed that these inconsistencies happen more often when the market is moving quite quickly, and I wonder if there's some kind of delay in the calculation where the study is starting to refer to the E3 of the new bar (the first developing bar after the trigger bar) before it has time to place the order? Would it make sense/be possible to add a slight delay to the calculation and refer the J22 formula to E4 so that it is always referring to the close of the trigger bar? If there is a better or different way to get more consistent order placement relative to the close of the trigger bar, I would be glad to hear it - thanks very much! |
| [2024-06-01 12:33:05] |
| Sawtooth - Posts: 4118 |
|
The 'Signal Only On Bar Close' setting only applies to Formula Columns. Formulas in column J need to reference row 4 to be close of bar. So your J22 formula needs to be =E4-0.5 |
To post a message in this thread, you need to log in with your Sierra Chart account: