Login Page - Create Account

Support Board


Date/Time: Sat, 10 Oct 2026 15:48:02 +0000



Only partial position exit on Buy/Sell Exit Signal from Spreadsheet for Trading

View Count: 207

[2026-08-26 11:12:01]
User512353 - Posts: 190
SC2944
SC_Data trade simulation mode

Using 'Spreadsheet System for Trading' Study.

When the system is long or short with several positions, on SOME occasions, when the respective Buy/Sell Exit column flips to 1, NOT ALL positions are exited.

The signal that I am using for the Buy/Sell Exit column is very volatile and may be triggered only for a very short time, e.g. shorter than the bar period (and maybe also shorter than the chart update interval (which I cannot prove)).

My expectation is, that IF an Exit is triggered, then it would exit ALL positions, not just a subset.
However, this obviously is not the case.

Is this a bug or feature?
[2026-08-26 11:14:40]
User512353 - Posts: 190
A screenshot of the behavior, where the system needs several triggers to exit all positions.
imageScreenshot From 2026-08-26 11-13-08.png / V - Attached On 2026-08-26 11:14:32 UTC - Size: 11.14 KB - 48 views
[2026-08-26 13:04:30]
User512353 - Posts: 190
A more dramatic screenshot.
You can see where the first exit was triggered, but only for 1 position.
Would have been a nice trade if ALL positions had exited.
But the triggers only fired for 1 (or few) positions.
The bulk was probably cancelled on a reversal. Would have to look at it in detail.
imageScreenshot From 2026-08-26 12-59-03.png / V - Attached On 2026-08-26 13:04:27 UTC - Size: 34 KB - 46 views
[2026-08-26 14:17:30]
Sawtooth - Posts: 4357
One possibility:
The exit quantity uses J26 unless J82/J83 are active.
[2026-08-26 14:35:16]
User512353 - Posts: 190
Yes, this seems to be the problem.
But I wonder how this came to be.
I suspect that it results from old values remaining when switching the spreadsheet to v2 values.
E.g. v2:J69=1, v2:J70=0, v2:J71=M (!?!?) was what I found.
When I set v2:J70=1, v2:J71=<blank> the problem disappears.

This was the first time I ever used v2 values.
Maybe this explains why I never had such problems before.
The v2:J71=M definitely looks malignant.

Thanks, Sawtooth!
[2026-08-26 14:54:51]
Sawtooth - Posts: 4357
My opinion on v2:
https://www.sawtoothtrade.com/blog

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account