Support Board

Date/Time: Sat, 18 May 2024 05:24:20 +0000

Post From: How to have only 1 trade per candle with timed entry from spreadsheet

[2022-09-10 23:08:23] Link To Thread - Link To Post [Go To First Post]
bradyfans - Posts: 16
I have somehow successfully created my first spreadsheet trading system. I've only noticed one issue with it during backtesting and would love some help figuring it out. The system is supposed to take a trade at 08:30:00 if certain conditions are met. On one day, a long was triggered, stopped out, then another long triggered and stopped out again. I only want it to trigger one trade per day, if the conditions are met. The conditions were met, but 2 trades were triggered. See the second trade on the image. https://www.sierrachart.com/image.php?Image=1662850071349.png I thought this may be because it was using the whole candle at 08:30:00, not just the candle start time. I went in and changed the settings in the spreadsheet to "signal only once per bar," as in the other attached image, but it didn't change anything. Am I missing something? Is there some setting to trigger the trade only at the open price of the candle? I thought using the B3 value in my spreadsheet calculation would handle this, so I'm kind of at a loss, especially with the "signal only once per bar" set to yes. Thanks!


Screenshot 2022-09-10 185740.png / V - Attached On 2022-09-10 22:59:52 UTC - Size: 96.74 KB - 72 views